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