What is the average price of all wine products?
select avg ( price ) from wine
Which wine product has the highest price?
select * from wine where price = ( select max ( price ) from wine )
Yes, Which grapes are in the wine products that have the highest average price?
select t1.grape from grapes as t1 join wine as t2 on t1.grape = t2.grape group by t2.grape order by avg ( price ) desc limit 1
What is the average price of the products that Roussanne is in?
select avg ( price ) from grapes as t1 join wine as t2 on t1.grape = t2.grape group by t2.grape order by avg ( price ) desc limit 1
What color of grape is Roussanne?
select color from grapes where grape = "Roussanne"