Database: retails
Question: Among the orders made by customers in the household segment, how many of them are urgent?
Evidence: orders in household segment refer to o_orderkey where c_mktsegment = 'HOUSEHOLD'; the order is urgent if o_orderpriority = '1-URGENT' ;
SQL: SELECT COUNT(T1.o_orderpriority) FROM orders AS T1 INNER JOIN customer AS T2 ON T1.o_custkey = T2.c_custkey WHERE T2.c_mktsegment = 'HOUSEHOLD' AND T1.o_orderpriority = '1-URGENT'

Database: professional_basketball
Question: Which player, born in Winter Haven, played 12 minutes per season during the 1980s in the All-Stars?
Evidence: born in Winter Haven refers to birthCity = 'Winter Haven'; during the 1980s in All-Stars refers to season_id = 1980; played in 12 minutes  per season refers to minutes = 12
SQL: SELECT DISTINCT T1.firstName, T1.middleName, T1.lastName FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE T1.birthCity = 'Winter Haven' AND T2.season_id BETWEEN 1980 AND 1989 AND T2.minutes = 12

Database: superstore
Question: How many quantities of Advantus plastic paper clips were ordered overall?
Evidence: Advantus plastic paper clips is the "Product Name";
SQL: SELECT SUM(T1.Quantity) FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.`Product Name` = 'Advantus Plastic Paper Clips'

Database: european_football_1
Question: What is the name of the division in which Club Brugge and Genk competed on September 13, 2009?
Evidence: September 13, 2009 refers to Date = '2009-09-13'; Club Brugge refers to HomeTeam; Genk refers to AwayTeam;
SQL: SELECT T2.name FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T1.Date = '2009-09-13' and T1.HomeTeam = 'Club Brugge' AND T1.AwayTeam = 'Genk'

Database: music_tracker
Question: What is the release title of the single under the "funk" tag that was released the oldest?
Evidence: release title of single refers to groupName where releaseType = 'single'; the oldest means coming before all others in time and refers to MIN(groupYear);
SQL: SELECT T1.groupName FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T2.tag LIKE 'funk' AND T1.releaseType = 'single' ORDER BY T1.groupYear LIMIT 1

Database: world
Question: What is the capital city and population of San Marino?
Evidence: capital city refers to Capital; San Marino is a name of country;
SQL: SELECT T1.Capital, T2.Population FROM Country AS T1 INNER JOIN City AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = 'San Marino'

Database: retail_complains
Question: On which day was the most verbose complaint received?
Evidence: day received refers to "Date received"; most verbose complaint refers to MAX(ser_time);
SQL: SELECT `Date received` FROM callcenterlogs WHERE ser_time = ( SELECT MAX(ser_time) FROM callcenterlogs )

Database: retail_world
Question: What is the name of the supplier that supplies the most products to the company?
Evidence: name of the supplier refers to SupplierID; the most product refers to max(count(ProductID))
SQL: SELECT T1.SupplierID FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID GROUP BY T1.SupplierID ORDER BY COUNT(*) DESC LIMIT 1

Database: video_games
Question: List the names of all the publishers who published one game only.
Evidence: name of publisher refers to publisher_name; published one game only refers to count(publisher_id) = 1
SQL: SELECT T.publisher_name FROM ( SELECT T2.publisher_name, COUNT(DISTINCT T1.game_id) FROM game_publisher AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id GROUP BY T2.publisher_name HAVING COUNT(DISTINCT T1.game_id) = 1 ) t

Database: european_football_1
Question: Which team had the most final-time home-team goals in the 2021 season's matches of the Bundesliga division?
Evidence: Bundesliga is the name of division; the most final-time home-team goals refers to MAX(FTHG);
SQL: SELECT T1.HomeTeam FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.name = 'Bundesliga' AND T1.season = 2021 ORDER BY T1.FTHG DESC LIMIT 1

