I have a question
Find the titles of all movies not reviewed by Chris Jackson
Where the relations are 3 movie(mID, title, year, director), reviewer(rID, name), rating(rID, mID, stars, ratingDate)
I have tried this query so far. Any idea of how to improve it or what am I doing wrong?
SELECT DISTINCT M.TITLE
FROM MOVIE AS M
JOIN RATING AS R ON R.mID = M.mID
WHERE R.rID NOT IN (SELECT Rating.rID FROM Rating JOIN Reviewer ON Reviewer.rID = Rating.rID WHERE Reviewer.name = 'Chris Jackson');