PierandreaUntitled Query
Updated 2022-12-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH X AS ( SELECT
CASE
WHEN DROP_NUMBER = '1' THEN '1 -Genesis Drop'
WHEN DROP_NUMBER = '2' THEN '2 -FIFA Archive Drop'
WHEN DROP_NUMBER = '3' THEN '3 -Curator Collection - South American Flair'
WHEN DROP_NUMBER = '4'THEN '4 -FIFA Archive 2 Drop'
END AS Edition,
Rarity
FROM algorand.nft.ez_nft_metadata_fifa
GROUP BY DROP_NUMBER, Rarity
Order by EDITION ASC),
B AS (
SELECT
DROP_NUMBER,
Rarity,
MAX(Editions)
FROM algorand.nft.ez_nft_metadata_fifa
GROUP BY DROP_NUMBER, Rarity
)
Run a query to Download Data