nickpayiatis_Untitled Query
    Updated 2023-01-03

    select count(acc.address) as all_wallets,
    sum(case when acc.account_closed = FALSE then 1 else 0 end) as non_closed ,
    sum(case when acc.balance >= 1 then 1 else 0 end) as wallets_with_balance
    from algorand.account acc


    Run a query to Download Data