Database: shipping
Question: Among all shipments delivered by Sue Newel, identify the percentage of shipments that were placed by Autoware Inc.
Evidence: "Autoware Inc" is the cust_name; percentage = Divide (Count(ship_id where cust_name = 'Autoware Inc'), Count(ship_id)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T3.cust_name = 'Autoware Inc' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) AS per FROM shipment AS T1 INNER JOIN driver AS T2 ON T1.driver_id = T2.driver_id INNER JOIN customer AS T3 ON T3.cust_id = T1.cust_id WHERE T2.first_name = 'Sue' AND T2.last_name = 'Newell'

Database: law_episode
Question: What is the average ranking episodes that are nominated for an award?
Evidence: average ranking = divide(sum(rating), sum(episode_id))
SQL: SELECT SUM(T1.rating) / COUNT(T1.episode) FROM Episode AS T1 INNER JOIN Award AS T2 ON T1.episode_id = T2.episode_id

Database: soccer_2016
Question: Which bowling skills did the players from Zimbabwea have?
Evidence: Zimbabwea refers to Country_Name = 'Zimbabwea';
SQL: SELECT T1.Bowling_skill FROM Bowling_Style AS T1 INNER JOIN Player AS T2 ON T1.Bowling_Id = T2.Bowling_skill INNER JOIN Country AS T3 ON T2.Country_Name = T3.Country_Id WHERE T3.Country_Name = 'Zimbabwea'

Database: public_review_platform
Question: Please provide the name of businesses with user id "16328".
Evidence: name of business refers to category_name;
SQL: SELECT T1.category_name FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id INNER JOIN Tips AS T3 ON T2.business_id = T3.business_id WHERE T3.user_id = 16328

Database: chicago_crime
Question: How many crime against society were reported in Englewood?
Evidence: "Englewood" is the community_area_name; 'Society' is the crime_against
SQL: SELECT SUM(CASE WHEN T3.community_area_name = 'Englewood' THEN 1 ELSE 0 END) FROM FBI_Code AS T1 INNER JOIN Crime AS T2 ON T1.fbi_code_no = T2.fbi_code_no INNER JOIN Community_Area AS T3 ON T2.community_area_no = T3.community_area_no WHERE T1.crime_against = 'Society'

Database: movie_3
Question: What is the store and inventory ID of the film with the longest duration?
Evidence: the longest duration refers to MAX(length)
SQL: SELECT T2.store_id, T2.inventory_id FROM film AS T1 INNER JOIN inventory AS T2 ON T1.film_id = T2.film_id ORDER BY T1.length DESC LIMIT 1

Database: simpson_episodes
Question: How many awards classified as "Primetime Emmy" category?
Evidence: category refers to award_category
SQL: SELECT COUNT(award_id) FROM Award WHERE award_category = 'Primetime Emmy';

Database: menu
Question: Among all the menu pages with the appearance of the dish "Clear green turtle", how many of them have the dish at a stable price?
Evidence: Clear green turtle is a name of dish; stable price refers to highest_price is null;
SQL: SELECT SUM(CASE WHEN T1.name = 'Clear green turtle' THEN 1 ELSE 0 END) FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id WHERE T1.highest_price IS NULL

Database: college_completion
Question: In total, how many Hispanic male students graduated from Amridge University?
Evidence: Hispanic refers to race = 'H'; male refers to gender = 'M'; Amridge University refers to chronname = 'Amridge University';
SQL: SELECT SUM(T2.grad_cohort) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T1.unitid = T2.unitid WHERE T1.chronname = 'Amridge University' AND T2.gender = 'M' AND T2.race = 'H'

Database: student_loan
Question: How many unemployed students are enlisted in the navy organization?
Evidence: enlisted in the navy organization refers to organ = 'navy';
SQL: SELECT COUNT(T1.name) FROM unemployed AS T1 INNER JOIN enlist AS T2 ON T1.name = T2.name WHERE T2.organ = 'navy'

