popular_asas as (

select TOP 10 asset.asset_id, count(asset.asset_id) as transactions_total from algorand.asset_transfer_transaction att

join algorand.asset asset on att.asset_id = asset.asset_id

where asset.asset_deleted = false

group by asset.asset_id

order by count(asset.asset_id) desc

select asset_name, created_at, transactions_total from popular_asas p join assets a on p.asset_id = a.asset_id

order by transactions_total desc