CREATE TABLE rating (rid DECIMAL, mid DECIMAL, stars DECIMAL, ratingdate TIME)
CREATE TABLE movie (mid DECIMAL, title TEXT, year DECIMAL, director TEXT)
CREATE TABLE reviewer (rid DECIMAL, name TEXT)

What are the titles of all movies that have not been rated?
SELECT title FROM movie WHERE NOT mid IN (SELECT mid FROM rating)
SELECT "title" FROM "movie" WHERE NOT "mid" IN (SELECT "mid" FROM "rating")