CREATE TABLE appellations (No INT, Appelation TEXT, County TEXT, State TEXT, Area TEXT, isAVA 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)
CREATE TABLE grapes (ID INT, Grape TEXT, Color TEXT)

How many wines with a price higher than 100 of each year? Show a bar chart that converts year into weekday interval, and I want to rank from high to low by the total number.
SELECT Year, COUNT(Year) FROM wine WHERE Price > 100 ORDER BY COUNT(Year) DESC
SELECT "Year", COUNT("Year") FROM "wine" WHERE "Price" > 100 ORDER BY COUNT("Year") DESC NULLS LAST