select BLOCK_TIMESTAMP::date as date

,case

when date>='2023-03-01' and date<='2023-03-10' then 'TEN DAYS BEFORE LAUNCHE'

when date>='2023-03-11' and date<='2023-03-20' then 'TEN DAYS AFTER LAUNCHE' end as t_period

,sum(AMOUNT) as Burned_shib

from ethereum.core.ez_token_transfers

where date>='2023-01-01'

and TO_ADDRESS ='0xdead000000000000000042069420694206942069'

and CONTRACT_ADDRESS='0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'

and t_period is not null

group by 1,2)

select t_period

,avg(Burned_shib) as avg_burned

from tab1

group by 1