with top_wallets as (
select top 10 asset_id, asset_name, count(address) as wallets_amount
from flipside_prod_db.algorand.account_asset
where amount > 0
and asset_closed = false
group by asset_id, asset_name
order by wallets_amount desc
)
select asset_name, wallets_amount from top_wallets