A as(

select sum(case when amount_out_usd is not null then amount_out_usd else amount_in_usd end) as volume

from avalanche.defi.ez_dex_swaps

where year(block_timestamp) = '2024'

and platform like '%joe%' ),

B as(

select sum(case when amount_out_usd is not null then amount_out_usd else amount_in_usd end) as volume

from avalanche.defi.ez_dex_swaps

where year(block_timestamp) = '2024' ),

C as(

select 'Trader Joe' as tag, volume from A union all

select 'Avax Dex' as tag, volume - (select volume from A) from B)

select *, volume/sum(volume) over()*100 as ratio from C