date_trunc(month, block_timestamp)as date,

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,2

order by 1