strawbettyAmount that left to distribute
    Updated 2022-05-08
    with claim as (select
    count(distinct EVENT_INPUTS:account) claimers,
    sum(EVENT_INPUTS:amount/1e18) amount_distributed
    from
    ethereum_core.fact_event_logs
    where contract_address = lower('0x1026cbed7b7E851426b959BC69dcC1bf5876512d')
    and block_timestamp >= '2021-09-24'
    and EVENT_NAME = 'Claimed' ),

    total as (SELECT
    count(distinct address) farmers,
    sum(amount) amount_left
    from ethereum_sushi.dim_distributor_reward_schedule
    where merkle_root = '0x015e6c2cd1a4d6fa77aa1884c436b2435aae4beab5c9a091f18fd0c00dc7e577')

    select
    claim.claimers,
    total.farmers,
    claim.claimers/total.farmers * 100 user_percent_claimed,
    claim.amount_distributed,
    total.amount_left ,
    (claim.amount_distributed/(total.amount_left + claim.amount_distributed )) * 100 amount_percent_distributed
    from claim,total
    Run a query to Download Data