Alexaydelagation
    Updated 2022-09-28
    -- https://app.flipsidecrypto.com/velocity/queries/ff4775f8-c6b7-4a8c-8df8-8aa7b57231e1

    WITH tab1 as ( SELECT ORIGIN_FROM_ADDRESS as users, sum(raw_amount / power(10, decimals)) as claim_volume
    FROM optimism.core.fact_token_transfers
    LEFT outer JOIN optimism.core.dim_contracts
    ON address = contract_address
    WHERE symbol LIKE 'OP'
    AND from_address LIKE lower('0xFeDFAF1A10335448b7FA0268F56D2B44DBD357de')
    AND ORIGIN_FUNCTION_SIGNATURE LIKE '0x2e7ba6ef'
    GROUP BY 1 ),
    tab2 as ( SELECT users, CASE WHEN DELEGATOR is null THEN 'Not-Delegators' ELSE 'Delegators' END as user_group
    FROM tab1
    LEFT outer JOIN optimism.core.fact_delegations
    ON users = DELEGATOR)


    SELECT user_group, count(*) as users
    FROM tab2
    GROUP BY 1
    Run a query to Download Data