player,

count(distinct buyer) as users,

sum(price) as sales_volume,

count(tx_id) as sales

FROM flow.core.ez_nft_sales

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

WHERE nflallday_id is not null and player <> 'N/A'

GROUP BY 1