with a AS(

SELECT

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS,

ORIGIN_TO_ADDRESS,

CONTRACT_ADDRESS,

AMOUNT_IN,

AMOUNT_OUT,

SYMBOL_IN,

SYMBOL_OUT

FROM

bsc.defi.ez_dex_swaps

WHERE

CONTRACT_ADDRESS = '0x9f0e0eb8886d7279b33a81c40e70a12f69861d5b'

-- and BLOCK_TIMESTAMP BETWEEN '2024-04-05 08:50:00.000'

-- AND '2024-04-05 10:50:40.000'

and SYMBOL_IN = 'WBNB'

ORDER by

BLOCK_TIMESTAMP ASC

count(TX_HASH),

ORIGIN_FROM_ADDRESS,

a

GROUP by

ORIGIN_FROM_ADDRESS