play_type as "Play Type",

nflallday_id as "NFL ID",

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

avg(price) as "Average Sales",

sum(price) as "Total Sales",

median(price) as "Median Sales"

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

using (nft_id)

where play_type like '%{{ play_type }}%'

group by 2, 1

order by 4 desc, 2 desc