select

case

when TO_ASSET='ETH.ETH' then 'ETH on ETH'

when TO_ASSET='ETH.USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7' then 'USDT on ETH'

when TO_ASSET='ETH.WBTC-0X2260FAC5E5542A773AA44FBCFEDF7C193BC2C599' then 'WBTC on ETH'

when TO_ASSET='ETH.USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48' then 'USDC on ETH'

when TO_ASSET='AVAX.AVAX' then 'AVAX on AVAX'

end as to_token

,sum(from_amount_usd) as volume

from thorchain.defi.fact_swaps

where BLOCK_TIMESTAMP::date>=current_date-60

and BLOCKCHAIN='BSC'

and AFFILIATE_ADDRESS='lifi'

and to_asset not in ('THOR.RUNE')

group by 1

order by 2 desc

limit 5