New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

missing column in GROUP BY #4

Open

nrgapple opened this issue Aug 31, 2021 · 0 comments

nrgapple commented Aug 31, 2021

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;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment