How many movies altogether do you have?
select count ( distinct mid ) from rating
What is the number of reviewers?
select count ( * ) from reviewer
Can you tell me the ids of the movies not reviewed by Brittany Harris?
select mid from rating except select t1.mid from rating as t1 join reviewer as t2 on t1.rid = t2.rid where t2.name = "Brittany Harris"