TO_ADDRESS,

COUNT(DISTINCT TX_HASH) AS tx_count,

ARRAY_AGG(TX_HASH) AS aggregated_tx_hash_list

(

SELECT

TO_ADDRESS,

TX_HASH

FROM

monad.testnet.fact_transactions

WHERE

FROM_ADDRESS = LOWER('0xD7a24d1F1435CD314E86736E139f8431D4498D4e')

AND VALUE = 2

AND TX_SUCCEEDED

AND BLOCK_TIMESTAMP > DATEADD(HOUR, -12, CURRENT_TIMESTAMP())

--select the right BLOCK_TIMESTAMP

ORDER BY

TX_HASH

) AS sorted_tx

GROUP BY

TO_ADDRESS

COUNT(DISTINCT TX_HASH) > 2

ORDER BY

tx_count DESC;