from algorand.asset

UNION

select 0 , 'Algo')

select sum(t1.SWAP_TO_AMOUNT) as total_swap_amount,COUNT(1) as count_swap, t1.SWAP_TO_ASSET_ID, t2.ASSET_NAME, t2.ASSET_id

from algorand.swaps t1

left join assets t2 on t2.ASSET_ID = t1.SWAP_FROM_ASSET_ID

where ( SWAP_TO_ASSET_ID = 694432641)

GROUP by t1.SWAP_TO_ASSET_ID,t2.ASSET_NAME,t2.ASSET_id

order by sum(t1.SWAP_TO_AMOUNT) desc