superflyTop 10 Fifa + NFT Collectors With Highest Wallet Score
Updated 2022-11-15Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with maintable as (
select address,
case when drop_number = '3' then '8' when drop_number in ('1','2') then '4' end as score1,
case when rarity = 'Common' then '2' when rarity = 'Rare' then '4' when rarity = 'Epic' then '6' when rarity = 'Iconic' then '10' end as score2,
case when event_type = 'Celebration' then '2' when event_type = 'Tackle' then '4' when event_type = 'Pass' then '6' when event_type = 'Save' then '8' when event_type = 'Goal' then '10' end as score3,
case when world_cup_type = 'Womens' then '5' when world_cup_type = 'Mens' then '6' end as score4,
case when minute ilike '%+%' then '3' else '1' end as score5,
score1 + score2 + score3 + score4 + score5 as NFTs_Score
from algorand.core.fact_account_asset t1 join algorand.nft.ez_nft_metadata_fifa t2 on t1.asset_id = t2.nft_asset_id
where t1.amount > 0)
select address,
sum (NFTs_Score) as Final_Score
from maintable
group by 1
order by 2 desc
limit 10
Run a query to Download Data