(SELECT swap_to_asset_id, swap_program,count(*) as total_calls ,sum(swap_to_amount) as total_amt, row_number() over (partition by swap_program order by total_calls desc ) as rn

from algorand.swaps

where block_timestamp >= '2022-01-01' and swap_to_asset_id != '0'

GROUP by 1 ,2

order by 3 desc )

SELECT asset_name,swap_program, total_calls,total_amt

from algorand.asset

inner join assets

on swap_to_asset_id = asset_id

where rn < '11'

order by total_calls desc