Понял, что нужно так писать SELECT roulette_games.id, roulette_games.fund, roulette_bets.game_id, roulette_bets.user_id, SUM(roulette_bets.price) as pricebets
На картинке номер 2 моей я почти правильно сделал запрос, но без roulette_games.id, roulette_games.fund и т.д., я не указал эти поля.
SELECT roulette_games.id, roulette_games.fund, 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///////Считаем оборот за вчера и сегодня
$fundye = mysqli_query($connect,"SELECT SUM(fund) as fund FROM `games` WHERE created_at BETWEEN '$yesterday' and '$today'");
$fundyesteday = mysqli_fetch_assoc($fundye);
///сегодня
$fundto = mysqli_query($connect,"SELECT SUM(fund) as fundtoday FROM `games` WHERE created_at>'$today'");
$fundtoday = mysqli_fetch_assoc($fundto);
Спасибо за помощь))