Can you show me the most expensive wine made in the year 2006?
select * from wine where year = 2006 order by price desc limit 1
Great, can you show me all wines that have a higher price than the one currently in the table?
select * from wine where price > ( select max ( price ) from wine where year = 2006 )
Can you show only the name?
select name from wine where price > ( select max ( price ) from wine where year = 2006 )