superflyTop 10 Fifa + NFT Collectors With Highest Wallet Score
    Updated 2022-11-15
    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