out of those show me prices higher than 30 | The names of all wines that have prices both higher than some wines from John Anthony winery  and  higher  than  30 are shown in the table | One last question. out of those show me cases higher than 300
SELECT DISTINCT Name FROM WINE WHERE Price  >   ( SELECT min ( Price )  FROM wine WHERE Winery   =   "John Anthony" )  and  Price>300
prices higher than some wines from John Anthony winery refers to Price > (SELECT MIN(Price) FROM WINE WHERE Winery = 'John Anthony'); names of all wines refers to SELECT DISTINCT Name FROM WINE; prices higher than 30 refers to Price > 30; cases higher than 300 refers to Price > 300;