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
Find the average rating star for each movie that are not reviewed by Brittany Harris.
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
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 = value ) group by mid
Find the average rating star for each movie that are not reviewed by Brittany Harris .