rmasChart - Kyrie Irving - What makes a Top Shots moment valuable: Offseason Rumors & Moves
Updated 2022-10-13
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
-- 7M+ NFTs
dim_nft AS (
SELECT nft_id -- Unique PK
, nbatopshot_id -- Unique PK
, set_name -- NFT partial composite key
, set_series_number -- NFT partial composite key
, player -- NFT partial composite key
, play_category -- NFT partial composite key
, moment_date -- NFT partial composite key
, total_circulation -- NFT partial composite key
, serial_number -- NFT partial composite key
, (CASE WHEN total_circulation <= 120 THEN 'Legendary'
WHEN total_circulation <= 1800 THEN 'Rare'
WHEN total_circulation <= 1858 THEN 'Fandom'
ELSE 'Common' END) AS moment_tier
, concat(set_name, ' (Series ', set_series_number, ') | ',
player, ' - ', play_category, ' (', moment_date::date::string, ') | ',
moment_tier, ' (', total_circulation, ')') AS moment_pseudo_id
, team -- Moment attribute
, season -- Moment attribute
, play_type -- Moment attribute
FROM flow.core.dim_topshot_metadata
WHERE set_name IS NOT NULL
AND set_series_number IS NOT NULL
AND player IS NOT NULL
AND play_category IS NOT NULL
AND moment_date IS NOT NULL
AND total_circulation IS NOT NULL
Run a query to Download Data