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 names of all directors whose movies are rated by Sarah Martinez
assistant
SELECT DISTINCT T2.director FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID = T2.mID JOIN Reviewer AS T3 ON T1.rID = T3.rID WHERE T3.name = 'Sarah Martinez';
human
list the other directors against the movies they directed.
assistant
SELECT director , title FROM movie WHERE director ! = 'Victor Fleming';
human
what is the general ratings for those movies?
assistant
SELECT T1.director , T1.title , T2.stars FROM movie AS T1 JOIN rating AS T2 ON T1.mid = T2.mid WHERE T1.mid IN ( SELECT mID FROM movie WHERE director ! = "Victor Fleming" ) ;