CREATE TABLE Movie(
	mID int primary key, 
	title text, 
	year int, 
	director text
)

CREATE TABLE Reviewer(
	rID int primary key, 
	name text)

CREATE TABLE Rating(
	rID int, 
	mID int, 
	stars int, 
	ratingDate date,
	FOREIGN KEY (mID) references Movie(mID),
	FOREIGN KEY (rID) references Reviewer(rID)
)
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
What is the average rating for each movie that has never been reviewed by Brittany Harris?