Database: ice_hockey_draft
Question: Among all players drafted by the Toronto Maple Leafs, identify the percentage who are from Eastern Europe.
Evidence: players refers to PlayerName; drafted by the Toronto Maple Leafs refers to overallby = 'Toronto Maple Leafs'; percentage = MULTIPLY(DIVIDE(SUM(nation = 'Eastern Europe'), COUNT(ELITEID) WHERE overallby = 'Toronto Maple Leafs'), 100); from Eastern Europe refers to nation in ('Belarus', 'Bulgaria', 'Czech Republic', 'Hungary', 'Moldova', 'Poland', 'Romania', 'Slovakia', 'Ukraine'); countries in a continent can be identified by referring to https://worldpopulationreview.com/country-rankings/list-of-countries-by-continent;
SQL: SELECT CAST(COUNT(CASE WHEN nation IN ('Belarus', 'Czech Rep.', 'Slovakia', 'Ukraine') THEN ELITEID ELSE NULL END) AS REAL) * 100 / COUNT(ELITEID) FROM PlayerInfo WHERE overallby = 'Toronto Maple Leafs'

Database: talkingdata
Question: List the included categories in the event ID of 155.
SQL: SELECT DISTINCT T1.category FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T2.label_id = T1.label_id INNER JOIN app_events AS T3 ON T3.app_id = T2.app_id WHERE T3.event_id = 155

Database: legislator
Question: How many times did Richard Durbin become a legislator in district 20?
Evidence: Richard Durbin is an official_full_name;  official_full_name refers to first_name, last_name; district 20 refers to district = 20
SQL: SELECT SUM(CASE WHEN T2.district = 20 THEN 1 ELSE 0 END) AS count FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.first_name = 'Richard' AND T1.last_name = 'Durbin'

Database: legislator
Question: List the full names, religions, and parties of legislators who have served in Maine.
Evidence: full names refers to official_full_name; religion refers to religion_bio; Maine refers to state = "ME"
SQL: SELECT T1.official_full_name, T2.relation, T2.party FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.state = 'ME' GROUP BY T1.official_full_name, T2.relation, T2.party

Database: university
Question: What is the name of the university that has the lowest number of students of all time?
Evidence: has the lowest number of students refers to min(num_students); name of the university refers to university_name
SQL: SELECT T2.university_name FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id ORDER BY T1.num_students LIMIT 1

Database: retail_world
Question: What is the title of the employee who handled order id 10270?
SQL: SELECT T1.Title FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T2.OrderID = 10257

Database: beer_factory
Question: How many bottles of beer have been bought by Jim Breech?
Evidence: bottles refers to ContainerType = 'Bottle';
SQL: SELECT COUNT(T3.ContainerType) FROM customers AS T1 INNER JOIN `transaction` AS T2 ON T2.CustomerID = T1.CustomerID INNER JOIN rootbeer AS T3 ON T3.RootBeerID = T2.RootBeerID WHERE T3.ContainerType = 'Bottle' AND T1.First = 'Jim' AND T1.Last = 'Breech'

Database: superstore
Question: Please give the name of customers from the West region that bought exactly 8 items in their purchase.
Evidence: name of customers refers to "Customer Name"; bought exactly 8 items refers to Quantity = 8
SQL: SELECT DISTINCT T2.`Customer Name` FROM west_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T1.Quantity = 8 AND T1.Region = 'West'

Database: food_inspection
Question: How many eateries got highest inspection in 2013?
Evidence: eateries got highest inspection score in 2013 refer to business_id from inspections where score = 100 and year(date) = 2013;
SQL: SELECT COUNT(DISTINCT business_id) FROM inspections WHERE STRFTIME('%Y', `date`) = '2013' AND score = ( SELECT MAX(score) FROM inspections WHERE STRFTIME('%Y', `date`) = '2013' )

