select distinct to_address

from ethereum.core.fact_transactions

where from_address = '0xc2f41b3a1ff28fd2a6eee76ee12e51482fcfd11f'

),

Shrooms as (

select distinct nft_to_address

from ethereum.core.ez_nft_mints

where nft_address = '0xdfb57b6e16ddb97aeb8847386989f4dca7202146'

select count (s.nft_to_address),

case

when f.to_address IS NOT NULL then 'bounty hunter'

else 'first time Flipsider'

end as type

from Shrooms s

left join FS_addresses f

on s.nft_to_address = f.to_address

group by type