query: 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
question: Find the average rating star for each movie that give Brittany Harris review
query_toks: 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
query_toks_no_value: 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
question_toks: Find the average rating star for each movie that give Brittany Harris review