WITH blast AS(

SELECT

block_timestamp,

tx_hash,

decoded_log:amount / POW(10, 18) AS amount,

decoded_log:delegatedRecipient AS claimer

FROM blast.core.ez_decoded_event_logs

WHERE contract_address = lower('0xF7bE503166828Fe8565C520D66645aC6A06BBdd7')

AND event_name = 'AirdropClaimed'

AND tx_status = 'SUCCESS'

CASE WHEN amount < 100 THEN '< 100'

WHEN amount BETWEEN 100 AND 10000 THEN '100 - 10000'

WHEN amount BETWEEN 10000 AND 100000 THEN '10000 - 100000'

WHEN amount BETWEEN 100000 AND 1000000 THEN '100000 - 1000000'

ELSE '> 1000000'

END AS "$Blast claimed",

COUNT(*) AS no_of_claimers

FROM blast

GROUP BY 1