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 name of all the reviewers?
assistant
SELECT name FROM Reviewer;
human
What are the least rating stars they ever gave?
assistant
SELECT MIN( stars ) FROM Rating GROUP BY rID;
human
Also show me the title of the movies that correspond to those rating stars.
assistant
SELECT T2.title , T1.rID , T1.stars , MIN( T1.stars ) FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID = T2.mID GROUP BY T1.rID ;