case when token0_symbol = 'WETH' then amount0_usd when token1_symbol = 'WETH' then amount1_usd

end as WETH_USD_withdrawn, case when token0_symbol = 'WETH' then amount0_adjusted

when token1_symbol = 'WETH' then amount1_adjusted

end as WETH_withdrawn from ethereum.uniswapv3.ez_lp_actions

where (token0_symbol = 'WETH' or token1_symbol = 'WETH')

and action = 'DECREASE_LIQUIDITY'

and day >= '2022-06-01')

select day,case when day >= '2022-09-01' then '2 Weeks Prior to The Merge'

else 'Other Days'

end as periods, sum(WETH_USD_withdrawn),sum(WETH_withdrawn)

from min1 group by 1