How to group data by field in JOIN?

Question

SQL

Hello.
I combine 2 tables using JOIN and I need to group the price field using GROUP BY by the game_id field (game number), but it doesn’t work out.
Here is a piece of the request, where I stopped at the moment and a screen that I receive.

SELECT * FROM `roulette_bets` LEFT OUTER JOIN `roulette_games` ON `roulette_bets`.`game_id` = `roulette_games`.`id` WHERE `roulette_bets`.`user_id`=36454  GROUP BY roulette_bets.id  
ORDER BY `roulette_bets`.`game_id`  DESC

If I write GROUP BY roulette_bets.game_id in the query, then the following error occurs
: "#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gosens.roulette_bets.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"
I tried it like this.

SELECT roulette_bets.game_id, roulette_bets.user_id, SUM(roulette_bets.price) as pricebets  FROM `roulette_bets` JOIN `roulette_games` ON `roulette_bets`.`game_id` = `roulette_games`.`id` WHERE `roulette_bets`.`user_id`=36454  GROUP BY roulette_bets.game_id
ORDER BY `roulette_bets`.`game_id` DESC

That's all right, it groups by game_id and successfully adds up the price field, but! It displays only 3 fields, and I need all the fields from two tables, but it displays as in the screenshot.

Help, I'm confused.
The structure of the roulette_bets table is below: The structure of the roulette_games

table is below: roulette_bets.game_id = roulette_games.id The PRICE price must be added to one sum by game_id And we get the game 64677 = , user_id=36454, price=5.2, etc.

Answer 1

Have you tried reading and understanding the error message? After all, it is written in English and white, what is the problem with the grouping.
https://dev.mysql.com/doc/refman/5.7/en/group-by-h...