MYSQL GROUP BY MAX metric

Question

I have a table called score that contains columns

How to choose which id_team is the top scorer per game

im trying with this but what a wrong result

SELECT MAX( score ) , id_team
FROM scores
GROUP BY  `id_game` 
LIMIT 0 , 30

Answer 1

You can use the independent connection to find out the correct team identifier for the game with the maximum rating

SELECT s.* 
FROM scores s
JOIN (
SELECT MAX(score) score, id_game 
FROM scores
GROUP BY id_game ) ss USING(score ,id_game )
LIMIT 0 , 30

Answer 2

select A.id_game, A.id_team as winning_team
from scores A,
(
select max(score) as max, id_game
from scores
group by id_game
)B
where A.id_game = B.id_game
and A.score = B.max