flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Collections Composition - Rarity
Pierandrea
Collections Composition - Rarity
Updated 2023-04-12
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH
ALLS
AS
(
SELECT
RARITY
,
DROP_NUMBER
,
ITEM_NO
,
EDITIONS
from
algorand
.
nft
.
ez_nft_metadata_fifa
GROUP
BY
1
,
2
,
3
,
4
)
SELECT
RARITY
,
COUNT
(
EDITIONS
)
AS
COLLECTIBLES
,
SUM
(
EDITIONS
)
AS
EDITIONS
FROM
ALLS
GROUP
BY
1
ORDER
BY
2
DESC
Results
Run a query to Download Data