label_type,

count(distinct tx_hash) as transactions,

count(distinct tx_signer) as users,

transactions/ users as transactions_per_user,

sum(transaction_fee/1e24) as tx_fee_near,

avg(transaction_fee/1e24) as average_tx_fee_near,

median(transaction_fee/1e24) as median_tx_fee_near

from near.core.fact_transactions b

join near.core.dim_address_labels c

on address = tx_receiver

where tx_status = 'Success'

group by 1

order by tx_fee_near desc

limit 10