-- date_trunc('week', block_timestamp) as week,

token_name,

count(*) as sales,

sum(sales_amount) as volume,

median(sales_amount) as token_price,

FROM solana.core.fact_nft_sales

LEFT OUTER JOIN solana.core.dim_nft_metadata

ON solana.core.fact_nft_sales.mint = solana.core.dim_nft_metadata.mint

WHERE token_name IN ('Degen Apes', 'Okay Bears', 'DeGods', 'Aurory', 'ABC', 'Trippin’ Ape Tribe', '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')

GROUP BY 1--,2