PierandreaCollections Composition - Drops
Updated 2023-06-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
--WITH drops 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,
MAX(ITEM_NO) AS Collectibles
FROM algorand.nft.ez_nft_metadata_fifa
GROUP BY DROP_NUMBER
Order by DROP_NUMBER ASC--),
--ALLS AS (SELECT
-- RARITY,
-- DROP_NUMBER,
--ITEM_NO,
--EDITIONS
---from algorand.nft.ez_nft_metadata_fifa
---GROUP BY 1,2,3,4)
--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 Drops,
-- MAX(ITEM_NO) AS Collectibles,
--SUM(EDITIONS) AS EDITIONS
--FROM ALLS,drops
--GROUP BY 1
--order by 1 asc
Run a query to Download Data