RESULT

CodePudding user response：

Try with this one:

WITH cte AS (
    SELECT nationality,
           SUM(value_eur) AS Value_
    FROM Fifadf
    GROUP BY nationality
)
SELECT nationality,
       Value_,
       Value_ / SUM(Value_) OVER() AS Prop
FROM cte

Check the demo here.

CodePudding user response：

RESULT

CodePudding user response：

Try the following:

select distinct nationality,
sum(value_eur) over (partition by nationality) as Value ,
1.0 * sum(value_eur) over (partition by nationality)/(select sum(value_eur) from MyData) as Prob
from MyData

See a demo from db-fiddle.