PURCHASER,

min(block_timestamp) as first_sale

FROM solana.fact_nft_sales a

JOIN solana.dim_nft_metadata b ON a.mint = b.mint

WHERE contract_name = 'Okay Bears'

AND marketplace in ('opensea', 'magic eden v2')

AND block_timestamp >= '2022-04-24'

GROUP BY PURCHASER )

b.Label as protocol,

count(a.signers[0]) as n_users

FROM solana.core.fact_transactions a

JOIN solana.core.dim_labels b ON a.instructions[0]:programId = b.address

JOIN okayB_buyers c ON a.signers[0] = c.PURCHASER

WHERE a.block_timestamp > c.first_sale

--a.signers[0] in (select PURCHASER from okayB_buyers)

AND b.label_subtype != 'token_contract'

AND b.LABEL_TYPE!='nft'

AND b.label != 'solana'

GROUP BY protocol