What are the name of all the reviewers?
select name from reviewer
What are the movies that are reviewed by Brittany Harris?
select t1.mid from rating as t1 join reviewer as t2 on t1.rid = t2.rid where t2.name = "Brittany Harris"
Show me the average rating star for all other movies except those.
select mid, avg(stars) from rating where mid not in (select t1.mid from rating as t1 join reviewer as t2 on t1.rid = t2.rid where t2.name = "Brittany Harris") group by mid