How many reviewers are there?
select count ( distinct rid ) from rating
What are their id numbers?
select distinct rid from rating
What is the average rating of the reviewers?
select avg ( stars ) from rating
How many raters gave reviews less than 4 stars?
select count ( distinct rid ) from rating where stars < 4
What are their ids?
select distinct rid from rating where stars < 4