Database: soccer_2016
Question: Count the total venues located in Pune City.
Evidence: Pune City refers to City_Name = 'Pune'
SQL: SELECT SUM(T1.Venue_Name) FROM Venue AS T1 INNER JOIN City AS T2 ON T1.City_Id = T2.City_Id WHERE T2.City_Name = 'Pune'

Database: university
Question: Show the id of University of Orléans.
Evidence: University of Orléans refers to university_name = 'University of Orléans';
SQL: SELECT id FROM university WHERE university_name = 'University of Orléans'

Database: olympics
Question: What is the average age of competitors who participated in 1988 Winter?
Evidence: AVG(age) where games_name = '1988 Winter';
SQL: SELECT AVG(T2.age) FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T1.games_name = '1988 Winter'

Database: music_tracker
Question: Which artist has released the most singles with the tag "soul"?
Evidence: the most singles refer to MAX(COUNT(releaseType = 'single'));
SQL: SELECT T1.artist FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T2.tag = 'soul' AND T1.releaseType = 'single' GROUP BY T1.artist ORDER BY COUNT(T1.releaseType) DESC LIMIT 1

Database: cookbook
Question: What is the average calorie count for all recipes using coarsely ground black pepper?
Evidence: coarsely ground black pepper is a name of an ingredient; calculation = AVG(calories)
SQL: SELECT AVG(T3.calories) FROM Ingredient AS T1 INNER JOIN Quantity AS T2 ON T2.ingredient_id = T1.ingredient_id INNER JOIN Nutrition AS T3 ON T3.recipe_id = T2.recipe_id WHERE T1.name = 'coarsely ground black pepper'

Database: simpson_episodes
Question: How many stars did most of the voters give in star score for the episode Lost Verizon?
Evidence: "Lost Verizon" is the title of episode; most voters refers to Max(votes)
SQL: SELECT T2.stars FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T1.title = 'Lost Verizon' ORDER BY T2.votes DESC LIMIT 1;

Database: olympics
Question: Provide the age of the tallest competitor.
Evidence: the tallest refers to MAX(height);
SQL: SELECT T2.age FROM person AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.person_id ORDER BY T1.height DESC LIMIT 1

Database: address
Question: What is the difference in the most populated city of Allentown-Bethlehem-Easton, PA-NJ in 2020 against its population in 2010?
Evidence: "Allentown-Bethlehem-Easton, PA-NJ" is the CBSA_name; most populated city refers to Max(population_2020); difference = Subtract (population_2020, population_2011)
SQL: SELECT T1.population_2020 - T1.population_2010 AS result_data FROM zip_data AS T1 INNER JOIN CBSA AS T2 ON T1.CBSA = T2.CBSA WHERE T2.CBSA_name = 'Allentown-Bethlehem-Easton, PA-NJ' ORDER BY T1.population_2020 DESC LIMIT 1

Database: language_corpus
Question: How many pages does the Catalan language have in Wikipedia?
Evidence: Catalan language refers to lang = 'ca'
SQL: SELECT pages FROM langs WHERE lang = 'ca'

Database: books
Question: List all books written in Arabic.
Evidence: "Arabic" is the language_name; book refers to title
SQL: SELECT T1.title FROM book AS T1 INNER JOIN book_language AS T2 ON T1.language_id = T2.language_id WHERE T2.language_name = 'Arabic'

Database: movie_3
Question: Which film has the longest duration of film screening? Please give its title.
Evidence: longest duration of film refers to Max(length)
SQL: SELECT title FROM film ORDER BY length DESC LIMIT 1

Database: music_tracker
Question: Among the releases with the tag "1980s", which one of them is the most downloaded? Please give its title.
Evidence: title refers to groupName; the most downloaded refers to MAX(totalSnatched);
SQL: SELECT T1.groupName FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T2.tag = '1980s' ORDER BY T1.totalSnatched DESC LIMIT 1