misaghlb$OP Airdrop - distribution
    Updated 2022-11-15
    WITH claimed AS (
    select raw_amount/1e18 as balance
    from optimism.core.fact_token_transfers
    where contract_address = '0x4200000000000000000000000000000000000042'
    and from_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
    ),
    balances_dist as (
    SELECT
    case
    when balance >=5000 then 'More Than 5K'
    when balance <5000 and balance >= 2000 then '2K - 5K'
    when balance <2000 and balance >= 1000 then '1K - 2K'
    when balance <1000 and balance >= 500 then '500 - 1K'
    when balance <500 then 'less than 500'
    end as bal_dist
    from claimed
    )
    SELECT bal_dist, count(bal_dist) as counts from balances_dist
    where bal_dist is not NULL
    group by bal_dist

    Run a query to Download Data