DiamondJalen Hurts Crafting Challange (Debut Burns)
Updated 2023-12-04
999
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
updated_metadata_0 AS (
SELECT
nft_id as "ID",
--moment_stats_full['ID'] AS "unique_id",
CASE
WHEN player = 'N/A' THEN team
ELSE player
END AS "Player",
team as "Team",
series as "Series",
set_name AS "Set Name",
moment_stats_full['flowID'] AS "marketplace_id",
moment_tier AS "Tier",
SERIAL_NUMBER AS "Serial #"
FROM
flow.nft.dim_allday_metadata
UNION
SELECT
nft_id AS "ID",
CONCAT(
metadata:playerFirstName::STRING,
' ',
metadata:playerLastName::STRING
) AS "Player",
CONCAT(
metadata:team::STRING
) AS "Team",
series_name as "Series",
set_name AS "Set Name",
NULL AS "marketplace_id",
tier AS "Tier",
SERIAL_NUMBER AS "Serial #"
from
flow.nft.dim_moment_metadata
),
Run a query to Download Data