select
a.asset_name,
count(b.swap_to_asset_id) as N_swap
from flipside_prod_db.algorand.swaps B
join flipside_prod_db.algorand.asset A
on b.swap_to_asset_id = a.asset_id
where B.block_timestamp>= '2022-05-01' and B.block_timestamp <'2022-07-01'
and b.swap_from_amount > 0
group by asset_name
order by N_swap DESC
LIMIT 10