Database: retail_world
Question: What is the contact name for product Teatime Chocolate Biscuits?
Evidence: "Teatime Chocolate Biscuits" is the ProductName
SQL: SELECT T2.ContactName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.ProductName = 'Teatime Chocolate Biscuits'

Database: retails
Question: Which nation does the supplier with the account balance of "4393.04" belong to?
Evidence: nation refers to n_name; account balance of "4393.04" refers to s_acctbal = 4393.04
SQL: SELECT T2.n_name FROM supplier AS T1 INNER JOIN nation AS T2 ON T1.s_nationkey = T2.n_nationkey WHERE T1.s_acctbal = 4393.04

Database: authors
Question: Which author of the paper "Incremental Extraction of Keyterms for Classifying Multilingual Documents in the Web" is affiliated with National Taiwan University Department of Computer Science and Information Engineering Taiwan?
Evidence: "Incremental Extraction of Keyterms for Classifying Multilingual Documents in the Web" is the title of paper; affiliated with refers to Affiliation; "National Taiwan University Department of Computer Science and Information Engineering Taiwan" is the Affiliation organization
SQL: SELECT T1.Name FROM PaperAuthor AS T1 INNER JOIN Paper AS T2 ON T1.PaperId = T2.Id WHERE T2.Title = 'Incremental Extraction of Keyterms for Classifying Multilingual Documents in the Web' AND T1.Affiliation = 'National Taiwan University Department of Computer Science and Information Engineering Taiwan'

Database: bike_share_1
Question: List out all end stations for a bicycle that were making a trip starting from 2nd at South Park station? Only retain the unique value.
Evidence: end station refers to end_station_name; starting from refers to start_station_name; start_station_name = '2nd at South Park';
SQL: SELECT DISTINCT end_station_name FROM trip WHERE start_station_name = '2nd at South Park'

Database: retails
Question: When was the order with the highest amount of total price shipped?
Evidence: when shipped refers to l_shipdate; the highest amount of total price refers to MAX(o_totalprice);
SQL: SELECT T2.l_shipdate FROM orders AS T1 INNER JOIN lineitem AS T2 ON T1.o_orderkey = T2.l_orderkey ORDER BY T1.o_totalprice DESC LIMIT 1

Database: olympics
Question: What is the percentage of the people who are under 35 and participated in the summer season?
Evidence: DIVIDE(COUNT(age < 35) / COUNT(person_id)) as percentage where season = 'Summer';
SQL: SELECT CAST(COUNT(CASE WHEN T2.age < 35 THEN 1 END) AS REAL) * 100 / COUNT(T2.games_id) FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id WHERE T1.season = 'Summer'

Database: human_resources
Question: What are the maximum and minimum salary range and position title of Bill Marlin?
Evidence: Bill Marlin is the full name of an employee; full name = firstname, lastname; maximum salary refers to maxsalary; minimum salary refers to minsalary
SQL: SELECT T2.maxsalary, T2.minsalary, T2.positiontitle FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T1.firstname = 'Bill' AND T1.lastname = 'Marlin'

Database: retails
Question: How many suppliers from Egypt have a debit balance?
Evidence: suppliers refer to s_suppkey; Egypt is the name of the nation which refers to n_name = 'EGYPT'; the balance is in debt if s_acctbal < 0;
SQL: SELECT COUNT(T1.s_suppkey) FROM supplier AS T1 INNER JOIN nation AS T2 ON T1.s_nationkey = T2.n_nationkey WHERE T1.s_acctbal < 0 AND T2.n_name = 'EGYPT'

Database: authors
Question: List the short name of all conferences whose full name begins with International Symposium.
Evidence: full name refers to FullName LIKE 'International Symposium%'
SQL: SELECT ShortName FROM Conference WHERE FullName LIKE 'International Symposium%'

