distinct x.signer_id,

count(distinct x.tx_hash) as transactions,

sum(TRY_CAST(REGEXP_REPLACE(args:amt, '[^0-9]', '') AS NUMBER))/100000000 as neat_amount,

sum(transaction_fee/pow(10,24)) as fees_in_near,

avg(transaction_fee/pow(10,24)) as avg_tx_fee_in_near,

sum(gas_used/pow(10,18)) as gas_spent,

avg(gas_used/pow(10,18)) as avg_tx_gas_spent

from near.core.fact_actions_events_function_call x

join near.core.fact_transactions y on x.tx_hash=y.tx_hash

where method_name='inscribe'

and action_name='FunctionCall'

and args:op='mint' and args:p='nrc-20' and args:tick='neat'

group by 1

order by 6 desc

limit 10