CREATE TABLE WINE (Price NUMBER, Appelation VARCHAR2)
CREATE TABLE APPELLATIONS (Appelation VARCHAR2, County VARCHAR2)

Give me the average prices of wines that are produced by appelations in Sonoma County.
SELECT AVG(T2.Price) FROM APPELLATIONS AS T1 JOIN WINE AS T2 ON T1.Appelation = T2.Appelation WHERE T1.County = "Sonoma"
SELECT AVG("T2"."Price") FROM "APPELLATIONS" "T1" JOIN "WINE" "T2" ON "T1"."Appelation" = "T2"."Appelation" WHERE "Sonoma" = "T1"."County"