date_trunc('day', block_timestamp) as day,

player,

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

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'

and player in ('Tom Brady', 'Patrick Mahomes II', 'Justin Herbert')

group by day, player

order by day, total_sales_price desc