What are the average prices and cases of wines produced in the year of 2009 and made of Zinfandel grape?
CREATE TABLE WINE (Price INTEGER, Cases INTEGER, YEAR VARCHAR, Grape VARCHAR)
[SQL] SELECT AVG(Price), AVG(Cases) FROM WINE WHERE YEAR = 2009 AND Grape = "Zinfandel" [/SQL]