CREATE TABLE grapes (
    ID NUMBER PRIMARY KEY,
    Grape TEXT,
    Color TEXT
);
CREATE TABLE appellations (
    No NUMBER PRIMARY KEY,
    Appelation TEXT,
    County TEXT,
    State TEXT,
    Area TEXT,
    isAVA TEXT
);
CREATE TABLE wine (
    No NUMBER,
    Grape TEXT,
    Winery TEXT,
    Appelation TEXT,
    State TEXT,
    Name TEXT,
    Year NUMBER,
    Price NUMBER,
    Score NUMBER,
    Cases NUMBER,
    Drink TEXT,
    FOREIGN KEY ("Appelation") REFERENCES appellations("Appelation"),
    FOREIGN KEY ("Grape") REFERENCES grapes("Grape")
);

Question: What is the name of the highest rated wine?
SQL: SELECT Name FROM WINE ORDER BY Score LIMIT 1

Question: Give the name of the wine with the highest score.
SQL: SELECT Name FROM WINE ORDER BY Score LIMIT 1

Question: Which winery is the wine that has the highest score from?
SQL: SELECT Winery FROM WINE ORDER BY SCORE LIMIT 1

Question: What is the winery at which the wine with the highest score was made?
SQL: SELECT Winery FROM WINE ORDER BY SCORE LIMIT 1

Question: Find the names of all wines produced in 2008.
SQL: SELECT Name FROM WINE WHERE YEAR  =  "2008"

Question: What are the names of all wines produced in 2008?
SQL: SELECT Name FROM WINE WHERE YEAR  =  "2008"

Question: List the grapes and appelations of all wines.
SQL: SELECT Grape ,  Appelation FROM WINE

Question: What are the grapes and appelations of each wine?
SQL: SELECT Grape ,  Appelation FROM WINE

Question: List the names and scores of all wines.
SQL: SELECT Name ,  Score FROM WINE

Question: What are the names and scores of all wines?
SQL: SELECT Name ,  Score FROM WINE

Question: List the area and county of all appelations.
SQL: SELECT Area ,  County FROM APPELLATIONS

Question: What are the areas and counties for all appelations?
SQL: SELECT Area ,  County FROM APPELLATIONS

Question: What are the prices of wines produced before the year of 2010?
SQL: SELECT Price FROM WINE WHERE YEAR  <  2010

Question: Return the prices of wines produced before 2010.
SQL: SELECT Price FROM WINE WHERE YEAR  <  2010

Question: List the names of all distinct wines that have scores higher than 90.
SQL: SELECT Name FROM WINE WHERE score  >  90

Question: What are the names of wines with scores higher than 90?
SQL: SELECT Name FROM WINE WHERE score  >  90

Question: List the names of all distinct wines that are made of red color grape.
SQL: SELECT DISTINCT T2.Name FROM GRAPES AS T1 JOIN WINE AS T2 ON T1.Grape  =  T2.Grape WHERE T1.Color  =  "Red"

Question: What are the names of wines made from red grapes?
SQL: SELECT DISTINCT T2.Name FROM GRAPES AS T1 JOIN WINE AS T2 ON T1.Grape  =  T2.Grape WHERE T1.Color  =  "Red"

Question: Find the names of all distinct wines that have appellations in North Coast area.
SQL: SELECT DISTINCT T2.Name FROM APPELLATIONs AS T1 JOIN WINE AS T2 ON T1.Appelation  =  T2.Appelation WHERE T1.Area  =  "North Coast"

Question: What are the distinct names of wines that have appellations in the North Coast area?
SQL: SELECT DISTINCT T2.Name FROM APPELLATIONs AS T1 JOIN WINE AS T2 ON T1.Appelation  =  T2.Appelation WHERE T1.Area  =  "North Coast"

Question: How many wines are produced at Robert Biale winery?
SQL: SELECT count(*) FROM WINE WHERE Winery  =  "Robert Biale"

Question: Count the number of wines produced at Robert Biale winery.
SQL: SELECT count(*) FROM WINE WHERE Winery  =  "Robert Biale"

Question: How many appelations are in Napa Country?
SQL: SELECT count(*) FROM APPELLATIONS WHERE County  =  "Napa"

Question: Count the number of appelations in Napa County.
SQL: SELECT count(*) FROM APPELLATIONS WHERE County  =  "Napa"

Question: Give me the average prices of wines that are produced by appelations in Sonoma County.
SQL: SELECT AVG(T2.Price) FROM APPELLATIONS AS T1 JOIN WINE AS T2 ON T1.Appelation  =  T2.Appelation WHERE T1.County  =  "Sonoma"

