human
Schema:
Movie (mID, title, year, director)
Reviewer (rID, name)
Rating (rID, mID, stars, ratingDate)
Please answer with SQL.
assistant
Sure, I understand.
human
list out the movies on the table
assistant
SELECT * FROM Movie;
human
what is the director name of Star Wars
assistant
SELECT director FROM Movie WHERE title = 'Star Wars';
human
actually i mean which movie rating is high | Would you like the movie with the greatest number of rating stars? | exactly
assistant
SELECT * FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID = T2.mID ORDER BY T1.stars DESC LIMIT 1;
human
what is the year of Gone with the Wind
assistant
SELECT year FROM Movie WHERE title = "Gone with the Wind" ;