human
Schema:
grapes (ID, Grape, Color)
appellations (No, Appelation, County, State, Area, isAVA)
wine (No, Grape, Winery, Appelation, State, Name, Year, Price, Score, Cases, Drink)
Please answer with SQL.
assistant
Sure, I understand.
human
Hi, could you find the appellations that produce wines after the year of 2008 but not in Central Coast area.
assistant
SELECT Appelation FROM WINE WHERE YEAR > 2008 EXCEPT SELECT Appelation FROM APPELLATIONS WHERE Area = 'Central Coast';
human
How many produce in the sierra foothills? | Did you want the number of appelations that produce wine in the Sierra Foothills? | yes
assistant
SELECT COUNT( * ) FROM appellations WHERE Area = 'Sierra Foothills';
human
How many appellations produce wine in Napa Valley?
assistant
SELECT COUNT( * ) FROM appellations WHERE County = "Napa" ;