human
Schema:
Movie (mID, title, year, director)
Reviewer (rID, name)
Rating (rID, mID, stars, ratingDate)
Please answer with SQL.
assistant
Sure, I understand.
human
How many movies altogether do you have?
assistant
SELECT COUNT( DISTINCT mID ) FROM Rating;
human
What is the number of reviewers?
assistant
SELECT COUNT( * ) FROM Reviewer;
human
Can you tell me the ids of the movies not reviewed by Brittany Harris?
assistant
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" ;