ASSET_NAME as asset_to,

count(DISTINCT tx_group_id) as SWAPPERS

from flipside_prod_db.algorand.swaps s

join flipside_prod_db.algorand.asset a on a.ASSET_ID = s.SWAP_TO_ASSET_ID

where BLOCK_TIMESTAMP::date >= '2022-04-01'

and SWAP_FROM_ASSET_ID in (386192725)

GROUP by 1)

select

case when asset_to='ALGO' then 'ALGO' when asset_to='STBL' then 'STBL' else 'otherwise' end as name,

sum(swappers) as number from a group by 1