Database: soccer_2016
Question: Write the name of the player who was the man of the series more than one time.
Evidence: name of the player refers to Player_Name; man of the series more than one time refers to count(Man_of_the_Series) > 1
SQL: SELECT T2.Player_Name FROM Season AS T1 INNER JOIN Player AS T2 ON T1.Man_of_the_Series = T2.Player_Id WHERE T1.Man_of_the_Series > 1

Database: airline
Question: What is the name of the airline with the highest number of non-cancelled flights?
Evidence: names of the airlines refers to Description; highest number of non-cancelled flights refers to MAX(COUNT(CANCELLED = 0));
SQL: SELECT T2.Description FROM Airlines AS T1 INNER JOIN `Air Carriers` AS T2 ON T1.OP_CARRIER_AIRLINE_ID = T2.Code WHERE T1.CANCELLED = 0 GROUP BY T2.Description ORDER BY COUNT(T1.CANCELLED) DESC LIMIT 1

Database: food_inspection_2
Question: What is the establishment's name with an inspection category of No Smoking Regulations?
Evidence: establishment's name refers to dba_name; an inspection category of No Smoking Regulations refers to category = 'No Smoking Regulations'
SQL: SELECT DISTINCT T1.dba_name FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no INNER JOIN violation AS T3 ON T2.inspection_id = T3.inspection_id INNER JOIN inspection_point AS T4 ON T3.point_id = T4.point_id WHERE T4.category = 'No Smoking Regulations'

Database: retail_world
Question: Of all the shipments made by United Package throughout the year 1996, what percentage correspond to the month of September?
Evidence: DIVIDE(COUNT(OrderID where CompanyName = 'United Package' and ShippedDate > = '1996-09-01 00:00:00' AND ShippedDate < '1996-09-30 00:00:00')), (COUNT(OrderID where CompanyName = 'United Package' and ShippedDate > = '1996-01-01 00:00:00' AND ShippedDate < '1997-01-01 00:00:00')) as percentage; 

