Show the names of all reviewers.
select t2.name from rating as t1 join reviewer as t2 on t1.rid = t2.rid group by t2.name
What is the average rating of each reviewer.
select t2.name, avg ( t1.stars ) from rating as t1 join reviewer as t2 on t1.rid = t2.rid group by t2.name
List the names of all reviewers based on their average rating in ascending order.
select t2.name from rating as t1 join reviewer as t2 on t1.rid = t2.rid group by t2.name order by avg ( t1.stars ) asc
List all movie id associated with Brittany Harris.
select t1.mid from rating as t1 join reviewer as t2 on t1.rid = t2.rid where t2.name = "Brittany Harris"
List all movie id associated with Brittany Harris and their rating date.
select t1.mid, t1.ratingdate from rating as t1 join reviewer as t2 on t1.rid = t2.rid where t2.name = "Brittany Harris"
What is the average rating of all movies reviewed by Brittany Harris.
select avg ( t1.stars ) from rating as t1 join reviewer as t2 on t1.rid = t2.rid where t2.name = "Brittany Harris"