ให้ราคาเฉลี่ยและกรณีไวน์ที่ทำจากองุ่น Zinfandel ปี 2552 ไม่จำเป็นต้องใช้ทุกโต๊ะ
Give the average price and case of wines made from Zinfandel grapes in the year 2009.It is not neccessary to use all the tables.
 wine:  no [ number]  grape [ text]  winery [ text]  appelation [ text]  state [ text]  name [ text]  year [ number]  price [ number]  score [ number]  cases [ number]  drink [ text] 
SELECT AVG(price), AVG(cases) FROM wine WHERE year = 2009 AND grape = "Zinfandel"