select count(*), algorand.asset.asset_name from algorand.swaps
inner join algorand.application_call_transaction
on algorand.application_call_transaction.sender=algorand.swaps.swapper
inner join algorand.asset on algorand.asset.asset_id=algorand.swaps.swap_from_asset_id
where
swap_from_amount!=0 and algorand.application_call_transaction.app_id=596947890
group by algorand.asset.asset_name
order by count(*) desc
limit 100