PS0G1FIFA NFTs held rarity variety score
    Updated 2022-11-16
    with maintable as (
    select case when rarity = 'Common' then '2' when rarity = 'Rare' then '4' when rarity = 'Epic' then '6' when rarity = 'Iconic' then '10' end as score2
    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
    and address ilike '{{Algorand_wallet_add}}')

    select sum (score2) as Final_Score
    from maintable
    --credit alik110
    Run a query to Download Data