tx_signer as "Wallet",

SUM(transaction_fee/pow(10,24)) AS "Total TX fees"

FROM near.core.fact_transactions

WHERE TX_SIGNER IN

SELECT

distinct tx_signer

FROM near.core.fact_transactions

WHERE tx_receiver = 'nethmap.near'

AND block_timestamp >= '2022-12-18'

)

GROUP by 1

order by 2 DESC

limit 10