main AS (

select

case

when PROJECT_NAME in ('dforce', 'dforce network') then 'dforce network'

when PROJECT_NAME in ('plutusdao', 'plutus dao') then 'plutus dao'

else PROJECT_NAME

end AS Project,

case

when project = 'uniswap' then 291462380.826997

when project = 'hop protocol' then 18022951.3045608

when project = 'sushiswap' then 121691578.2

when project = 'radiant' then 198386938.3

when project = 'gmx' then 500661911.4

when project = 'camelot' then 110618557.2

when project = 'zyberswap' then 28550506.16

when project = 'aave' then 105827998

when project = 'stargate finance' then 77441587.76

when project = 'vesta finance' then 16882060.77

when project = 'dopex' then 28246034.89

when project = 'gains network' then 36868338.51

when project = 'curve finance' then 79064999.14

when project = 'balancer' then 63091526.86

when project = 'abracadabra money' then 32941680.2

when project = '3xcalibur' then 9020052.987

when project = 'alienfi' then 4369457.439

when project = 'angle protocol' then 229104.4958

when project = 'buffer finance' then 1695498.606

when project = 'camelot' then 110618557.2

when project = 'cap finance' then 2800000

when project = 'connext' then 4528.748279

when project = 'dforce network' then 14015206.44

when project = 'elk finance' then 64266.02073

when project = 'el dorado exchange' then 1444172.675

when project = 'handle fi ' then 1715498.606

when project = 'jarvis network' then 1329458.921