title: Whats wrong with my query with CASE statement
body: <p>I'm trying to solve #13 on <a href="http://www.sqlzoo.net/wiki/The_JOIN_operation" rel="noreferrer">http://www.sqlzoo.net/wiki/The_JOIN_operation</a></p>
  
  <p>"List every match with the goals scored by each team as shown. This will use "CASE WHEN" which has not been explained in any previous exercises."</p>
  
  <p><strong>Here's my query:</strong></p>
  
  <pre><code>SELECT game.mdate, game.team1, 
  SUM(CASE WHEN goal.teamid = game.team1 THEN 1 ELSE 0 END) AS score1,
  game.team2,
  SUM(CASE WHEN goal.teamid = game.team2 THEN 1 ELSE 0 END) AS score2
  
  FROM game INNER JOIN goal ON matchid = id
  GROUP BY game.id
  ORDER BY mdate,matchid,team1,team2
  </code></pre>
  
  <p>I get the result "Too few rows". I don't understand what part I got wrong.</p>