SELECT

DISTINCT TO_ADDRESS AS address,

sum(raw_amount / 1e18) AS amount

FROM arbitrum.core.fact_token_transfers

WHERE

contract_address = lower('0x6985884C4392D348587B19cb9eAAf157F13271cd')

AND FROM_ADDRESS = lower('0xd6b6a6701303b5ea36fa0edf7389b562d8f894db')

group by 1

),

total_claimors as (

select count(distinct address) as claimers from zro_claimed

),

b AS (

SELECT

address,

amount,

CASE

WHEN amount > 10000 THEN '>10k'

WHEN amount > 5000 AND amount <= 10000 THEN '5k - 10k'

WHEN amount > 2500 AND amount <= 5000 THEN '2.5k - 5k'

WHEN amount > 1000 AND amount <= 2500 THEN '1k - 2.5k'

WHEN amount > 500 AND amount <= 1000 THEN '500 - 1k'

WHEN amount > 250 AND amount <= 500 THEN '250 - 500'

WHEN amount > 145 AND amount <= 250 THEN '145 - 250'

WHEN amount > 50 AND amount <= 145 THEN '50 - 145'

WHEN amount > 25 AND amount <= 50 THEN '25 - 50'

WHEN amount <= 25 THEN '<25'

END AS category

FROM zro_claimed

select category, percent_claimors, sum(percent_claimors) over (ORDER BY

CASE category

WHEN '>10k' THEN 1

WHEN '5k - 10k' THEN 2