tx_signer as "Wallet",

count(DISTINCT tx_hash) as "Number of TXs"

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