missing column in GROUP BY

[nrgapple]

SQLZoo/6_join.sql

Line 92 in 6627cdc

GROUP BY game.id;

Should be:

SELECT game.id, game.mdate, COUNT(*)
FROM game
JOIN goal
ON goal.matchid = game.id
WHERE goal.teamid = 'GER'
GROUP BY game.id, game.mdate;