SpiltadavidTop 10 FIFA+ Collect NFT Score
Updated 2022-11-16
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 wallet_NFTs as (select
ASSET_ADDED_AT as Purchase_Time,
NFT_ASSET_NAME Name ,
PLAYER ,
world_cup_type gender,
NFT_ASSET_ID ,
RARITY,
-- case when RARITY = 'Common' then 1
-- when RARITY = 'Rare' then 2
-- when RARITY = 'Epic' then 4
-- when RARITY = 'Iconic' then 8
-- end RARITY ,
ITEM_NO
from algorand.nft.ez_nft_metadata_fifa join algorand.core.fact_account_asset on nft_asset_id = asset_id
where AMOUNT > 0
and address ilike '{{ALGO_Wallet_Address}}'
),
Wallet_score_per_rarity as (
select count (DISTINCT NFT_ASSET_ID ) score from wallet_NFTs where RARITY = 'Common'
UNION
select 2* count (DISTINCT NFT_ASSET_ID ) score from wallet_NFTs where RARITY = 'Rare'
UNION
select 4* count (DISTINCT NFT_ASSET_ID ) score from wallet_NFTs where RARITY = 'Epic'
UNION
select 8 * count (DISTINCT NFT_ASSET_ID ) score from wallet_NFTs where RARITY = 'Iconic'
),
Total_wallet_score as (
select sum (score) wallet_score from Wallet_score_per_rarity
),
all_wallets as (
select ASSET_ADDED_AT as Purchase_Time,
NFT_ASSET_NAME Name ,
PLAYER ,
ADDRESS,
world_cup_type gender,
NFT_ASSET_ID ,
Run a query to Download Data