SELECT block_timestamp, tx_hash, to_address AS bridger,

amount

FROM sei.core_evm.ez_token_transfers

WHERE contract_address = '0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1'

AND from_address = '0xf70da97812cb96acdf810712aa562db8dfa3dbef'

),

distx AS (

SELECT bridger,

COUNT(DISTINCT tx_hash) AS transaction_count

FROM relaycte

GROUP BY bridger

SELECT

COUNT(DISTINCT bridger) AS bridgers,

CASE

WHEN transaction_count < 2 THEN '<2'

WHEN transaction_count >= 2 AND transaction_count < 5 THEN '2-5'

WHEN transaction_count >= 5 AND transaction_count < 10 THEN '5-10'

WHEN transaction_count >= 10 AND transaction_count < 20 THEN '10-20'

WHEN transaction_count >= 20 THEN '>20'

END AS Amount_Category

FROM distx

GROUP BY Amount_Category

ORDER BY Amount_Category;