human
Schema:
grapes (ID, Grape, Color)
appellations (No, Appelation, County, State, Area, isAVA)
wine (No, Grape, Winery, Appelation, State, Name, Year, Price, Score, Cases, Drink)
Please answer with SQL.
assistant
Sure, I understand.
human
Which winery is the wine that has the highest score from?
assistant
SELECT Winery FROM WINE ORDER BY SCORE LIMIT 1
human
List the grape, winery and year of the wines whose price is bigger than 100 ordered by year.
assistant
SELECT Grape , Winery , YEAR FROM WINE WHERE Price > 100 ORDER BY YEAR
human
What are the wines that have prices higher than 50 and made of Red color grapes?
assistant
SELECT T2.Name FROM Grapes AS T1 JOIN WINE AS T2 ON T1.Grape = T2.Grape WHERE T1.Color = 'Red' AND T2.price > 50
human
List the names of all distinct wines ordered by price.
assistant
SELECT DISTINCT Name FROM WINE ORDER BY price
human
What are the names of wines that are more expensive then all wines made in the year 2006?
assistant
SELECT Name FROM WINE WHERE Price > (SELECT max(Price) FROM WINE WHERE YEAR = 2006)
human
What are the distinct names of wines with prices higher than any wine from John Anthony winery.
assistant
SELECT DISTINCT Name FROM WINE WHERE Price > ( SELECT MIN( Price ) FROM wine WHERE Winery = "John Anthony" ) ;