Database: public_review_platform
Question: Sum up the number of business with "ambience_romantic" attribute.
Evidence: "ambience_romantic" attribute refers to attribute_name = 'ambience_romantic' AND attribute_value = 'true'
SQL: SELECT COUNT(T2.business_id) FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T1.attribute_name = 'ambience_romantic' AND T2.attribute_value = 'true'

Database: public_review_platform
Question: How many businesses in the AZ state got low quality of reviews?
Evidence: low quality of reviews refers to review_count = 'low';
SQL: SELECT COUNT(business_id) FROM Business WHERE state LIKE 'AZ' AND review_count LIKE 'Low'

Database: retail_world
Question: Provide the category name of the Chef Anton's Gumbo Mix product that New Orleans Cajun Delights company has.
Evidence: 'Chef Anton's Gumbo Mix' is a ProductName; 'New Orleans Cajun Delights' is a CompanyName;
SQL: SELECT T3.CategoryName FROM Suppliers AS T1 INNER JOIN Products AS T2 ON T1.SupplierID = T2.SupplierID INNER JOIN Categories AS T3 ON T2.CategoryID = T3.CategoryID WHERE T1.CompanyName = 'New Orleans Cajun Delights' AND T2.ProductName LIKE 'Chef Anton%s Gumbo Mix'

Database: world_development_indicators
Question: What is the ratio between country with the highest number of infant deaths in 1971 and the lowest number of infant deaths in 1971? List the country with the highest number of infant deaths in 1971 and the lowest number of infant deaths in 1971.
Evidence: ratio = divide(max(value where indicatorname = 'Number of infant deaths' and year = '1971'), min(value where indicatorname = 'Number of infant deaths' and year = '1971')); the highest number of infant deaths in 1971 refers to max(value where indicatorname = 'Number of infant deaths' and year = '1971'); the lowest number of infant deaths in 1971 refers to min(value where indicatorname = 'Number of infant deaths' and year = '1971')
SQL: SELECT CAST(MAX(value) AS REAL) / MIN(value) FROM indicators WHERE indicatorname = 'Number of infant deaths' AND year = '1971' UNION ALL SELECT countryname FROM ( SELECT countryname, MAX(value) FROM indicators WHERE indicatorname = 'Number of infant deaths' AND year = '1971' ) UNION SELECT countryname FROM ( SELECT countryname, MIN(value) FROM indicators WHERE indicatorname = 'Number of infant deaths' AND year = '1971' )

Database: video_games
Question: When was the game ID 156 released?
Evidence: when the game was released refers to release_year;
SQL: SELECT T1.release_year FROM game_platform AS T1 INNER JOIN game_publisher AS T2 ON T1.game_publisher_id = T2.id WHERE T2.game_id = 156

Database: video_games
Question: Which publisher has published the most number of Action games?
Evidence: which publisher refers to publisher_name; publisher that has published the most number of Action games refers to MAX(COUNT(publisher_name)) WHERE genre_name = 'Action'; Action games refers to game_name WHERE genre_name = 'Action';
SQL: SELECT T.publisher_name FROM ( SELECT T4.publisher_name, COUNT(DISTINCT T2.id) FROM genre AS T1 INNER JOIN game AS T2 ON T1.id = T2.genre_id INNER JOIN game_publisher AS T3 ON T2.id = T3.game_id INNER JOIN publisher AS T4 ON T3.publisher_id = T4.id WHERE T1.genre_name = 'Action' GROUP BY T4.publisher_name ORDER BY COUNT(DISTINCT T2.id) DESC LIMIT 1 ) t

Database: soccer_2016
Question: Which player became the man of the series in the year 2012? Give the name and country of this player.
Evidence: year 2012 refers to Season_Year = 2012; name of player refers to Player_Name.; country of this player refers to Country_Name
SQL: SELECT T2.Player_Name, T3.Country_Name FROM Season AS T1 INNER JOIN Player AS T2 ON T1.Man_of_the_Series = T2.Player_Id INNER JOIN Country AS T3 ON T2.Country_Name = T3.Country_Id WHERE T1.Season_Year = 2012