I have the following query:
SELECT Team1, COUNT(Winner) AS Won FROM Games WHERE Winner = -1 GROUP BY Team1
UNION ALL
SELECT Team2, COUNT(Winner) AS Won FROM Games WHERE Winner = -1 GROUP BY Team2;
Which returns the following:
+-------+-----+
| Team1 | Won |
+-------+-----+
| 1 | 1 |
|...