title: MYSQL GROUP BY MAX score
body: <p>I have a table called scores which contains columns</p>
  
  <p><img src="https://i.stack.imgur.com/caGx2.png" alt="enter image description here"></p>
  
  <p>How do I select which id_team is top scorer per game</p>
  
  <p>i m trying with this, but that's not correct result</p>
  
  <pre><code>SELECT MAX( score ) , id_team
  FROM scores
  GROUP BY  `id_game` 
  LIMIT 0 , 30
  </code></pre>