how many wines are there?
select count(*) from wine
how many of them have a price higher than 50?
select count(*) from wine where price > 50
find their names.
select name from wine where price > 50
which are made from red colored 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