CREATE TABLE appellations (No INT, Appelation TEXT, County TEXT, State TEXT, Area TEXT, isAVA TEXT)
CREATE TABLE grapes (ID INT, Grape TEXT, Color TEXT)
CREATE TABLE wine (No INT, Grape TEXT, Winery TEXT, Appelation TEXT, State TEXT, Name TEXT, Year INT, Price INT, Score INT, Cases INT, Drink TEXT)

Show mean max(price) from each year, rank from high to low by the total number.
SELECT Year, AVG(MAX(Price)) FROM wine ORDER BY AVG(MAX(Price)) DESC
SELECT "Year", AVG(MAX("Price")) FROM "wine" ORDER BY AVG(MAX("Price")) DESC NULLS LAST