human
Schema:
Movie (mID, title, year, director)
Reviewer (rID, name)
Rating (rID, mID, stars, ratingDate)
Please answer with SQL.
assistant
Sure, I understand.
human
what is the name of the movie without any ratings?
assistant
SELECT title FROM Movie WHERE mID NOT IN ( SELECT mID FROM Rating );
human
who is the director of star wars?
assistant
SELECT director FROM movie WHERE title = "Star Wars" ;