distinct PURCHASER as users,

min(BLOCK_TIMESTAMP) as first_use,

tx_id

from solana.core.fact_nft_sales

where tx_id is not NULL

and BLOCK_TIMESTAMP>='2022-01-01'

group by 1,3

)

select

b.PROJECT_NAME as NFTs,

count(TX_ID) as usages

from solana.core.fact_nft_sales s left outer join solana.core.dim_nft_metadata b on s.mint=b.MINT

where tx_id in (select tx_id from tb1)

and SUCCEEDED='TRUE'

group by 1 having NFTs is not null

order by 2 desc