play_category,

avg(PRICE),

sum(PRICE)

FROM flow.core.fact_nft_sales

LEFT OUTER JOIN flow.core.dim_topshot_metadata ON flow.core.fact_nft_sales.nft_id = flow.core.dim_topshot_metadata.nft_id

AND flow.core.fact_nft_sales.NFT_COLLECTION = flow.core.dim_topshot_metadata.NFT_COLLECTION

WHERE not PLAYER_STATS_SEASON_TO_DATE is NULL

and block_timestamp>=CURRENT_DATE - 30

GROUP BY 1

ORDER by 1