AndyCoolAl Goanna Per Wallet Distribution
    Updated 2022-05-26
    with holders as (
    select
    address, sum(amount) as goanna_count
    from flipside_prod_db.algorand.account_asset
    where asset_name in (
    select distinct asset_name
    from flipside_prod_db.algorand.asset
    where creator_address = 'D5J7H7PIYKLY2U6A5OFUAC7GQHTHSXXNX65DSD3CJYPBV2MVK6NTNW44CA'
    and (asset_name like 'Al Goanna 82'
    or asset_name like 'Al Goanan 217'
    or asset_name like 'Al Goanna%'
    or asset_name like 'Al Goanna 401'
    or asset_name like 'AL Goanna 400')
    and asset_name != 'Al Goanna Space Monkey #190'
    and asset_name != 'Al Goanna Space Monkey #191')
    group by address)

    select count(address) as Holders, goanna_count
    from holders
    where goanna_count > 0
    group by goanna_count
    Run a query to Download Data