WITH nba_sales AS (
SELECT
block_timestamp::date as date,
nft_id,
price,
tx_id
FROM flow.core.fact_nft_sales
WHERE nft_collection = 'A.0b2a3299cc857e29.TopShot'
)
SELECT
b.PLAY_TYPE,
COUNT(a.tx_id),
sum(a.price) as total_sales_usd
FROM nba_sales as a JOIN
flow.core.dim_topshot_metadata as b ON
a.nft_id = b.nft_id
GROUP BY b.PLAY_TYPE
ORDER BY total_sales_usd DESC