Hi, could you find the appellations that produce wines after the year of 2008 but not in Central Coast area.
select appelation from wine where year > 2008 except select appelation from appellations where area = "Central Coast"
yes
select count ( * ) from appellations where area = "Sierra Foothills"
How many appellations produce wine in Napa Valley?
select count ( * ) from appellations where county = "Napa"
How many appellations produce wine in St. Helena?
select count ( * ) from wine where appelation = "St. Helena"