By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table e_presidential (
region varchar(255),
party varchar(255),
result int
)
SELECT REGION, PARTY, SUM(RESULT) AS TOTALVOTES,
SUM(RESULT) * 100 / SUM(SUM(RESULT)) OVER () AS SHARE
FROM e_presidential
WHERE REGION = 'ASHANTI'
GROUP BY REGION, PARTY
ORDER BY TOTALVOTES DESC;
| REGION | PARTY | TOTALVOTES | SHARE |
|---|