date(s.block_timestamp) dt

, case when m.purchaser = 'GenoS3ck8xbDvYEZ8RxMG3Ln2qcyoAN8CTeZuaWgAoEA' then 'Genopets' when m.purchaser = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' then 'StepN' else 'Other' end minter

, count(distinct s.tx_id) sales_cts

from solana.core.fact_nft_mints m -- Ties Project to NFT

inner join solana.core.fact_nft_sales s -- Gets Sales

on m.mint = s.mint

where m.succeeded = TRUE

and s.succeeded = TRUE

and m.purchaser in ('GenoS3ck8xbDvYEZ8RxMG3Ln2qcyoAN8CTeZuaWgAoEA', 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK')

and m.mint not in ('AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB','7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx','GENEtH5amGSi8kHAtQoezp1XEXwZJ8vcuePYnXdKrMYz','kiTkNc7nYAu8dLKjQFYPx3BqdzwagZGBUrcb7d4nbN5')

group by 1,2

order by 3 DESC