player,

avg(price) as Average_Sales_Price,

sum(price) as Total_Sales_Volume,

count(*)

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 play_type is not null

group by 1