from (select *

from (select TX_RECEIVER,

sum(fee) as total_fee,

sum(used_gas) as gas,

count(*) as total_txs

from (SELECT BLOCK_TIMESTAMP,

TX_RECEIVER,

TRANSACTION_FEE/1e24 as fee,

gas_used/1e12 as used_gas,

TX_HASH

FROM near.core.fact_transactions

)

group by 1

order by 3 desc

)

)

order by 3 desc

limit 10