Since 2006, I’ve been keeping track of the films that I’ve seen:
SELECT date(Date) as ‘Viewed’, Title, CASE
WHEN Opinion = 5 THEN “I loved it!”
WHEN Opinion = 4 THEN “I really liked it!”
WHEN Opinion = 3 THEN “I liked it!”
WHEN Opinion = 2 THEN “It was okay!”
WHEN Opinion = 1 THEN “I didn’t like it.”
ELSE “No Opinion”
END as ‘Opinion’,
Released as ‘Year’
FROM films
ORDER BY Number DESC;
Check out the films seen!