FROM_ADDRESS as wallet

,count(distinct TX_HASH) as tx_count

,count(distinct TO_ADDRESS) as address_count

,count(distinct date(BLOCK_TIMESTAMP)) as tx_date_count

from

select

FROM_ADDRESS

,TO_ADDRESS

,TX_HASH

,BLOCK_TIMESTAMP

from monad.testnet.fact_transactions

) a

group by 1

order by address_count desc