Question: What is the average price of wines produced in appelations in Sonoma County?
SQL: SELECT AVG(T2.Price) FROM APPELLATIONS AS T1 JOIN WINE AS T2 ON T1.Appelation  =  T2.Appelation WHERE T1.County  =  "Sonoma"

Question: What are the names and scores of wines that are made of white color grapes?
SQL: SELECT T2.Name ,   T2.Score FROM GRAPES AS T1 JOIN WINE AS T2 ON T1.Grape  =  T2.Grape WHERE T1.Color  =  "White"

Question: Give the names and scores of wines made from white grapes.
SQL: SELECT T2.Name ,   T2.Score FROM GRAPES AS T1 JOIN WINE AS T2 ON T1.Grape  =  T2.Grape WHERE T1.Color  =  "White"

Question: Find the maximum price of wins from the appelations in Central Coast area and produced before the year of 2005.
SQL: SELECT max(T2.Price) FROM APPELLATIONS AS T1 JOIN WINE AS T2 ON T1.Appelation  =  T2.Appelation WHERE T1.Area  =  "Central Coast" AND T2.year  <  2005

Question: What is the maximum price of wines from the appelation in the Central Coast area, which was produced before 2005?
SQL: SELECT max(T2.Price) FROM APPELLATIONS AS T1 JOIN WINE AS T2 ON T1.Appelation  =  T2.Appelation WHERE T1.Area  =  "Central Coast" AND T2.year  <  2005

Question: Find the the grape whose white color grapes are used to produce wines with scores higher than 90.
SQL: SELECT DISTINCT T1.Grape FROM GRAPES AS T1 JOIN WINE AS T2 ON T1.Grape  =  T2.Grape WHERE T1.Color  =  "White" AND T2.score  >  90

Question: Find the white grape used to produce wines with scores above 90.
SQL: SELECT DISTINCT T1.Grape FROM GRAPES AS T1 JOIN WINE AS T2 ON T1.Grape  =  T2.Grape WHERE T1.Color  =  "White" AND T2.score  >  90

Question: What are the wines that have prices higher than 50 and made of Red color grapes?
SQL: SELECT T2.Name FROM Grapes AS T1 JOIN WINE AS T2 ON T1.Grape  =  T2.Grape WHERE T1.Color  =  "Red" AND T2.price  >  50

Question: What are the names of wines made from red grapes and with prices above 50?
SQL: SELECT T2.Name FROM Grapes AS T1 JOIN WINE AS T2 ON T1.Grape  =  T2.Grape WHERE T1.Color  =  "Red" AND T2.price  >  50

Question: What are the wines that have prices lower than 50 and have appelations in Monterey county?
SQL: SELECT T2.Name FROM APPELLATIONS AS T1 JOIN WINE AS T2 ON T1.Appelation  =  T2.Appelation WHERE T1.County  =  "Monterey" AND T2.price  <  50

Question: Give the neames of wines with prices below 50 and with appelations in Monterey county.
SQL: SELECT T2.Name FROM APPELLATIONS AS T1 JOIN WINE AS T2 ON T1.Appelation  =  T2.Appelation WHERE T1.County  =  "Monterey" AND T2.price  <  50

Question: What are the numbers of wines for different grapes?
SQL: SELECT count(*) ,  Grape FROM WINE GROUP BY Grape

Question: How many wines are there for each grape?
SQL: SELECT count(*) ,  Grape FROM WINE GROUP BY Grape

Question: What are the average prices of wines for different years?
SQL: SELECT avg(Price) ,  YEAR FROM WINE GROUP BY YEAR

Question: What is the average prices of wines for each each?
SQL: SELECT avg(Price) ,  YEAR FROM WINE GROUP BY YEAR

Question: Find the distinct names of all wines that have prices higher than some wines from John Anthony winery.
SQL: SELECT DISTINCT Name FROM WINE WHERE Price  >  (SELECT min(Price) FROM wine WHERE Winery  =  "John Anthony")

Question: What are the distinct names of wines with prices higher than any wine from John Anthony winery.
SQL: SELECT DISTINCT Name FROM WINE WHERE Price  >  (SELECT min(Price) FROM wine WHERE Winery  =  "John Anthony")

Question: List the names of all distinct wines in alphabetical order.
SQL: SELECT DISTINCT Name FROM WINE ORDER BY Name

Question: What are the names of wines, sorted in alphabetical order?
SQL: SELECT DISTINCT Name FROM WINE ORDER BY Name

Question: List the names of all distinct wines ordered by price.
SQL: SELECT DISTINCT Name FROM WINE ORDER BY price

Question: What are the names of wines, sorted by price ascending?
SQL: SELECT DISTINCT Name FROM WINE ORDER BY price