Exam Preparation III - 3.8. First 5 Board Games
Каквото и да променя не получавам правилните output данни. И chat gpt не помага.
Python DB - първия кърс: https://judge.softuni.org/Contests/Practice/Index/4298#7
SELECT
bg.name,
bg.rating,
c.name
FROM
board_games as bg
JOIN
categories as c
ON bg.category_id = c.id
JOIN
players_ranges AS pr
ON bg.players_range_id = pr.id
WHERE
(bg.rating > 7.00 and bg.name LIKE '%a%')
or
(bg.rating > 7.50 and pr.min_players between 2 and 5)
GROUP BY
bg.rating, bg.name, c.name
ORDER BY
bg.name asc,
bg.rating desc
LIMIT 5;