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 ratingDate of mID 101?
assistant
SELECT ratingDate FROM Rating WHERE mID = 101;
human
Find The releasing year of The Sound of Music.
assistant
SELECT year FROM Movie WHERE title = 'The Sound of Music';
human
Who is directed by Star Wars? | Did you mean to ask for the name of the director who directed Star Wars? | Yes
assistant
SELECT director FROM Movie WHERE title = 'Star Wars';
human
What is the average rating stars and title for the oldest movie?
assistant
SELECT AVG ( T1.stars ) , T2.title FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID = T2.mID WHERE T2.year = ( SELECT MIN( YEAR ) FROM Movie ) ;