moment_stats_full:flowID as "NFT ID",

moment_tier as "Tier",

player as "Player Name",

case

when moment_stats_full:metadata:playerPosition = 'RB' then 'Running Back (RB)'

when moment_stats_full:metadata:playerPosition = 'LB' then 'Linebacker (LB)'

when moment_stats_full:metadata:playerPosition = 'WR' then 'Wide Receiver (WR)'

when moment_stats_full:metadata:playerPosition = 'DB' then 'Defensive Backs (DB)'

when moment_stats_full:metadata:playerPosition = 'QB' then 'Quarterback (QB)'

when moment_stats_full:metadata:playerPosition = 'K' then 'Kicker (K)'

when moment_stats_full:metadata:playerPosition = 'P' then 'Punter (P)'

when moment_stats_full:metadata:playerPosition = 'TE' then 'Tight End (TE)'

when moment_stats_full:metadata:playerPosition = 'OL' then 'Offensive Linemen (OL)'

when moment_stats_full:metadata:playerPosition = 'DL' then 'Defensive Line (DL)'

end as "Player Position",

team as "Team Name",

moment_stats_full:metadata:awayTeamName as "Away Team Name",

season as "Season",

week as "Week",

date_trunc('day', moment_date) as "Moment Date",

series as "Series",

set_name as "Set Name",

classification as "Classification",

play_type as "Play Type",

avg(price) as "Average Sales $",

max(price) as "Top Sales $",

min(price) as "Minimum Sales $"

from flow.core.ez_nft_sales s join flow.core.dim_allday_metadata m on s.nft_id = m.nft_id

where price is not null

group by 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13