play_type as "Play Type",

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

avg(price) as "Average Sales",

sum(price) as "Total Sales"

from flow.core.ez_nft_sales left outer join flow.core.dim_allday_metadata

using (nft_id)

where play_type is not null

group by 1

order by 4 desc

limit 5