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 all the ratings?
assistant
SELECT * FROM Rating;
human
Show me the ids of reviewers who gave 4 star.
assistant
SELECT distinct rID FROM Rating WHERE stars = 4 ;