select PURCHASER

,case

when BLOCK_TIMESTAMP>='2022-11-07' and BLOCK_TIMESTAMP<'2022-11-14'then 'one week after ftx chaos'

when BLOCK_TIMESTAMP>='2022-10-31' and BLOCK_TIMESTAMP<'2022-11-07'then 'one week before ftx chaos' end as chaos_time

,count(distinct TX_ID)as sales_count

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)

select chaos_time

,avg(sales_count) as "Avg Sales count"

from tab1

group by 1