select
count(txn_hash),
sum(gas_used)/power(10,12) as sum_gas_used,
sum(transaction_fee)/power(10,24) as sum_fee,
tx_receiver
-- tx_signer
from
flipside_prod_db.mdao_near.transactions
where
block_timestamp::date >= '2022-06-23'
group by
tx_receiver
order by
sum_fee desc
limit
10000