TEAM,

count(DISTINCT buyer) as buyers,

sum(price) as sales_volume,

avg(price) as average_price

FROM flow.core.ez_nft_sales

LEFT OUTER JOIN flow.core.dim_allday_metadata

ON flow.core.ez_nft_sales.nft_id = flow.core.dim_allday_metadata.nft_id

WHERE NOT NFLALLDAY_ID is NULL

GROUP BY 1