Database: food_inspection
Question: Provide eateries' IDs, risk categories and descriptions with violation ID of 103101.
Evidence: eateries' IDs refer to business_id; violation ID of 103101 refers to violation_type_id = '103101';
SQL: SELECT business_id, risk_category, description FROM violations WHERE violation_type_id = '103101'

Database: codebase_comments
Question: How many solution paths are there inside the 2nd most popular repository?
Evidence: more watchers mean that this repository is more popular; most popular repository refers to max(Watchers);
SQL: SELECT COUNT(DISTINCT T2.Path) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Watchers = ( SELECT Watchers FROM Repo ORDER BY Watchers DESC LIMIT 1, 1 )

Database: retail_world
Question: List all the products that were shipped to Starenweg 5.
Evidence: products shipped to Starenweg 5 refer to ProductName where ShipAddress = 'Starenweg 5';
SQL: SELECT T3.ProductName FROM Orders AS T1 INNER JOIN `Order Details` AS T2 ON T1.OrderID = T2.OrderID INNER JOIN Products AS T3 ON T2.ProductID = T3.ProductID WHERE T1.ShipAddress = 'Starenweg 5' GROUP BY T3.ProductName

Database: simpson_episodes
Question: How old was composer of the show when he was nominated for Emmy's Outstanding Music Composition for a Series in 2009. Indicate his full name as well.
Evidence: in 2009 refers to year = 2009; old refers to SUBTRACT(2009, birthdate); composer of the show refers to role = 'composer'; Emmy's refers to organization = 'Primetime Emmy Awards'; nominated refers to result = 'Nominee'; Outstanding Music Composition refers to award = 'Outstanding Music Composition for a Series (Original Dramatic Score)'
SQL: SELECT T1.year - T2.birthdate AS ageIn2009, T2.name FROM Award AS T1 INNER JOIN Person AS T2 ON T1.person = T2.name WHERE T1.role = 'composer' AND T1.organization = 'Primetime Emmy Awards' AND T1.award = 'Outstanding Music Composition for a Series (Original Dramatic Score)' AND T1.result = 'Nominee' AND T1.year = 2009;

Database: soccer_2016
Question: List the player's ID of the top five players, by descending order, in terms of bowling skill.
Evidence: player's ID refers to Player_Id
SQL: SELECT Player_Id FROM Player ORDER BY Bowling_skill DESC LIMIT 5

Database: book_publishing_company
Question: Is the author of "Sushi, Anyone?" on the contract?
Evidence: contract = 1 means on contract; contract = 0 means not on contract
SQL: SELECT T1.contract FROM authors AS T1 INNER JOIN titleauthor AS T2 ON T1.au_id = T2.au_id INNER JOIN titles AS T3 ON T2.title_id = T3.title_id WHERE T3.title = 'Sushi, Anyone?'

Database: food_inspection
Question: How many restaurants' owners are in California?
Evidence: restaurants' owners in California refer to owner_state = 'CA';
SQL: SELECT COUNT(owner_state) FROM businesses WHERE owner_state = 'CA'

Database: genes
Question: How many non-essential genes are located in the nucleus?
SQL: SELECT COUNT(T1.GeneID) FROM Genes AS T1 INNER JOIN Classification AS T2 ON T1.GeneID = T2.GeneID WHERE T2.Localization = 'nucleus' AND T1.Essential = 'Non-Essential'

Database: retails
Question: Among the suppliers for the parts ordered in order no.4, how many of them are in debt?
Evidence: order no.4 refers to l_orderkey = 4; in debt refers to s_acctbal < 0
SQL: SELECT COUNT(T1.l_linenumber) FROM lineitem AS T1 INNER JOIN supplier AS T2 ON T1.l_suppkey = T2.s_suppkey WHERE T1.l_orderkey = 4 AND T2.s_acctbal < 0

Database: donor
Question: How many donations were paid via credit card to Memphis City School District?
Evidence: paid via credit card refer to payment method = creditcard; Memphis City School District refer to school_district
SQL: SELECT COUNT(T1.projectid) FROM donations AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.payment_method = 'creditcard' AND T2.school_district = 'Memphis City School District'

