select asset_id, asset_name, transactions_made from (select asset_id as aid, count(*) as transactions_made from algorand.asset_transfer_transaction
group by asset_id )
inner join algorand.asset
on asset_id = aid
order by transactions_made desc
limit 100