select
player,
sum(price),
avg(price),
count(*),
max(price),
min(price)
from flow.core.ez_nft_sales left outer join flow.core.dim_allday_metadata
on flow.core.ez_nft_sales.nft_id = flow.core.dim_allday_metadata.nft_id
where block_timestamp > current_date - 11
and player in ('Christian McCaffrey', 'Jonathan Taylor', 'Austin Ekeler', 'Alvin Kamara', 'Derrick Henry', 'Saquon Barkley' ,-- RB
'Josh Allen', 'Lamar Jackson', 'Justin Herbert', 'Jalen Hurts', 'Russell Wilson', -- QB
'Cooper Kupp', 'Justin Jefferson', 'JaMarr Chase', 'CeeDee Lamb', 'Davante Adams', -- WR
'Mark Andrews', 'Travis Kelce' , 'Kyle Pitts', 'Darren Waller', 'Dalton Schultz') -- TE
and player is not null
group by 1
order by 2 desc