CREATE TABLE APPELLATIONS (Appelation VARCHAR2, County VARCHAR2)
CREATE TABLE WINE (Appelation VARCHAR2)
CREATE TABLE wine (price NUMBER, Appelation VARCHAR2)

Find the average price of wines that are not produced from Sonoma county.
SELECT AVG(price) FROM wine WHERE NOT Appelation IN (SELECT T1.Appelation FROM APPELLATIONS AS T1 JOIN wine AS T2 ON T1.Appelation = T2.Appelation WHERE T1.County = 'Sonoma')
WITH "_u_0" AS (SELECT "T1"."Appelation" FROM "APPELLATIONS" "T1" JOIN "wine" "T2" ON "T1"."Appelation" = "T2"."Appelation" WHERE "T1"."County" = 'Sonoma' GROUP BY "Appelation") SELECT AVG("price") FROM "wine" LEFT JOIN "_u_0" "_u_0" ON "Appelation" = "_u_0"."" WHERE "_u_0"."" IS NULL