CREATE TABLE wine (no NUMBER, grape CLOB, winery CLOB, appelation CLOB, state CLOB, name CLOB, year NUMBER, price NUMBER, score NUMBER, cases NUMBER, drink CLOB)
CREATE TABLE appellations (no NUMBER, appelation CLOB, county CLOB, state CLOB, area CLOB, isava CLOB)
CREATE TABLE grapes (id NUMBER, grape CLOB, color CLOB)

What are the average price and score of wines grouped by appelation?
SELECT AVG(price), AVG(score), appelation FROM wine GROUP BY appelation
SELECT AVG("price"), AVG("score"), "appelation" FROM "wine" GROUP BY "appelation"