b.team AS team,

Count(DISTINCT a.tx_id) AS no_of_transactions,

CASE

WHEN a.block_timestamp >= '2022-05-17'

AND a.block_timestamp <= '2022-05-29' THEN

'During NBA Conference finals'

WHEN a.block_timestamp >= '2022-05-07'

AND a.block_timestamp < '2022-05-17' THEN

'Before NBA Conference finals'

WHEN a.block_timestamp > '2022-05-29'

AND a.block_timestamp <= '2022-06-09' THEN

'After NBA Conference finals'

END AS time_period,

Count(DISTINCT a.buyer) AS no_of_wallets,

Sum(a.price) AS total_volume

FROM flow.core.fact_nft_sales a

JOIN flow.core.dim_topshot_metadata b

ON a.nft_id = b.nft_id

AND a.nft_collection = b.nft_collection

WHERE a.marketplace IN ( 'A.c1e4f4f4c4257510.Market',

'A.c1e4f4f4c4257510.TopShotMarketV3' )

AND a.nft_collection = 'A.0b2a3299cc857e29.TopShot'

AND a.tx_succeeded = 'TRUE'

AND a.block_timestamp >= '2022-05-07'

AND a.block_timestamp <= '2022-06-09'

AND b.team IN ( 'Dallas Mavericks', 'Boston Celtics',

'Golden State Warriors',

'Miami Heat' )

GROUP BY day,

team,

time_period

ORDER BY day DESC