DISTINCT to_address as address

from optimism.core.fact_token_transfers

where contract_address = '0x4200000000000000000000000000000000000042'

and from_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'),

claimer_data as (

select COUNT(DISTINCT from_address) as wallet

from optimism.core.fact_token_transfers as s

where s.contract_address = '0x4200000000000000000000000000000000000042'

and from_address in (SELECT address from claimer)),

claimresult as ( select count(address) as wallets from claimer )

select claimresult.wallets - claimer_data.wallet as hodlers, 'Holder' as type from claimresult join claimer_data

UNION select claimer_data.wallet as claimers, 'Seller' as type from claimer_data