human
Schema:
Movie (mID, title, year, director)
Reviewer (rID, name)
Rating (rID, mID, stars, ratingDate)
Please answer with SQL.
assistant
Sure, I understand.
human
Show me all the ratings given by Sarah Martinez.
assistant
SELECT * FROM rating AS t1 JOIN Reviewer AS t2 ON t1.rID = t2.rID WHERE t2.name = 'Sarah Martinez';
human
What movies are those ratings about?
assistant
SELECT distinct t1.title FROM Movie AS t1 JOIN Rating AS t2 ON t1.mID = t2.mID JOIN Reviewer AS t3 ON t2.rID = t3.rID WHERE t3.name = 'Sarah Martinez';
human
Show me the directors of those movies.
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" ;