What are the average price and score of wines grouped by appelation?
CREATE TABLE WINE (Appelation VARCHAR, Price INTEGER, Score INTEGER)
[SQL] SELECT AVG(Price), AVG(Score), Appelation FROM WINE GROUP BY Appelation [/SQL]