Which appelation produces the most expensive wine?
select t1.appelation from appellations as t1 join wine as t2 on t1.appelation = t2.appelation where t2.price = ( select max ( price ) from wine )
How much is the most expensive wine produced in Sonoma County?
select max ( t2.price ) from appellations as t1 join wine as t2 on t1.appelation = t2.appelation where t1.county = "Sonoma"
How many wines are produced in Sonoma County?
select count ( * ) from appellations as t1 join wine as t2 on t1.appelation = t2.appelation where t1.county = "Sonoma"
What is the price of the least expensive wine produced in Sonoma County?
select min ( t2.price ) from appellations as t1 join wine as t2 on t1.appelation = t2.appelation where t1.county = "Sonoma"
Yes, what is the average price of wines produced in Sonoma County?
select avg ( t2.price ) from appellations as t1 join wine as t2 on t1.appelation = t2.appelation where t1.county = "Sonoma"