PierandreaCopy of Collections Composition - Drops
Updated 2022-12-11
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
33
34
35
36
›
⌄
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),
ED 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 Drops,
MAX(ITEM_NO) AS Collectibles,
SUM(EDITIONS) AS EDITIONS
FROM ALLS,drops
GROUP BY 1
order by 1 asc)
SELECT
SUM(Collectibles)
FROM
ED
Run a query to Download Data