SQL: SELECT CAST(COUNT(CASE WHEN T1.ShippedDate LIKE '1996-09%' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.ShipVia) FROM Orders AS T1 INNER JOIN Shippers AS T2 ON T1.ShipVia = T2.ShipperID WHERE T2.CompanyName = 'United Package' AND T1.ShippedDate LIKE '1996%'

Database: olympics
Question: What is the ratio male to female athletes in the 2012 Summer Olympic?
Evidence: DIVIDE(COUNT(gender = 'M'), COUNT(gender = 'F')) where games_name = '2012 Summer';
SQL: SELECT CAST(COUNT(CASE WHEN T3.gender = 'M' THEN 1 ELSE NULL END) AS REAL) / COUNT(CASE WHEN T3.gender = 'F' THEN 1 ELSE NULL END) 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'

Database: computer_student
Question: What is the position in the faculty of the professor who teaches the highest number of courses?
Evidence: position in the faculty refers to hasPosition; professor refers to professor = 1; teaches the highest number of courses refers to max(count(taughtBy.course_id))
SQL: SELECT T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 GROUP BY T1.p_id ORDER BY COUNT(T2.course_id) DESC LIMIT 1

Database: public_review_platform
Question: What is the review length of user 35026 to business with business ID 2?
Evidence: user 35026 refers to user_id = 35026
SQL: SELECT review_length FROM Reviews WHERE user_id = 35026 AND business_id = 2

Database: language_corpus
Question: What is the total number of words in page containing pair of word id "100" and "317"?
Evidence: Pair is a relationship of two words: w1st and w2nd, where w1st is word id of the first word and w2nd is a word id of the second word; w1st = 100; w2nd = 317;
SQL: SELECT words FROM langs WHERE lid = ( SELECT lid FROM biwords WHERE w1st = 100 AND w2nd = 317 )

Database: public_review_platform
Question: Mention the number of businesses that have no any attribute.
Evidence: have no attribute refers to attribute_value in( 'none', 'no', 'false')
SQL: SELECT COUNT(business_id) FROM Business_Attributes WHERE attribute_value IN ('none', 'no', 'false')

Database: movie_3
Question: What percentage of the movies are PG-13?
Evidence: PG-13 is a rating; calculation = DIVIDE(SUM(rating = PG-13), SUM(rating)) * 100
SQL: SELECT CAST(SUM(IIF(rating = 'PG-13', 1, 0)) AS REAL) * 100 / COUNT(film_id) FROM film

Database: retails
Question: Which market segment does the customer with the highest amount of debt belongs to?
Evidence: market segment refers to c_mktsegment; the highest amount of debt refers to max(c_acctbal)
SQL: SELECT c_mktsegment FROM customer WHERE c_acctbal = ( SELECT MIN(c_acctbal) FROM customer )

Database: olympics
Question: Give the height of the tallest athlete from Portugal.
Evidence: the tallest athlete refers to id where MAX(height); from Portugal refers to region_name = 'Portugal';
SQL: SELECT T3.height FROM noc_region AS T1 INNER JOIN person_region AS T2 ON T1.id = T2.region_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T1.region_name = 'Portugal' ORDER BY T3.height DESC LIMIT 1

Database: food_inspection
Question: For the business which got the most number of violations, how many inspections did it have?
SQL: SELECT COUNT(T2.business_id) FROM violations AS T1 INNER JOIN inspections AS T2 ON T1.business_id = T2.business_id GROUP BY T1.business_id ORDER BY COUNT(T1.business_id) DESC LIMIT 1

Database: retails
Question: What is the supply cost for the part "violet olive rose ivory sandy"?
Evidence: supply cost refers to ps_supplycost; part "violet olive rose ivory sandy" refers to p_name = 'violet olive rose ivory sandy'
SQL: SELECT T2.ps_supplycost FROM part AS T1 INNER JOIN partsupp AS T2 ON T1.p_partkey = T2.ps_partkey WHERE T1.p_name = 'violet olive rose ivory sandy'

Database: app_store
Question: What percentage of no comment reviews are from "Teen" content rating apps?
Evidence: no comment refers to Translated_Review = 'nan'; percentage = DIVIDE((SUM(Content Rating = 'Teen')), COUNT(*));
SQL: SELECT CAST(COUNT(CASE WHEN T1.`Content Rating` = 'Teen' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.App) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Translated_Review = 'nan'

Database: synthea
Question: What is the code of the prevalent disease with the highest occurrences?
SQL: SELECT T2.code FROM all_prevalences AS T1 INNER JOIN conditions AS T2 ON T1.ITEM = T2.DESCRIPTION ORDER BY T1.OCCURRENCES DESC LIMIT 1

Database: student_loan
Question: How many students are filed for bankruptcy?
SQL: SELECT COUNT(name) FROM filed_for_bankrupcy

Database: language_corpus
Question: How many times on page number 16 does the second word in the pair of words 1 and 109 appear?
Evidence: How many times appear refer to occurrences; page number 16 refers to pid = 16; Pair is a relationship of two words: w1st and w2nd, where w1st is word id of the first word and w2nd is a word id of the second word; w1st = 1; w2nd = 109;
SQL: SELECT SUM(T1.occurrences) FROM pages_words AS T1 INNER JOIN biwords AS T2 ON T2.w2nd = T1.wid WHERE T2.w2nd = 109 AND T2.w1st = 1 AND T1.pid = 16

Database: legislator
Question: Give the type and start date of the term of the legislator born on November 26, 1727.
Evidence: start date of the term refers to start; born on November 26, 1727 refers to birthday_bio = '1727-11-26';
SQL: SELECT T2.type, T2.start FROM historical AS T1 INNER JOIN `historical-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.birthday_bio = '1727-11-26'

Database: sales
Question: What is the full name of employee who sold 1000 units?
Evidence: full name of employee = FirstName, MiddleInitial, LastName; units refers to quantity; Quantity = 100
SQL: SELECT DISTINCT T2.FirstName, T2.MiddleInitial, T2.LastName FROM Sales AS T1 INNER JOIN Employees AS T2 ON T1.SalesPersonID = T2.EmployeeID WHERE T1.Quantity = 1000