Database: world_development_indicators
Question: List down the World Bank code of the countries whose country note has described "Data source : Human Mortality Database by University of California, Berkeley, and Max Planck Institute for Demographic Research."? Please include their lending category.
Evidence: World Bank code refers to Wb2code; Data source refers to Description
SQL: SELECT DISTINCT T1.Wb2code, T1.LendingCategory FROM Country AS T1 INNER JOIN CountryNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T2.Description = 'Data source : Human Mortality Database by University of California, Berkeley, and Max Planck Institute for Demographic Research.' AND T1.LendingCategory != ''

Database: menu
Question: How many dishes are there in total in the menus with the name "Waldorf Astoria"?
Evidence: FALSE;
SQL: SELECT SUM(CASE WHEN T3.name = 'Waldorf Astoria' THEN 1 ELSE 0 END) FROM MenuItem AS T1 INNER JOIN MenuPage AS T2 ON T1.menu_page_id = T2.id INNER JOIN Menu AS T3 ON T2.menu_id = T3.id

Database: soccer_2016
Question: How many Orange Cap awards were won by CH Gayle?
Evidence: CH Gayle refers to Player_Name = 'CH Gayle'
SQL: SELECT SUM(CASE WHEN T1.Player_Name = 'CH Gayle' THEN 1 ELSE 0 END) AS cnt FROM Player AS T1 INNER JOIN Season AS T2 ON T1.Player_Id = T2.Orange_Cap

Database: simpson_episodes
Question: How many times was Ian Maxtone-Graham nominated for an award in Writers Guild of America, USA?
Evidence: "Ian Maxtone-Graham" is the person; nominated refers to result = 'Nominee'; 'Writers Guild of America, USA' is the organization
SQL: SELECT COUNT(award_id) FROM Award WHERE person = 'Ian Maxtone-Graham' AND organization = 'Writers Guild of America, USA' AND result = 'Nominee';

Database: superstore
Question: Which order of Logitech G600 MMO Gaming Mouse has the highest total cost?
Evidence: Logitech G600 MMO Gaming Mouse refers to "Product Name"; highest total cost refers to MAX(SUTRACT(MULTIPLY(DIVIDE(Sales, SUTRACT(1, discount)), Quantity), Profit))
SQL: SELECT T1.`Order ID` FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.`Product Name` = 'Logitech G600 MMO Gaming Mouse' GROUP BY T1.`Order ID` ORDER BY SUM((T1.Sales / (1 - T1.Discount)) * T1.Quantity - T1.Profit) DESC LIMIT 1

Database: beer_factory
Question: What is the average cost of root beers purchased for more than 2 dollars and sold in bottles?
Evidence: average cost = DIVIDE(SUM(PurchasePrice > 2), COUNT(RootBeerID) WHERE PurchasePrice > 2); more than 2 dollars refers to PurchasePrice > 2; in bottles refers to ContainerType = 'Bottle';
SQL: SELECT AVG(T2.PurchasePrice) FROM rootbeer AS T1 INNER JOIN `transaction` AS T2 ON T1.RootBeerID = T2.RootBeerID INNER JOIN rootbeerbrand AS T3 ON T1.BrandID = T3.BrandID WHERE T1.ContainerType = 'Bottle' AND T2.PurchasePrice > 2

Database: retail_world
Question: Which product of Exotic Liquids company that have the highest reorder levels?
Evidence: 'Exotic Liquids' is a CompanyName; the highest reorder levels refers to MAX(ReorderLevel)
SQL: SELECT T1.ProductName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Exotic Liquids' ORDER BY T1.ReorderLevel DESC LIMIT 1

Database: cars
Question: List the name of the most expensive car.
Evidence: car's name refers to car_name; the most expensive refers to max(price)
SQL: SELECT T1.car_name FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID ORDER BY T2.price DESC LIMIT 1

Database: european_football_1
Question: Which team had more home victories in the 2021 season's matches of the Bundesliga division, Augsburg or Mainz?
Evidence: Bundesliga is the name of division; more home victories refer to MAX(FTR = 'H)'; Augsburg and Mainz are names of teams and refer to HomeTeam;
SQL: SELECT CASE WHEN COUNT(CASE WHEN T1.HomeTeam = 'Augsburg' THEN 1 ELSE NULL END) - COUNT(CASE WHEN T1.HomeTeam = ' Mainz' THEN 1 ELSE NULL END) > 0 THEN 'Augsburg' ELSE 'Mainz' END FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T1.season = 2021 AND T1.FTR = 'H'