Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Match (
Heim VARCHAR(50),
Gast VARCHAR(50),
HeimP NUMBER,
GastP NUMBER
);
INSERT INTO Match VALUES('Bayern München','Borussia Dortmund',1,1);
1 rows affected

INSERT INTO Match VALUES('Borussia Dortmund','Bayern München',0,3);
1 rows affected

INSERT INTO Match VALUES('Bayern München','Schalke',3,0);
1 rows affected

INSERT INTO Match VALUES('Schalke','Bayern München',0,3);
1 rows affected

SELECT SUM(
         CASE 'Bayern München'
           WHEN Heim THEN HeimP 
           WHEN Gast THEN GastP
         END
       ) AS points 
FROM Match 
WHERE 'Bayern München' IN (Gast, Heim);


POINTS


10