SELECT
    bg.name,
    bg.rating,
    c.name AS category_name -- point 1
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 ILIKE '%a%')  -- point 2
            or
    (bg.rating > 7.50 and pr.min_players >= 2 AND pr.max_players <= 5)      -- point 3
GROUP BY
    bg.rating, bg.name, c.name
ORDER BY
    bg.name asc,
    bg.rating desc
LIMIT 5;