Database: retails
Question: How many urgent orders did Clerk#000000001 handle in 1997?
Evidence: urgent order refers to o_orderpriority = '1-URGENT'; Clerk#000000001 refers to o_clerk = 'Clerk#000000001'; 1997 refers to year(o_orderdate) = 1997
SQL: SELECT COUNT(o_orderkey) FROM orders WHERE STRFTIME('%Y', o_orderdate) = '1997' AND o_clerk = 'Clerk#000000001' AND o_orderpriority = '1-URGENT'

Database: donor
Question: What is the total amount of all the donations made by the donor who made the highest donation in a single amount? Indicate the essay title to where he/she made his/her biggest donation.
Evidence: total amount of all the donations refers to sum(donation_total); highest donation refers to max(donation_total)
SQL: SELECT T2.donation_total, T1.title FROM essays AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T2.donation_total = ( SELECT MAX(donation_total) FROM donations )

Database: simpson_episodes
Question: List out the birth name of crews who are co-executive producer and higher than 1.60 meters.
Evidence: co-executive producer refers to role = 'co-executive producer'; higher than 1.60 meters refers to height_meters > 1.60
SQL: SELECT T1.birth_name FROM Person AS T1 INNER JOIN Award AS T2 ON T1.name = T2.person WHERE T2.role = 'co-executive producer' AND T1.height_meters > 1.60;

Database: law_episode
Question: What is the full place of birth of Rene Chenevert Balcer?
Evidence: full place of birth refers to birth_place, birth_region; Rene Chenevert Balcer refers to birth_name = 'Rene Chenevert Balcer'
SQL: SELECT birth_place, birth_region FROM Person WHERE birth_name = 'Rene Chenevert Balcer'

Database: sales_in_weather
Question: How many stores are in weather station 12?
Evidence: weather station 12 refers to station_nbr = 12; number of stores refers to Count(store_nbr)
SQL: SELECT SUM(store_nbr) FROM relation WHERE station_nbr = 12

Database: video_games
Question: What is the total number of sales across all regions?
Evidence: total number of sales = sum(num_sales)
SQL: SELECT SUM(T.num_sales) * 100000 FROM region_sales t

Database: airline
Question: List the air carrier's description of the flights with 0 departure delay.
Evidence: 0 departure delay refers to DEP_DELAY = 0;
SQL: SELECT T1.Description FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID WHERE T2.DEP_DELAY = 0 GROUP BY T1.Description

Database: cookbook
Question: What are the names of the ingredients that need to be cook in beef broth?
Evidence: 'cook in beef broth' refers to a preparation
SQL: SELECT T1.name FROM Ingredient AS T1 INNER JOIN Quantity AS T2 ON T1.ingredient_id = T2.ingredient_id WHERE T2.preparation = 'cooked in beef broth'

Database: disney
Question: Who directed the most popular movie?
Evidence: The most popular movie refers MAX(total_gross); who directed refers to director;
SQL: SELECT T2.director FROM movies_total_gross AS T1 INNER JOIN director AS T2 ON T1.movie_title = T2.name ORDER BY CAST(REPLACE(trim(T1.total_gross, '$'), ',', '') AS REAL) DESC LIMIT 1

Database: world_development_indicators
Question: Please calculate the average of Arms imports (SIPRI trend indicator values) of the European & Central Asian countries.
Evidence: European & Central Asian is the name of the region; IndicatorName = 'Arms imports (SIPRI trend indicator values)'; countries refer to CountryCode; DIVIDE(Sum(Value), Count(CountryCode));
SQL: SELECT CAST(SUM(T2.Value) AS REAL) / COUNT(T1.CountryCode) FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.Region = 'Europe & Central Asia' AND T2.IndicatorName = 'Arms imports (SIPRI trend indicator values)'

Database: sales_in_weather
Question: Tell the wet-bulb temperature of the weather station which contained store no.6 on 2012/2/15.
Evidence: store no.6 refers to store_nbr = 6; on 2012/2/15 refers to date = '2012-02-15'; wet-bulb temperature refers to wetbulb
SQL: SELECT T1.wetbulb FROM weather AS T1 INNER JOIN relation AS T2 ON T1.station_nbr = T2.station_nbr WHERE T2.store_nbr = 14 AND T1.`date` = '2012-02-15'

