FROM flow.core.fact_nft_sales

WHERE nft_id IN (SELECT distinct nft_id FROM flow.core.dim_topshot_metadata WHERE nft_collection LIKE '%TopShot%' AND team = 'Golden State Warriors')

AND date1 BETWEEN '2022-05-01' AND '2022-05-31'

GROUP by date1),

celtics AS (SELECT date(block_timestamp) as date2, COUNT(DISTINCT tx_id) as sale_volume_celtics

FROM flow.core.fact_nft_sales

WHERE nft_id IN (SELECT distinct nft_id FROM flow.core.dim_topshot_metadata WHERE nft_collection LIKE '%TopShot%' AND team = 'Boston Celtics')

AND date2 BETWEEN '2022-05-01' AND '2022-05-31'

GROUP by date2),

mavericks AS (SELECT date(block_timestamp) as date3, COUNT(DISTINCT tx_id) as sale_volume_mavericks

FROM flow.core.fact_nft_sales

WHERE nft_id IN (SELECT distinct nft_id FROM flow.core.dim_topshot_metadata WHERE nft_collection LIKE '%TopShot%' AND team = 'Dallas Mavericks')

AND date3 BETWEEN '2022-05-01' AND '2022-05-31'

GROUP by date3),

heat AS (SELECT date(block_timestamp) as date4, COUNT(DISTINCT tx_id) as sale_volume_heat

FROM flow.core.fact_nft_sales

WHERE nft_id IN (SELECT distinct nft_id FROM flow.core.dim_topshot_metadata WHERE nft_collection LIKE '%TopShot%' AND team = 'Miami Heat')

AND date4 BETWEEN '2022-05-01' AND '2022-05-31'

GROUP by date4)

SELECT date1 as date, sale_volume_warriors, sale_volume_celtics, sale_volume_mavericks, sale_volume_heat

FROM warriors LEFT JOIN celtics on date1 = date2

LEFT JOIN mavericks ON date1 = date3

LEFT JOIN heat ON date1 = date4

ORDER BY date