Which wine uses Cabernet Franc grapes
select t2.name from grapes as t1 join wine as t2 on t1.grape = t2.grape where t1.grape = "Cabernet Franc"
What are the wines that have prices higher than 50?
select * from grapes as t1 join wine as t2 on t1.grape = t2.grape where t2.price > 50
What grapes are red color?
select grape from grapes where color = "Red"
Among the wines that have prices higher than 50, which ones use red color grapes?
select t2.name from grapes as t1 join wine as t2 on t1.grape = t2.grape where t1.color = "Red" and t2.price > 50