initcap(token_name) as NFT_Collection,

count (distinct tx_id) as Sales_Count,

count (distinct purchaser) as Buyers_Count,

count (distinct seller) as Sellers_Count,

sum (sales_amount) as Total_Volume,

avg (sales_amount) as Average_Volume,

median (sales_amount) as Median_Volume,

min (sales_amount) as Floor_Price,

max (sales_amount) as Price_Ceiling

from solana.core.fact_nft_sales t1 left outer join solana.core.dim_nft_metadata t2 on t1.mint = t2.mint

where (token_name in ('Degen Apes', 'Okay Bears', 'DeGods', 'Aurory', 'ABC', 'Cets On Creck', 'Galactic Geckos', 'Shadowy Super Coder', 'Primates', 'Blocksmith Labs', 'SolPunks', 'Solana Monkey Business', 'Thugbirdz', 'Communi3: Mad Scientists', 'Famous Fox Federation', 'Catalina Whale Mixer', 'Bold Badgers', 'Just Ape.', 'Stoned Ape Crew', 'Vandal City', 'Reptilian Renegade Lizards', 'Meerkat Millionaires', 'TombStoned High Society', 'Astrals')

or token_name ilike '%Ape Tribe')

and succeeded = 'TRUE'

group by 1,2