mo1154- OP 5th airdrop - claims
    Updated 2024-10-10
    with claims as (
    select count(TO_ADDRESS) as wallets,
    sum(AMOUNT) as claimed,
    'op' as token
    from optimism.core.ez_token_transfers
    where FROM_ADDRESS= '0x9a69d97a451643a0bb4462476942d2bc844431ce'
    and CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'),
    total as (
    select
    sum(AMOUNT) as total,
    'op' as token
    from optimism.core.ez_token_transfers
    where TO_ADDRESS= '0x9a69d97a451643a0bb4462476942d2bc844431ce'
    and CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'
    )
    select wallets, claimed,total, c.token, (claimed/total)*100 as "% of claimed "
    from claims c join total t on c.token=t.token
    QueryRunArchived: QueryRun has been archived