CREATE TABLE Rating (mID VARCHAR2, stars NUMBER)
CREATE TABLE Reviewer (rID VARCHAR2, name VARCHAR2)

Find the average rating star for each movie that are not reviewed by Brittany Harris.
SELECT mID, AVG(stars) FROM Rating WHERE NOT mID 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
WITH "_u_0" AS (SELECT ARRAY_AGG("mID") AS "", "T2"."name" AS "_u_1" FROM "Rating" "T1" JOIN "Reviewer" "T2" ON "T1"."rID" = "T2"."rID" GROUP BY "T2"."name") SELECT "mID", AVG("stars") FROM "Rating" LEFT JOIN "_u_0" "_u_0" ON "Brittany Harris" = "_u_0"."_u_1" WHERE NOT ARRAY_ANY("_u_0"."", "_x" -> "mID" = "_x") GROUP BY "mID"