count(*) as wallets

FROM (SELECT owner,

CASE WHEN DELEGATOR is null THEN 'not deligated'

ELSE 'delegated' END as type

FROM (SELECT ORIGIN_FROM_ADDRESS as owner,

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

)

LEFT outer JOIN optimism.core.fact_delegations

ON owner = DELEGATOR

)

GROUP BY 1