PLAYER,

avg(price) as avg_price,

median(price) as median_price,

count(*) as sales_events,

sum(price)

FROM flow.core.ez_nft_sales

LEFT outer JOIN flow.core.dim_allday_metadata

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

WHERE flow.core.ez_nft_sales.nft_collection LIKE '%AllDay'

GROUP BY 1