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