with tab1 as (

select MINT,SALES_AMOUNT

,case

when BLOCK_TIMESTAMP>='2022-11-07' then 'after ftx chaos'

when BLOCK_TIMESTAMP<'2022-11-07' and BLOCK_TIMESTAMP>='2022-10-07'then 'One Month before ftx chaos' end as chaos_time

from solana.core.fact_nft_sales

where (MARKETPLACE='magic eden v1' or MARKETPLACE='magic eden v2')

and chaos_time is not null

group by 1,2,3),

tab2 as (

select mint,PROJECT_NAME

from solana.core.dim_nft_metadata)

select PROJECT_NAME,max(SALES_AMOUNT)as max_price,chaos_time

from tab1

left join tab2

on tab1.mint=tab2.mint

and PROJECT_NAME in('Solana Monkey Business','Okay Bears','Cets On Creck','DeGods','Blocksmith Labs',

'Communi3: Mad Scientists','Jelly Rascals','ABC','Degen Apes','Cyber Frogs')

where PROJECT_NAME is not null

group by 1,3

order by 2 desc