what appellations does Sonoma County have?
select appelation from appellations where county = "Sonoma"
Give me the name of wines that are produced by them.
select t2.name from appellations as t1 join wine as t2 on t1.appelation = t2.appelation where t1.county = "Sonoma"
what is their average price?
select avg(t2.price) from appellations as t1 join wine as t2 on t1.appelation = t2.appelation where t1.county = "Sonoma"