Database: airline
Question: What is the flight number of the flight operated by American Airlines Inc. that had the longest delay in departure?
Evidence: flight numbers refers to OP_CARRIER_FL_NUM; American Airlines Inc. refers to Description = 'American Airlines Inc.: AA'; longest delay in departure refers to MAX(DEP_DELAY);
SQL: SELECT T1.OP_CARRIER_FL_NUM FROM Airlines AS T1 INNER JOIN Airports AS T2 ON T2.Code = T1.ORIGIN INNER JOIN `Air Carriers` AS T3 ON T1.OP_CARRIER_AIRLINE_ID = T3.Code WHERE T3.Description = 'American Airlines Inc.: AA' ORDER BY T1.DEP_TIME DESC LIMIT 1

Database: student_loan
Question: How many students who have never been absent from school?
Evidence: have never been absent refers to `month` = 0;
SQL: SELECT COUNT(name) FROM longest_absense_from_school WHERE month = 0

Database: food_inspection_2
Question: Show the phone number of the sanitarian who was responsible for inspection no.634597.
Evidence: phone number refers to phone; sanitarian refers to title = 'Sanitarian'; inspection no.634597 refers to inspection_id = '634597'
SQL: SELECT T2.phone FROM inspection AS T1 INNER JOIN employee AS T2 ON T1.employee_id = T2.employee_id WHERE T1.inspection_id = 634597 AND T2.title = 'Sanitarian'

Database: world
Question: List the languages used in the USA.
Evidence: USA refers to CountryCode = 'USA';
SQL: SELECT Language FROM CountryLanguage WHERE CountryCode = 'USA'

Database: public_review_platform
Question: List out the category name of business id 5.
SQL: SELECT T1.category_name FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id WHERE T2.business_id = 5

Database: donor
Question: What percentage of projects in the City of Santa Barbara are in suburban metro?
Evidence: City of Santa Barbara refers to school_city = 'Santa Barbara'; percentage refers to DIVIDE(school_metro = 'suburban'; school_metro)*100
SQL: SELECT CAST(SUM(CASE WHEN school_metro = 'suburban' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(projectid) FROM projects WHERE school_city = 'Santa Barbara'

Database: beer_factory
Question: How many root beers did Tom Hanks purchase between 2015 to 2016?
Evidence: between 2015 to 2016 refers to TransactionDate > = '2015-01-01' AND TransactionDate < '2016-12-31';
SQL: SELECT COUNT(T2.RootBeerID) FROM customers AS T1 INNER JOIN `transaction` AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.First = 'Tom' AND T1.Last = 'Hanks' AND T2.TransactionDate BETWEEN '2015-01-01' AND '2016-12-31'

Database: genes
Question: For the pairs of genes with one having 8 chromosomes and the other having 6 chromosomes, what is the highest expression correlation score?
SQL: SELECT T2.Expression_Corr FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 WHERE T1.Chromosome = 6 OR T1.Chromosome = 8 ORDER BY T2.Expression_Corr DESC LIMIT 1

Database: professional_basketball
Question: Player from which team has the highest point per minute in NBA from 1991 to 2000?
Evidence: team refers to tmID; the highest point per minute refers to max(divide(points, minutes)); NBA refers to lgID = 'NBA'; from 1991 to 2000 refers to year BETWEEN 1991 AND 2000
SQL: SELECT tmID FROM players_teams WHERE year BETWEEN 1991 AND 2000 ORDER BY CAST(points AS REAL) / minutes DESC LIMIT 1

Database: menu
Question: How many dishes are there on the menu "Zentral Theater Terrace"?
Evidence: Zentral Theater Terrace is a name of menu;
SQL: SELECT COUNT(*) FROM Menu WHERE name = 'Zentral Theater Terrace'

Database: sales
Question: Calculate the total number of sales closed by Michel E. DeFrance?
SQL: SELECT COUNT(T1.SalesID) FROM Sales AS T1 INNER JOIN Employees AS T2 ON T1.SalesPersonID = T2.EmployeeID WHERE T2.FirstName = 'Michel' AND T2.MiddleInitial = 'e' AND T2.LastName = 'DeFrance'