Which wines were produced before 2000?
select distinct name from wine where year < 2000
What is the most common year of production?
select year from wine group by year order by count ( * ) desc limit 1
Which wines were produced in 2007?
select winery from wine where year = 2007
What about the ones after the year 2010?
select distinct name from wine where year > 2010