select 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

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 '{{Wallet_Address}}')

select sum (score3) as Final_Score

from maintable