SELECT swap_from_asset_id, count(swap_from_amount)

FROM algorand.swaps

WHERE swap_to_asset_id = '31566704'

GROUP BY 1

)

SELECT swap_from_asset_id, count(swap_from_amount), CASE (

WHEN swap_from_asset_id = '465865291' THEN 'stbl'

WHEN swap_from_asset_id = '287867876' THEN 'opul'

WHEN swap_from_asset_id = '312769' THEN 'usdt'

WHEN swap_from_asset_id = '163650' THEN 'arcc'

WHEN swap_from_asset_id = '0' THEN 'algo'

END) AS offer

FROM source