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 are the titles of all movies?
assistant
SELECT title FROM movie;
human
Which one is the oldest?
assistant
SELECT title FROM movie WHERE Year = ( SELECT MIN( YEAR ) FROM Movie ) ;