from ethereum.dex_swaps

where token_address in ( '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'

,'0xa2b4c0af19cc16a6cfacce81f192b024d625817d'

, '0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3'

,'0xfad45e47083e4607302aa43c65fb3106f1cd7607'

, '0xd0660cd418a64a1d44e9214ad8e459324d8157f1' )

and platform LIKE '%sushiswap%'

group by 1

) ,

other as ( SELECT token_address , sum(amount_usd) as swap_amount

from ethereum.dex_swaps

where token_address in ( '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'

,'0xa2b4c0af19cc16a6cfacce81f192b024d625817d'

, '0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3'

,'0xfad45e47083e4607302aa43c65fb3106f1cd7607'

, '0xd0660cd418a64a1d44e9214ad8e459324d8157f1' )

and platform LIKE '%uniswap%'

group by 1

)

SELECT L.address_name as token , S.swap_amount as sushiswap, O.swap_amount as Other_swap_platform

from sushi s , other O

left outer join ethereum.labels L on O.token_address = L.address

where S.token_address= O.token_address