select case when '{{Time_Frame}}' = 'Last 7 Days' then 7

when '{{Time_Frame}}' = 'Last 14 Days' then 14

when '{{Time_Frame}}' = 'Last 30 Days' then 30

when '{{Time_Frame}}' = 'Last 60 Days' then 60

when '{{Time_Frame}}' = 'Last 90 Days' then 90

when '{{Time_Frame}}' = 'Last 180 Days' then 180

when '{{Time_Frame}}' = 'Last 365 Days' then 365

when '{{Time_Frame}}' = 'All Time' then 3000

else 2000 end as timeframe)

select project_name as "NFT Collection",

count (distinct tx_id) as "Sales",

count (distinct buyer_address) as "Buyers",

count (Distinct seller_address) as "Sellers",

count (distinct token_id) as "Traded Tokens",

sum (amount) as "Sales Volume [SEI]",

sum (amount_usd) as "Sales Volume [USD]",

avg (amount) as "Average Price [SEI]",

avg (amount_usd) as "Average Price [USD]",

min (amount) as "Floor Price [SEI]",

min (amount_usd) as "Floor Price [USD]",

max (amount) as "Price Ceiling [SEI]",

max (amount_usd) as "Price Ceiling [USD]"

from sei.nft.ez_nft_sales t1 join timetable

where tx_succeeded = 'TRUE'

and block_timestamp >= current_date - timeframe

group by 1 having "NFT Collection" is not null

order by 2 desc

limit 1000