DevJacobihow-many-wallets-holding-each-asa-amount-bigger-zero
    Updated 2022-09-21
    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
    Run a query to Download Data