sushi_txs as (select date(block_timestamp) as day_, avg(fee_usd) as sushi_fee from ethereum.transactions

where tx_id in (select tx_id as tx from ethereum.dex_swaps

where platform like '%sushiswap%')

GROUP by day_ )

SELECT * from (select *,

(uni_fee-sushi_fee)/sushi_fee*100 as percent_fee_higher_than_uni ,

case when uni_fee> sushi_fee then '0' else '1' end as sushi_cheaper_today

from

(select date(block_timestamp) as day, avg(fee_usd) as uni_fee from ethereum.transactions

where tx_id in (select tx_id as tx from ethereum.dex_swaps

where platform like '%uniswap%')

GROUP by day )

inner join sushi_txs

on day = day_ )

WHERE day > CURRENT_DATE-60

limit 100