Which kinds of grapes are white?
select grape from grapes where color = "White"
List wines made with white grapes.
select * from grapes as t1 join wine as t2 on t1.grape = t2.grape where t1.color = "White"
Excellent. What is their average score?
select avg ( score ) from grapes as t1 join wine as t2 on t1.grape = t2.grape where t1.color = "White"
What is the average score of wines not made with white grapes?
select avg ( score ) from grapes as t1 join wine as t2 on t1.grape = t2.grape where t1.color ! = "White"
List only the names and scores of wines made with white grapes.
select t2.name, t2.score from grapes as t1 join wine as t2 on t1.grape = t2.grape where t1.color = "White"
What is the maximum, minimum, and average price of these wines?
select max ( price ), min ( price ) ,avg ( price ) from grapes as t1 join wine as t2 on t1.grape = t2.grape where t1.color = "White"