SELECT Name FROM WINE WHERE Price  >  (SELECT max(Price) FROM WINE WHERE YEAR  =  2006)
What are the names of wines that are more expensive then all wines made in the year 2006?
SELECT Name FROM WINE WHERE Price > ( SELECT max ( Price ) FROM WINE WHERE YEAR = 2006 )
select name from wine where price > ( select max ( price ) from wine where year = value )
What are the names of wines that are more expensive then all wines made in the year 2006 ?