flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
nickpayiatis_
Untitled Query
Updated 2023-01-03
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
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
Results
Run a query to Download Data