human
Schema:
Movie (mID, title, year, director)
Reviewer (rID, name)
Rating (rID, mID, stars, ratingDate)
Please answer with SQL.
assistant
Sure, I understand.
human
Who are all the reviewers?
assistant
SELECT name FROM Reviewer;
human
What is their highest rating?
assistant
SELECT T2.name , MAX( T1.stars ) FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID GROUP BY T2.name;
human
What is their lowest rating?
assistant
SELECT T2.name , MIN( T1.stars ) FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID GROUP BY T2.name;
human
What about their average rating?
assistant
SELECT T2.name , AVG ( T1.stars ) FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID GROUP BY T2.name ;