count(distinct tx_id) as "Total Sales Transactions",

avg(price) as "Average Sales",

sum(price) as "Total Sales"

from flow.core.ez_nft_sales join flow.core.dim_allday_metadata

using (nft_id)

where player != 'N/A'

group by 1

order by 4 desc