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
hello,
what are the maximum price and score of wines in each year?
assistant
SELECT MAX( Price ) , MAX( Score ) , YEAR FROM WINE GROUP BY YEAR;
human
yes | Did you mean the No in the wine table which is best liked? | yes that is what i meant
assistant
SELECT No FROM WINE ORDER BY Score desc LIMIT 1 ;