flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
count-cex-subtypes
DevJacobi
count-cex-subtypes
Updated 2022-10-07
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
select
'all'
as
label_subtype
,
count
(
*
)
as
amount
from
flipside_prod_db
.
algorand
.
labels
where
label_type
=
'cex'
union
all
select
label_subtype
,
count
(
*
)
as
amount
from
flipside_prod_db
.
algorand
.
labels
where
label_type
=
'cex'
group
by
label_subtype
Results
Run a query to Download Data