FROM flow.core.fact_nft_sales

INNER JOIN flow.core.dim_topshot_metadata

ON flow.core.dim_topshot_metadata.nft_id = flow.core.fact_nft_sales.nft_id

AND flow.core.fact_nft_sales.tx_succeeded = 'TRUE'

AND flow.core.fact_nft_sales.block_timestamp >= '2022-05-17' AND flow.core.fact_nft_sales.block_timestamp <= '2022-05-29'

AND flow.core.fact_nft_sales.nft_collection = 'A.0b2a3299cc857e29.TopShot'

-- flow.core.dim_topshot_metadata.team = 'Golden State Warriors'

--OR flow.core.dim_topshot_metadata.team = 'Miami Heat'

-- OR flow.core.dim_topshot_metadata.team = 'Boston Celtics'

-- OR flow.core.dim_topshot_metadata.team = 'Dallas Mavericks'

--)--

GROUP BY flow.core.dim_topshot_metadata.team

ORDER BY topshot_sales desc