Database: soccer_2016
Question: What are the teams that played in a match with the point of winning margin of 38 on April 30, 2009?
Evidence: point of winning margin of 38 refers to win_margin = 38; on April 30, 2009 refers to match_date = '2009-04-30'; team refers to Team_Name;
SQL: SELECT T1.Team_Name FROM Team AS T1 INNER JOIN Match AS T2 ON T1.Team_Id = T2.Team_1 WHERE T2.win_margin = 38 AND match_date = '2009-04-30'

Database: university
Question: How many Turkish universities are there in the database?
Evidence: Turkish universities refers to country_name = 'Turkey';
SQL: SELECT COUNT(*) FROM university AS T1 INNER JOIN country AS T2 ON T1.country_id = T2.id WHERE T2.country_name = 'Turkey'

Database: student_loan
Question: How many disabled students have payment due?
Evidence: payment due refers to bool = 'pos';
SQL: SELECT COUNT(T1.name) FROM no_payment_due AS T1 INNER JOIN disabled AS T2 ON T1.name = T2.name WHERE T1.bool = 'pos'

Database: beer_factory
Question: Which city does the customer who finished transaction no.103545 live in?
Evidence: transaction no. refers to TransactionID; TransactionID = 103545;
SQL: SELECT T1.City FROM customers AS T1 INNER JOIN `transaction` AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.TransactionID = 103545

Database: retails
Question: How many customers are in Brazil?
Evidence: Brazil is the name of the nation which refers to n_name = 'BRAZIL'
SQL: SELECT COUNT(T1.c_custkey) FROM customer AS T1 INNER JOIN nation AS T2 ON T1.c_nationkey = T2.n_nationkey WHERE T2.n_name = 'BRAZIL'

Database: retail_world
Question: What is the full name of the employee in charge of the Southern region who is to report to Andrew Fuller?
Evidence: full names = FirstName, LastName; report to represents a hierarchical relationship where the person being reported to is usually the direct supervisor of the reporter; Andrew Fuller refers to Employees WHERE FirstName = 'Andrew' AND LastName = 'Fuller'; Southern region refers to RegionDescription = 'Southern';
SQL: SELECT DISTINCT T1.FirstName, T1.LastName FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID INNER JOIN Territories AS T3 ON T2.TerritoryID = T3.TerritoryID INNER JOIN Region AS T4 ON T3.RegionID = T4.RegionID WHERE T4.RegionDescription = 'Southern' AND T1.ReportsTo = ( SELECT EmployeeID FROM Employees WHERE FirstName = 'Andrew' AND LastName = 'Fuller' )

Database: donor
Question: What is the id of the project that has the highest optional tip? Indicate the names of the resources that were requested.
Evidence: highest optional tip refers to subtract(total_price_including_optional_support, total_price_excluding_optional_support); names of the resources refers to item_name
SQL: SELECT T1.projectid, T1.item_name FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid ORDER BY T2.total_price_including_optional_support - T2.total_price_excluding_optional_support DESC LIMIT 1

Database: professional_basketball
Question: Name the team in which the coach won the title 'NBA Coach of the Year' in 2010.
Evidence: team name refers to teams.name; won the title 'NBA Coach of the Year' refers to award = 'NBA Coach of the Year'; in 2010 refers to year = 2010
SQL: SELECT DISTINCT T1.tmID FROM coaches AS T1 INNER JOIN awards_coaches AS T2 ON T1.coachID = T2.coachID WHERE T2.year = 2010 AND T2.award = 'NBA Coach of the Year'

Database: food_inspection_2
Question: How many businesses from ward 42 have at least 5 failed inspection results between 1/1/2010 to 12/31/2015?
Evidence: ward 42 refers to ward = 42; at least 5 failed inspection results refers to count(results = 'Fail') > = 5; between 1/1/2010 to 12/31/2015 refers to inspection_date between '2010-01-01' and '2015-12-31'
SQL: SELECT COUNT(DISTINCT T1.license_no) FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T2.inspection_date BETWEEN '2010-01-01' AND '2015-12-31' AND T1.ward = 42 AND T1.license_no IN ( SELECT license_no FROM ( SELECT license_no FROM inspection WHERE results = 'Fail' GROUP BY license_no HAVING COUNT(results) >= 5 ) )

