SELECT *
FROM table AS t
WHERE rating IN (
SELECT MAX(rating)
FROM table
WHERE t.year = year) OR
rating IN (
SELECT MIN(rating)
FROM table
WHERE t.year = year)
ORDER BY year ASC, title ASC;
SELECT *
FROM table AS t
WHERE rating IN (
SELECT MAX(rating)
FROM table
WHERE t.year = year) OR
rating IN (
SELECT MIN(rating)
FROM table
WHERE t.year = year)
ORDER BY year ASC, title ASC;