WITH tab1 as (
SELECT
swap_to_asset_id,
count(DISTINCT swapper) as swaps
from algorand.swaps
WHERE block_timestamp > '2022-01-01'
AND swap_program like 'tinyman'
GROUP BY 1
ORDER by 2 DESC
LIMIT 11
)
SELECT
asset_name,
swaps
FROM tab1
LEFT outer JOIN algorand.asset
ON swap_to_asset_id = asset_id
WHERE NOT asset_name is NULL