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

Give the average price and case of wines made from Zinfandel grapes in the year 2009.
SELECT AVG(price), AVG(cases) FROM wine WHERE year = 2009 AND grape = "Zinfandel"
SELECT AVG("price"), AVG("cases") FROM "wine" WHERE "Zinfandel" = "grape" AND "year" = 2009