d.player

, d.team

, count(distinct s.tx_id) sales_ct

from flow.core.fact_nft_sales s

inner join flow.core.dim_topshot_metadata d

on s.nft_id = d.nft_id

where s.tx_succeeded = TRUE

and s.nft_collection = 'A.0b2a3299cc857e29.TopShot'

and date(s.block_timestamp) >= date('2022-05-17')

and date(s.block_timestamp) <= date('2022-05-29')

group by 1,2

order by 3 desc