CREATE VIEW PCTEHOME AS
SELECT TEAM1_ID,
    CASE WHEN GOALS_TEAM1>GOALS_TEAM2 THEN 3
          WHEN GOALS_TEAM1=GOALS_TEAM2 THEN 1
          ELSE 0
    END AS PCTEHOME
    FROM SCORE;

CREATE VIEW PCTEAWAY AS
SELECT TEAM2_ID,
    CASE WHEN GOALS_TEAM2>GOALS_TEAM1 THEN 3
          WHEN GOALS_TEAM2=GOALS_TEAM1 THEN 1
          ELSE 0
    END AS PCTEAWAY
    FROM SCORE;

/*
SELECT TEAM1_ID, PCT
FROM SCORE
WHERE TEAM1_ID


CREATE VIEW [PCTEAWAY] AS
SELECT TEAM2_ID, PCT
FROM SCORE
WHERE TEAM2_ID
*/


CREATE VIEW PUNCTAJ AS
SELECT TEAM_ID,SUM(PCT)
    FROM (PCTEHOME UNION ALL PCTEAWAY)P , TEAMS T
    WHERE P.TEAM_ID=T.TEAM_ID
    GROUP BY TEAM_ID;