Database: retail_world
Question: Please list the home phone numbers of the employees who are in charge of the sales in the territories in the Eastern Region.
Evidence: home phone numbers refers to HomePhone; Eastern Region refers to RegionDescription = 'Eastern';
SQL: SELECT T1.HomePhone 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 = 'Eastern ' GROUP BY T1.HomePhone

Database: olympics
Question: At which age did A Lamusi participate in 2012 Summer?
Evidence: 2012 Summer refers to games_name = '2012 Summer';
SQL: SELECT 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 = '2012 Summer' AND T3.full_name = 'A Lamusi'

Database: legislator
Question: List the full name of all past legislators that chose Pro-Administration as their political party in year 1791.
Evidence: full name refers to official_full_name; chose Pro-Administration as their political party refers to party = 'Pro-Administration'; 1791 refers to start < = 1791 AND END > = 1791
SQL: SELECT T1.first_name, T1.last_name FROM historical AS T1 INNER JOIN `historical-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.party = 'Pro-Administration' AND CAST(T2.start AS DATE) <= 1791 AND CAST(T2.END AS DATE) >= 1791

Database: software_company
Question: What is the income of female customers ages from 30 to 55 years old and has an occupation of machine-op-inspct?
Evidence: female customers ages from 30 to 55 years old refer to SEX = 'Female' where age BETWEEN 30 AND 55; income refers to INCOME_K;
SQL: SELECT T2.INCOME_K FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID WHERE T1.SEX = 'Female' AND T1.age >= 30 AND T1.age <= 55 AND T1.OCCUPATION = 'Machine-op-inspct'

Database: talkingdata
Question: How many OPPO devices are there?
Evidence: OPPO devices refers to phone_brand = 'OPPO';
SQL: SELECT COUNT(device_id) FROM phone_brand_device_model2 WHERE phone_brand = 'OPPO'

Database: video_games
Question: List down the names of the games in the racing genre.
Evidence: name of games refers to game_name; racing genre refers to genre_name = 'Racing';
SQL: SELECT T1.game_name FROM game AS T1 INNER JOIN genre AS T2 ON T1.genre_id = T2.id WHERE T2.genre_name = 'Racing'

Database: menu
Question: List the top five dishes, by descending order, in terms of highest price.
Evidence: highest price refers to MAX(highest_price);
SQL: SELECT name FROM Dish ORDER BY highest_price DESC LIMIT 5

Database: video_games
Question: List down the game platform IDs of games with a region ID of 1.
SQL: SELECT T.game_platform_id FROM region_sales AS T WHERE T.region_id = 1

Database: computer_student
Question: List the advisor IDs for students with eighth year of program and position status in faculty of those professors.
Evidence: advisor IDs refers to p_id_dummy and person.p_id where professor = 1; eighth year of program refers to yearsInprogram = 'Year_8'; position status in faculty of those professors refers to hasPosition
SQL: SELECT T1.p_id_dummy, T2.hasPosition FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram = 'Year_8'

Database: soccer_2016
Question: List the name and country of the players who got more than average catches in ascending order of the number of catches.
Evidence: name and country of the players refers to Player_Name and Country_Name; catches refers to Out_name = 'caught'; average catches refers to divide(count(Player_ID) when Out_name = 'caught', sum(Player_ID))
SQL: SELECT T1.Player_Name, T4.Country_Name FROM Player AS T1 INNER JOIN Wicket_Taken AS T2 ON T1.Player_Id = T2.Fielders INNER JOIN Out_Type AS T3 ON T2.Kind_Out = T3.Out_Id INNER JOIN Country AS T4 ON T1.Country_Name = T4.Country_Id GROUP BY T1.Player_Name ORDER BY COUNT(T3.Out_Name) ASC

Database: donor
Question: How many teachers that have Literature & Writing as their primary focus subject use 'Mr' as their teacher prefix?
Evidence: Literature & Writing' is primary_focus_subject; use 'Mr' as their teacher prefix refers to teacher_prefix = 'Mr';
SQL: SELECT COUNT(teacher_acctid) FROM projects WHERE teacher_prefix = 'Mr.' AND primary_focus_subject = 'Literature & Writing'

Database: law_episode
Question: Who are the actors with a height of over 1.80m in an episode that won an award?
Evidence: who refers to name; a height of over 1.80m refers to height_meters > 1.80; won an award refers to result = 'Winner'
SQL: SELECT T2.name FROM Award AS T1 INNER JOIN Person AS T2 ON T1.person_id = T2.person_id WHERE T1.result = 'Winner' AND T2.height_meters > 1.80

Database: movielens
Question: How many horror movies were made by the worst directors?
Evidence: d_quality = 5 refers to direct the best, d_quality = 0 refers to direct the worst
SQL: SELECT COUNT(T1.movieid) FROM movies2directors AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid INNER JOIN directors AS T3 ON T1.directorid = T3.directorid WHERE T1.genre = 'horror' AND T3.d_quality = 0

Database: retail_world
Question: List the full name of all employees who work in the Northern region.
Evidence: full names = FirstName, LastName; Northern region refers to RegionDescription = 'Northern';
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 = 'Northern'

Database: address
Question: Among the listed cities, provide the area code of the city with the largest water area.
Evidence: the largest water area refers to MAX(water_area);
SQL: SELECT T1.area_code FROM area_code AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.water_area = ( SELECT MAX(water_area) FROM zip_data )

Database: address
Question: Among the cities with alias St Thomas, provide the type of postal point for each city.
SQL: SELECT DISTINCT T2.type FROM alias AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.alias = 'St Thomas'

Database: movies_4
Question: How many adventure movies are there that were released in 2000?
Evidence: adventure movies refers to genre_name = 'Adventure'; released in 2000 refers to release_date LIKE '2000%'
SQL: SELECT COUNT(T1.movie_id) FROM movie AS T1 INNER JOIN movie_genres AS T2 ON T1.movie_id = T2.movie_id INNER JOIN genre AS T3 ON T2.genre_id = T3.genre_id WHERE T3.genre_name = 'Adventure' AND CAST(STRFTIME('%Y', T1.release_date) AS INT) = 2000

Database: cars
Question: Among the cars produced in 1975, provide IDs, names, and producing countries of the cars with the maximum number of cylinders.
Evidence: produced in 1975 refers to model_year = 1975; names refers to car_name; producing countries refers to country; the maximum number of cylinders refers to max(cylinders)
SQL: SELECT T1.ID, T1.car_name, T3.country FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country WHERE T2.model_year = 1975 ORDER BY T1.cylinders DESC LIMIT 1

Database: university
Question: What is the name of the university with the most international students in 2011?
Evidence: in 2011 refers to year 2011; the most international students refers to MAX(DIVIDE(MULTIPLY(num_students,  pct_international_students), 100)); name of university refers to university_id
SQL: SELECT T2.university_name FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T1.year = 2011 ORDER BY T1.pct_international_students DESC LIMIT 1