nflallday_id as nfl_id,

sum(price) as total_sales_price,

avg(price) as average_sales_price,

median(price) as median_sales_price,

count(distinct(tx_id)) as tx_num,

count(distinct(player)) as player_num,

count(distinct(play_type)) as play_type_num

from flow.core.dim_allday_metadata a join flow.core.ez_nft_sales b

on a.nft_id = b.nft_id

where player != 'N/A'

group by nflallday_id

order by total_sales_price desc

limit 10