Database: public_review_platform
Question: Please indicate the opening day of businesses whose category is pets.
Evidence: category is pets refers to category_name = 'Pets'; opening day refers to day_id from Business_Hours and opening_time;
SQL: SELECT DISTINCT T4.day_of_week FROM Business_Categories AS T1 INNER JOIN Categories AS T2 ON T1.category_id = T2.category_id INNER JOIN Business_Hours AS T3 ON T1.business_id = T3.business_id INNER JOIN Days AS T4 ON T3.day_id = T4.day_id WHERE T2.category_name = 'Pets'

Database: codebase_comments
Question: In "maxild_playground\Playground.sln", what is the time of sampling for the method "GitHubRepo.Cli.GitHubClientWrapper.GetReleases"?
Evidence: the time of sampling refers to SampledAt; 'maxild_playground\Playground.sln' is the path of a solution
SQL: SELECT T2.SampledAt FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T1.Path = 'maxild_playgroundPlayground.sln' AND T2.Name = 'GitHubRepo.Cli.GitHubClientWrapper.GetReleases'

Database: authors
Question: What is the title of the paper published in 2003 by an author with affiliation with Department of Network Science, Graduate School of Information Systems, The University of Electro-Communications?
Evidence: published in 2003 refers to Year = 2003; 'Department of Network Science, Graduate School of Information Systems, The University of Electro-Communications' is the Affiliation organization
SQL: SELECT DISTINCT T2.Title FROM PaperAuthor AS T1 INNER JOIN Paper AS T2 ON T1.PaperId = T2.Id WHERE T1.Affiliation = 'Department of Network Science, Graduate School of Information Systems, The University of Electro-Communications' AND T2.Year = 2003

Database: movie_3
Question: How many films have a rental rate of 0.99?
SQL: SELECT COUNT(film_id) FROM film WHERE rental_rate = 0.99

Database: address
Question: Which state is Outagamie County in? Give the full name of the state.
Evidence: "OUTAGAMIE" is the county
SQL: SELECT DISTINCT T2.name FROM country AS T1 INNER JOIN state AS T2 ON T1.state = T2.abbreviation WHERE T1.county = 'OUTAGAMIE'

Database: olympics
Question: What is the name of medal that competitor id 9 obtained?
Evidence: name of medal refers to medal_name;
SQL: SELECT DISTINCT T1.medal_name FROM medal AS T1 INNER JOIN competitor_event AS T2 ON T1.id = T2.medal_id WHERE T2.competitor_id = 9

Database: law_episode
Question: List the titles and air dates of episodes that were produced by Billy Fox.
Evidence: produced refers to role = 'producer'
SQL: SELECT T1.title, T1.air_date FROM Episode AS T1 INNER JOIN Credit AS T2 ON T1.episode_id = T2.episode_id INNER JOIN Person AS T3 ON T3.person_id = T2.person_id WHERE T2.category = 'Produced by' AND T2.role = 'producer' AND T3.name = 'Billy Fox'

Database: food_inspection
Question: How many foodborne illness investigations were done in 2014?
Evidence: foodborne illness investigations refer to inspections where type = 'Foodborne Illness Investigation'; investigations in 2014 refers to date between '2014-01-01' and '2014-12-31';
SQL: SELECT COUNT(business_id) FROM inspections WHERE STRFTIME('%Y', `date`) = '2014' AND type = 'Foodborne Illness Investigation'

Database: regional_sales
Question: State the delivery date of cookware.
Evidence: Cookware is the name of the product;
SQL: SELECT T FROM ( SELECT DISTINCT IIF(T2.`Product Name` = 'Cookware', T1.DeliveryDate, NULL) AS T FROM `Sales Orders` T1 INNER JOIN Products T2 ON T2.ProductID = T1._ProductID ) WHERE T IS NOT NULL

Database: sales
Question: How many customer ids have purchased Hex Nut 9?
Evidence: Hex Nut 9' is name of product;
SQL: SELECT COUNT(T1.CustomerID) FROM Sales AS T1 INNER JOIN Products AS T2 ON T1.ProductID = T2.ProductID WHERE T2.Name = 'Hex Nut 9'