MySQL: Zwei Spalten in einer View zählen

Create View highscorer as (
Select Spieler, Tore, Vorlagen, tore+vorlagen as Scorerpunkte From (
SELECT coalesce(t1.Spieler,t2.Spieler) AS Spiele
       , coalesce( t1.Tore, 0) as Tore
       , coalesce( t2.Vorlagen, 0) as Vorlagen
FROM (
   SELECT Tor       AS Spieler
         , count(*) AS Tore
      FROM Tore
      GROUP BY Tor
      ) t1
  FULL OUTER JOIN (
   SELECT Vorlage  AS Spieler
        , count(*) AS Vorlagen
    FROM Tore
    GROUP BY Vorlage
    ) t2
      ON t1.Spieler = t2.Spieler
) whatever
ORDER by 4, 1
);

Create View highscorer as (
Select Spieler, Tore, Vorlagen, tore+vorlagen as Scorerpunkte From (
SELECT coalesce(t1.Spieler,t2.Spieler) AS Spiele
       , coalesce( t1.Tore, 0) as Tore
       , coalesce( t2.Vorlagen, 0) as Vorlagen
FROM (
   SELECT Tor       AS Spieler
         , count(*) AS Tore
      FROM Tore
      GROUP BY Tor
      ) t1
  LEFT OUTER JOIN (
   SELECT Vorlage  AS Spieler
        , count(*) AS Vorlagen
    FROM Tore
    GROUP BY Vorlage
    ) t2
      ON t1.Spieler = t2.Spieler
UNION ALL
SELECT Tor       AS Spieler
         , count(*) AS Tore
      FROM Tore
      GROUP BY Tor
      ) t3
  RIGHT OUTER JOIN (
   SELECT Vorlage  AS Spieler
        , count(*) AS Vorlagen
    FROM Tore
    GROUP BY Vorlage
    ) t4
      ON t3.Spieler = t4.Spieler
    WHERE t3.Spieler is NULL
) whatever
ORDER by 4, 1
);

SELECT t2.Spieler,
sum(CASE WHEN t3.Tor IS NOT NULL THEN 1 ELSE 0 END) AS Tore,
sum(CASE WHEN t4.Vorlage IS NOT NULL THEN 1 ELSE 0 END) AS Vorlagen
FROM (
SELECT DISTINCT t1.Spieler
FROM (
SELECT Tor AS Spieler FROM Tore
UNION ALL
SELECT Vorlage AS Spieler FROM Tore
) t1
) t2
LEFT JOIN Tore t3 ON t2.Spieler = t3.Tor
LEFT JOIN Tore t4 ON t2.Spieler = t4.Vorlage
GROUP BY t2.Spieler