Database: simpson_episodes
Question: What is the birth place of the cast or crew member who won the Best Voice-Over Performance in Online Film & Television Association in 2009?
Evidence: won refers to result = 'Winner'; 'Best Voice-Over Performance' is the award; ' Online Film & Television Association' is the organization; in 2009 refers to year = 2009
SQL: SELECT T1.birth_place FROM Person AS T1 INNER JOIN Award AS T2 ON T1.name = T2.person WHERE T2.award = 'Best Voice-Over Performance' AND T2.organization = 'Online Film & Television Association' AND T2.year = 2009;

Database: codebase_comments
Question: How many percent more of the Forks for the repository of solution No.53546 than No.1502?
Evidence: solution No. refers to Solution.Id; percentage = DIVIDE(MULTIPLY(SUBTRACT(SUM(Solution.Id = 53546), SUM(Solution.Id = 1502)), 100)), SUM(Solution.Id = 1502);
SQL: SELECT CAST(SUM(CASE WHEN T2.Id = 53546 THEN T1.Forks ELSE 0 END) - SUM(CASE WHEN T2.Id = 1502 THEN T1.Forks ELSE 0 END) AS REAL) * 100 / SUM(CASE WHEN T2.Id = 1502 THEN T1.Forks ELSE 0 END) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId

Database: european_football_1
Question: Which team won the match in the EC division on January 20, 2008 at home?
Evidence: won at home refers to FTR = 'H'; January 20, 2008 refers to Date = '2008-01-20'; EC division refers to Div = 'EC';
SQL: SELECT HomeTeam FROM matchs WHERE Div = 'EC' AND Date = '2008-01-20' AND FTR = 'H'

Database: ice_hockey_draft
Question: What is the weight in pounds of the heaviest player?
Evidence: weight in pounds refers to weight_in_lbs; heaviest player refers to MAX(weight_in_lbs);
SQL: SELECT MAX(T2.weight_in_lbs) FROM PlayerInfo AS T1 INNER JOIN weight_info AS T2 ON T1.weight = T2.weight_id

Database: language_corpus
Question: What is the locale of the language of the page titled "Abril"?
Evidence: the page titled "Abril" refers to title = 'Abril';
SQL: SELECT T1.locale FROM langs AS T1 INNER JOIN pages AS T2 ON T1.lid = T2.lid WHERE T2.title = 'Abril'

Database: retail_world
Question: Mention the oldest empoyee's full name, title, salary and number of orders which were shipped to USA by him.
Evidence: full name refers to FirstName, LastName; shipped to USA refers to ShipCountry = 'USA'
SQL: SELECT T1.FirstName, T1.LastName, T1.Title, T1.Salary , COUNT(T2.OrderID) FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE ShipCountry = 'USA' GROUP BY T1.FirstName, T1.LastName, T1.Title, T1.Salary, T1.BirthDate ORDER BY T1.BirthDate LIMIT 1

Database: student_loan
Question: What is the employment, disability, gender and school debt status for student180 and student117?
Evidence: school debt status refers to bool; bool = 'pos' means has payment due; bool = 'neg' means doesn't has payment due; student appear in male.name means he is a male; student does not appear in male.name means she is a female;
SQL: SELECT ( SELECT COUNT(name) FROM disabled WHERE name IN ('student180', 'student117') ), ( SELECT COUNT(name) FROM unemployed WHERE name IN ('student180', 'student117') ), ( SELECT COUNT(name) FROM male WHERE name IN ('student180', 'student117') ), ( SELECT COUNT(name) FROM no_payment_due WHERE name IN ('student180', 'student117'))

Database: sales_in_weather
Question: List out stations number and items sold by store 17.
Evidence: station number refers to station_nbr; store 17 refers to store_nbr = 17
SQL: SELECT T1.station_nbr, T2.item_nbr FROM relation AS T1 INNER JOIN sales_in_weather AS T2 ON T1.store_nbr = T2.store_nbr WHERE T1.store_nbr = 17 GROUP BY T1.station_nbr, T2.item_nbr

Database: chicago_crime
Question: Please list all of the contact information for the police district Near West.
Evidence: "Near West" is the district_name; all contact information refers to phone, fax, tty, twitter
SQL: SELECT phone, fax, tty, twitter FROM District WHERE district_name = 'Near West'