what is the average price of wine not produced in Sanoma county
select avg ( t2.price ) from appellations as t1 join wine as t2 on t1.appelation = t2.appelation where t1.county ! = 'Sonoma'
list all wineries available.
select distinct winery from wine
list the all their prices
select distinct winery, price from wine