Database: world_development_indicators
Question: What is the percentage of countries in the Middle East and North Africa that have finished reporting on their real external debt?
Evidence: percentage = divide(count(countrycode where  ExternalDebtReportingStatus = 'Actual' ), count(countrycode))*100%; in the Middle East and North Africa refers to region = 'Middle East & North Africa'; have finished reporting on their real external debt refers to ExternalDebtReportingStatus = 'Actual'
SQL: SELECT CAST(SUM(CASE WHEN ExternalDebtReportingStatus = 'Actual' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(CountryCode) FROM Country WHERE region = 'Middle East & North Africa'

Database: college_completion
Question: Give the state and name of institutions in year of data release from 2010 to 2012 with black students.
Evidence: name of institutions refers to chronname; year of data release refers to year; from '2010' to '2012' refers to year BETWEEN 2010 AND 2012; Black refers to race = 'B';
SQL: SELECT DISTINCT T1.state, T1.chronname FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T2.race = 'B' AND T2.year BETWEEN 2010 AND 2012

Database: book_publishing_company
Question: Name the title with the highest price published by 'Binnet & Hardley'.
Evidence: published by refers to pub_name
SQL: SELECT T1.title FROM titles AS T1 INNER JOIN publishers AS T2 ON T1.pub_id = T2.pub_id WHERE T2.pub_name = 'Binnet & Hardley' ORDER BY T1.price DESC LIMIT 1

Database: sales
Question: How many product ids have the lowest price?
Evidence: lowest price refers to MIN(Price);
SQL: SELECT COUNT(DISTINCT ProductID) FROM Products WHERE Price = ( SELECT MAX(Price) FROM Products )

Database: simpson_episodes
Question: Please list the three episodes with the highest number of votes for the worst star rating.
Evidence: highest number of votes refers to MAX(COUNT(votes)); worst star rating refers to stars = 1
SQL: SELECT T1.title FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T2.stars = ( SELECT MIN(stars) FROM Vote ) ORDER BY T2.votes DESC LIMIT 3;

Database: university
Question: Provide the score of the most populated university in 2011.
Evidence: most populated university refers to MAX(num_students); in 2011 refers to year = 2011;
SQL: SELECT T2.score FROM university_year AS T1 INNER JOIN university_ranking_year AS T2 ON T1.university_id = T2.university_id WHERE T1.year = 2011 ORDER BY T1.num_students DESC LIMIT 1

Database: retail_world
Question: How many condiments were sold in 1997?
Evidence: "Condiments" is the CategoryName; in 1997 refers to year(OrderDate) = 1997;
SQL: SELECT COUNT(T2.ProductID) FROM Categories AS T1 INNER JOIN Products AS T2 ON T1.CategoryID = T2.CategoryID INNER JOIN `Order Details` AS T3 ON T2.ProductID = T3.ProductID INNER JOIN Orders AS T4 ON T3.OrderID = T4.OrderID WHERE T1.CategoryName = 'Condiments' AND T1.CategoryID = 2 AND T4.OrderDate LIKE '1997%'

Database: address
Question: Provide the alias of the city with the highest population in year 2020.
Evidence: the highest population in year 2020 refers to MAX(population_2020);
SQL: SELECT T1.alias FROM alias AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.population_2020 = ( SELECT MAX(population_2020) FROM zip_data )

Database: human_resources
Question: State the name of the city where Jose Rodriguez works.
Evidence: Jose Rodriguez is the fullname of an employee; full name = firstname, lastname; name of city refers to locationcity
SQL: SELECT T2.locationcity FROM employee AS T1  INNER JOIN location AS T2  ON T1.locationID = T2.locationID WHERE T1.firstname = 'Jose' AND T1.lastname = 'Rodriguez'

Database: movie_3
Question: Among the adult films, how many of them have a rental duration of fewer than 4 days?
Evidence: adult film refers to rating = 'NC-17'; rental duration of fewer than 4 days refers to rental_duration < 4
SQL: SELECT COUNT(film_id) FROM film WHERE rating = 'NC-17' AND rental_duration < 4

Database: world_development_indicators
Question: How many of the countries name start with alphabet A? List down the Alpha2Code of them.
Evidence: countries name starts with alphabet A refers to shortname like 'A%';
SQL: SELECT COUNT(ShortName) FROM Country WHERE ShortName LIKE 'A%' UNION SELECT alpha2code FROM country WHERE shortname LIKE 'A%'

Database: regional_sales
Question: Which region is Joshua Bennet located in?
Evidence: "Joshua Bennett" is the name of Sales Team
SQL: SELECT T FROM ( SELECT DISTINCT CASE  WHEN `Sales Team` = 'Joshua Bennett' THEN Region ELSE NULL END AS T FROM `Sales Team` ) WHERE T IS NOT NULL

Database: retails
Question: Among the parts shipped by rail on 1st December, 1995, list part names with 10% discount.
Evidence: shipped by rail on 1st December, 1995 refers to l_shipmode = 'RAIL' where l_shipdate = '1995-12-01'; part names with 10% discount refer to p_name where l_discount = 0.1;
SQL: SELECT T2.p_name FROM partsupp AS T1 INNER JOIN part AS T2 ON T1.ps_partkey = T2.p_partkey INNER JOIN lineitem AS T3 ON T1.ps_partkey = T3.l_partkey WHERE T3.l_discount = 0.1 AND T3.l_shipdate = '1995-12-01' AND T3.l_shipmode = 'RAIL'

Database: computer_student
Question: Which are the courses with the most number of professors? State the course ID and the level of the course.
Evidence: courses refers taughtBy.course_id; most number of professors  refers to max(count(taughtBy.p_id)); level of the course refers to courseLevel
SQL: SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id, T1.courseLevel ORDER BY COUNT(T1.course_id) DESC LIMIT 1

Database: professional_basketball
Question: Among the players from the NBL league, how many of them were born in Spencer?
Evidence: "NBL" is the lgID; 'Spencer' is the birthCity
SQL: SELECT COUNT(DISTINCT T1.playerID) FROM players AS T1 INNER JOIN players_teams AS T2 ON T1.playerID = T2.playerID WHERE T1.birthCity = 'Spencer' AND T2.lgID = 'NBL'

Database: codebase_comments
Question: In the "https://github.com/wallerdev/htmlsharp.git", give all the linearized sequenced of API calls.
Evidence: linearized sequenced of API calls refers to ApiCalls; 'https://github.com/wallerdev/htmlsharp.git' is url of repository
SQL: SELECT T3.ApiCalls FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId INNER JOIN Method AS T3 ON T2.Id = T3.SolutionId WHERE T1.Url = 'https://github.com/wallerdev/htmlsharp.git'

Database: soccer_2016
Question: List the names of players who played as a keeper.
Evidence: played as a keeper refers to Role_Desc = 'Keeper'; name of player refers to Player_Name;
SQL: SELECT T1.Player_Name FROM Player AS T1 INNER JOIN Player_Match AS T2 ON T1.Player_Id = T2.Player_Id INNER JOIN Rolee AS T3 ON T2.Role_Id = T3.Role_Id WHERE T3.Role_Desc = 'Keeper' GROUP BY T1.Player_Name

Database: codebase_comments
Question: Please list the names of methods with the solution path "wallerdev_htmlsharp\HtmlSharp.sln".
Evidence: name of the methods refers to Name; solution path refers to Path; Path = 'wallerdev_htmlsharp\HtmlSharp.sln';
SQL: SELECT T2.Name FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T1.Path = 'wallerdev_htmlsharpHtmlSharp.sln'

Database: movie_platform
Question: Please list the id of the director of the movie "It's Winter".
Evidence: It's Winter' is movie_title;
SQL: SELECT director_id FROM movies WHERE movie_title = 'It''s Winter'

Database: language_corpus
Question: What is the wikipedia page id of Arqueozoologia?
Evidence: page id refers to pid; Arqueozoologia refers to title = 'Arqueozoologia'
SQL: SELECT page FROM pages WHERE title = 'Arqueozoologia'