Database: superstore
Question: List the products ordered by Becky Martin around the Central region.
Evidence: ordered by Becky Martin refers to "Customer Name" = 'Becky Martin'; Region = 'Central'; products refers to "Product Name"
SQL: SELECT DISTINCT T3.`Product Name` FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T2.`Product ID` WHERE T1.`Customer Name` = 'Becky Martin' AND T3.Region = 'Central'

Database: regional_sales
Question: List the store located cities with regions in no water area of California state.
Evidence: cities refer to City Name; no water area refers to Water Area = 0;
SQL: SELECT DISTINCT T2.`City Name` FROM Regions AS T1 INNER JOIN `Store Locations` AS T2 ON T2.StateCode = T1.StateCode WHERE T2.State = 'California' AND T2.`Water Area` = '0'

Database: student_loan
Question: How many students have been absent less than 4 months?
Evidence: absent less than 4 months refers to month < 4;
SQL: SELECT COUNT(name) FROM longest_absense_from_school WHERE month < 4

Database: retail_world
Question: Please calculate the average unit price for products of Formaggi Fortini s.r.l.
Evidence: "Formaggi Fortini s.r.l." is the CompanyName; average unit price = AVG(UnitPrice)
SQL: SELECT SUM(T1.UnitPrice) / COUNT(T1.SupplierID) FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Formaggi Fortini s.r.l.'

Database: public_review_platform
Question: Between 2006 and 2007, which year ID had the greater number in elite user?
Evidence: 2006 and 2007 refers to BETWEEN 2006 AND 2007; greater number in elite user refers to count(user_id)
SQL: SELECT year_id FROM Elite WHERE year_id IN (2006, 2007) GROUP BY year_id ORDER BY COUNT(user_id) DESC LIMIT 1

Database: music_platform_2
Question: What is the longest review?
Evidence: review refers to content; longest review refers to Max(content)
SQL: SELECT title FROM reviews ORDER BY LENGTH(content) DESC LIMIT 1

Database: retail_complains
Question: Which state has the most cities?
Evidence: state refers to state_abbrev; most cities refers to max(count(city))
SQL: SELECT state_abbrev FROM district GROUP BY state_abbrev ORDER BY COUNT(city) DESC LIMIT 1

Database: shooting
Question: Of all male officers, what percentage are black officers?
Evidence: male refers to gender = 'M'; black refers to race = 'B'; percentage = divide(count(officers where race = 'B'), count(officers)) where gender = 'M' * 100%
SQL: SELECT CAST(SUM(race = 'B') AS REAL) * 100 / COUNT(case_number) FROM officers WHERE gender = 'M'

Database: sales
Question: How many sales people are handling all the customers?
SQL: SELECT COUNT(EmployeeID) FROM Employees

Database: simpson_episodes
Question: How many executive producers are the nominees for the award of "Outstanding Animated Program (For Programming Less Than One Hour)"?
Evidence: the nominees refers to result = 'Nominee'; executive producers refers to role = 'executive producer'
SQL: SELECT COUNT(*) FROM Award WHERE role = 'executive producer' AND result = 'Nominee' AND award = 'Outstanding Animated Program (For Programming Less Than One Hour)';

Database: restaurant
Question: In which streets of the city of San Francisco are there restaurants that serve seafood?
Evidence: street refers to street_name; seafood refers to food_type = 'seafood'
SQL: SELECT T1.street_name FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T1.city = 'san francisco' AND T2.food_type = 'seafood' AND street_name IS NOT NULL

Database: cs_semester
Question: Among the students with a gpa of 3.1 to 3.7, how many of them are undergraduate students?
Evidence: gpa of 3.1 to 3.7 refers to gpa BETWEEN 3.1 AND 3.7; undergraduate students refers to type = 'UG';
SQL: SELECT COUNT(student_id) FROM student WHERE gpa BETWEEN 3.1 AND 3.7 AND type = 'UG'

Database: music_platform_2
Question: Please list the titles of the podcasts for which the author whose ID is F7E5A318989779D has written a review.
Evidence: author whose ID is F7E5A318989779D refers to author_id = 'F7E5A318989779D'
SQL: SELECT T2.title FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T2.author_id = 'F7E5A318989779D'

Database: public_review_platform
Question: How many category id have low review count and rating more than 2?
Evidence: rating more than 2 refers to stars > 2;
SQL: SELECT COUNT(DISTINCT T1.category_id) FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id INNER JOIN Business AS T3 ON T2.business_id = T3.business_id WHERE T3.review_count = 'Low' AND T3.stars > 2

Database: human_resources
Question: Which position has the highest number of female employees with a 2 year degree?
Evidence: 2 year degree refers to educationrequired = '2 year degree'; female refers to gender = 'F'; the highest number of employees refers to MAX(positionID)
SQL: SELECT T2.positiontitle FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T2.educationrequired = '2 year degree' AND T1.gender = 'F' GROUP BY T2.positiontitle ORDER BY COUNT(T2.positiontitle) DESC LIMIT 1

Database: video_games
Question: List the platform ID of the game titled Airborne Troops: Countdown to D-Day.
Evidence: Airborne Troops: Countdown to D-Day refers to game_name = 'Airborne Troops: Countdown to D-Day';
SQL: SELECT T1.platform_id FROM game_platform AS T1 INNER JOIN game_publisher AS T2 ON T1.game_publisher_id = T2.id INNER JOIN game AS T3 ON T2.game_id = T3.id WHERE T3.game_name = 'Airborne Troops: Countdown to D-Day'

Database: superstore
Question: What is the profit from selling the "O'Sullivan Living Dimensions 2-Shelf Bookcases"?
Evidence: "O'Sullivan Living Dimensions 2-Shelf Bookcases" refers to "Product Name"
SQL: SELECT DISTINCT T1.Profit FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.`Product Name` = 'O''Sullivan Living Dimensions 2-Shelf Bookcases'

Database: university
Question: How many universities got less than 50 scores under ranking criteria ID 6 in 2011?
Evidence: in 2011 refers to year 2011; less than 50 scores refers to score < 50;
SQL: SELECT COUNT(*) FROM university_ranking_year WHERE ranking_criteria_id = 6 AND year = 2011 AND score < 50

Database: law_episode
Question: What is the title of the episode with the keyword "laundering money"?
Evidence: keyword "laundering money" refers to keyword = 'laundering money'
SQL: SELECT T1.title FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id WHERE T2.keyword = 'laundering money'

Database: video_games
Question: What are the names of the games that were published by 505 Games?
Evidence: name of game refers to game_name; published by 505 Games refers to publisher_name = '505 Games'
SQL: SELECT T3.game_name FROM publisher AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.publisher_id INNER JOIN game AS T3 ON T2.game_id = T3.id WHERE T1.publisher_name = '505 Games'

Database: disney
Question: Among the movies directed by Wolfgang Reitherman, which one of them was the most popular?
Evidence: directed by Wolfgang Reitherman refers to director = 'Wolfgang Reitherman'; the most popular movie refers to MAX(total_gross);
SQL: SELECT T2.movie_title FROM director AS T1 INNER JOIN movies_total_gross AS T2 ON T1.name = T2.movie_title WHERE T1.director = 'Wolfgang Reitherman' ORDER BY T2.total_gross DESC LIMIT 1

Database: software_company
Question: Of the first 60,000 customers' responses to the incentive mailing sent by the marketing department, how many of them are considered a true response?
Evidence: RESPONSE = 'true';
SQL: SELECT COUNT(REFID) custmoer_number FROM Mailings1_2 WHERE RESPONSE = 'true'