Database: video_games
Question: Which game has the most sales in Japan?
Evidence: 
which game refers to game_name; most sales refers to MAX(num_sales); Japan refers to region_name = 'Japan';
SQL: SELECT T5.game_name FROM region AS T1 INNER JOIN region_sales AS T2 ON T1.id = T2.region_id INNER JOIN game_platform AS T3 ON T2.game_platform_id = T3.id INNER JOIN game_publisher AS T4 ON T3.game_publisher_id = T4.id INNER JOIN game AS T5 ON T4.game_id = T5.id WHERE T1.region_name = 'Japan' ORDER BY T2.num_sales DESC LIMIT 1

Database: soccer_2016
Question: What is the name of the player who has been chosen the most times for 'Man of the Series'?
Evidence: name of the player refers to Player_Name; most times for 'Man of the Series' refers to max(count(Man_of_the_Match))
SQL: SELECT T3.Player_Name FROM Season AS T1 INNER JOIN Match AS T2 ON T1.Man_of_the_Series = T2.Man_of_the_Match INNER JOIN Player AS T3 ON T2.Man_of_the_Match = T3.Player_Id GROUP BY T3.Player_Name ORDER BY COUNT(T1.Man_of_the_Series) DESC LIMIT 1

Database: menu
Question: Write down the image ID, full height, and full width of the menu that were used in the "100TH ANNIVERSARY OF BIRTH OF DANIEL WEBSTER" event.
Evidence: FALSE;
SQL: SELECT T1.image_id, T1.full_height, T1.full_width FROM MenuPage AS T1 INNER JOIN Menu AS T2 ON T2.id = T1.menu_id WHERE T2.event = '100TH ANNIVERSARY OF BIRTH OF DANIEL WEBSTER'

Database: soccer_2016
Question: How many players bat with their left hands?
Evidence: bat with their left hands refers to Batting_hand = 'Left-hand bat'
SQL: SELECT SUM(CASE WHEN T2.Batting_hand = 'Left-hand bat' THEN 1 ELSE 0 END) FROM Player AS T1 INNER JOIN Batting_Style AS T2 ON T1.Batting_hand = T2.Batting_Id

Database: soccer_2016
Question: Among the matches held in St. George's Park, give the match ID of the match with the highest winning margin points.
Evidence: held in St. George's Park refers to Venue_Name = 'St George''s Park'; highest winning margin points refers to MAX(Win_Margin)
SQL: SELECT T2.Match_Id FROM Venue AS T1 INNER JOIN Match AS T2 ON T1.venue_id = T2.venue_id WHERE T1.Venue_Name = 'St George''s Park' ORDER BY T2.Win_Margin DESC LIMIT 1

Database: public_review_platform
Question: In businesses with a category of automotive, how many of them has an star rating below 3?
Evidence: "Automotive" is the category of business; star rating below 3 refers to stars < 3
SQL: SELECT COUNT(T1.business_id) FROM Business AS T1 INNER JOIN Business_Categories ON T1.business_id = Business_Categories.business_id INNER JOIN Categories AS T3 ON Business_Categories.category_id = T3.category_id WHERE T3.category_name LIKE 'Automotive' AND T1.stars < 3

Database: professional_basketball
Question: Who is the coach for 'BOS' team in year 1950. List the coach ID together with the number of game won and lost.
Evidence: 'BOS' is the tmID; 1950 refers to year = 1950; number of game won refers to won; number of game lost refers to lost
SQL: SELECT coachID, won, lost FROM coaches WHERE year = 1950 AND tmID = 'BOS'

Database: movielens
Question: Please list the country of the movie that stars an actress who acts the worse.
Evidence: a_quality = 5 refers to act the best, a_quality = 0 refers to act the worst
SQL: SELECT T3.country FROM actors AS T1 INNER JOIN movies2actors AS T2 ON T1.actorid = T2.actorid INNER JOIN movies AS T3 ON T2.movieid = T3.movieid WHERE T1.a_gender = 'F' AND T1.a_quality = 0

Database: address
Question: List 10 cities with a median age over 40. Include their zip codes and area codes.
Evidence: median age over 40 refers to median_age > 40
SQL: SELECT T2.city, T2.zip_code, T1.area_code FROM area_code AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.median_age >= 40 LIMIT 10