SELECT date(BLOCK_TIMESTAMP) as "FINAL DAYS",

COUNT(TEAM) AS "FINAL SALES NUMBER"

FROM flow.core.dim_topshot_metadata t

INNER JOIN flow.core.fact_nft_sales n on t.NFT_ID=n.NFT_ID

WHERE block_timestamp BETWEEN '2022-05-15' AND '2022-05-30'

AND TEAM IN ('Dallas Mavericks')

GROUP BY 1

ORDER by 1

), TOTVOLUME as (

SELECT date(BLOCK_TIMESTAMP) as "LAST TWO MONTH",

COUNT(TEAM) AS "LAST TWO MONTH SALES NUMBER"

FROM flow.core.dim_topshot_metadata t

INNER JOIN flow.core.fact_nft_sales n on t.NFT_ID=n.NFT_ID

WHERE block_timestamp BETWEEN '2022-04-30' AND '2022-07-02'

AND TEAM IN ('Dallas Mavericks')

GROUP BY 1

ORDER by 1

)

SELECT "LAST TWO MONTH",

"LAST TWO MONTH SALES NUMBER",

FROM TOTVOLUME FULL JOIN FINVOLUME on "LAST TWO MONTH"="FINAL DAYS"

GROUP by 1,2,3

ORDER by 1