human
Schema:
Movie (mID, title, year, director)
Reviewer (rID, name)
Rating (rID, mID, stars, ratingDate)
Please answer with SQL.
assistant
Sure, I understand.
human
Find the movie id of Gone with the Wind?
assistant
SELECT mid FROM Movie WHERE title = 'Gone with the Wind';
human
Which year Star Wars movie is released?
assistant
SELECT year FROM Movie WHERE title = "Star Wars" ;