Database: cars
Question: What years did the Buick Skylark 320 get in production?
Evidence: year refers to model_year; Buick Skylark 320 refers to car_name = 'buick skylark 320'
SQL: SELECT T2.model_year FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID WHERE T1.car_name = 'buick skylark 320'

Database: sales
Question: What is the last name of the customer who placed an order for sales id 178?
SQL: SELECT T1.LastName FROM Customers AS T1 INNER JOIN Sales AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.SalesID = 178

Database: student_loan
Question: State name of students who have been absent for 5 months from school and do not have payment due.
Evidence: absent for 5 months refers to month = 5; do not have payment due refers to bool = 'neg';
SQL: SELECT T1.name FROM longest_absense_from_school AS T1 INNER JOIN no_payment_due AS T2 ON T1.name = T2.name WHERE T1.month = 5 AND T2.bool = 'neg'

Database: professional_basketball
Question: How many total minutes has the Brooklyn-born player, known by the name of Superman, played during all of his NBA All-Star seasons?
Evidence: "Brooklyn" is the birthCity of player; known by the name of Superman refers to nameNick like '%Superman%'; total minutes refers to Sum(minutes)
SQL: SELECT SUM(T2.minutes) FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE T1.birthCity = 'Brooklyn' AND T1.nameNick LIKE '%Superman%'

Database: world
Question: List down the districts belong to the country headed by Adolf Ogi.
Evidence: headed by Adolf Ogi refers to HeadOfState = 'Adolf Ogi';
SQL: SELECT T2.District FROM Country AS T1 INNER JOIN City AS T2 ON T1.Code = T2.CountryCode WHERE T1.HeadOfState = 'Adolf Ogi'

Database: public_review_platform
Question: In which categories does the only business located in the city of Arcadia appear?
Evidence: categories 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 Business AS T3 ON T2.business_id = T3.business_id WHERE T3.city = 'Arcadia'

Database: sales_in_weather
Question: Tell the resultant wind speed of station no.9 on 2014/1/15.
Evidence: station no.9 refers to station_nbr = 9; on 2014/1/15 refers to date = '2014/01/15'; result wind speed refers to resultspeed
SQL: SELECT resultspeed FROM weather WHERE `date` = '2014-01-15' AND station_nbr = 9

Database: image_and_language
Question: What is the percentage of the object samples in the class of "man" in image no.1?
Evidence: object samples refers to OBJ_SAMPLE_ID; class of "man" refers to OBJ_CLASS = 'man'; image no.1 refers to IMG_ID = 1; percentage = divide(count(OBJ_SAMPLE_ID)when OBJ_CLASS = 'man', count(OBJ_SAMPLE_ID)) as percentage
SQL: SELECT CAST(COUNT(CASE WHEN T1.OBJ_CLASS = 'man' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.OBJ_CLASS_ID) FROM OBJ_CLASSES AS T1 INNER JOIN IMG_OBJ AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.IMG_ID = 1

Database: european_football_1
Question: Which division had the most games with more than 5 total field goals on 2020/2/22? Give the full name of the division?
Evidence: more than 5 total field goals refers to SUM(FTHG, FTAG)>5, which are short names for Final-time Home-team Goals and Final-time Away-team Goals; 2020/2/22 is a date;
SQL: SELECT T2.division, T2.name FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T1.Date = '2020-02-22' AND T1.FTAG + T1.FTHG > 5 ORDER BY T1.FTAG + T1.FTHG DESC LIMIT 1

Database: talkingdata
Question: List out the time of the event id 12.
Evidence: time refers to timestamp;
SQL: SELECT timestamp FROM events WHERE event_id = 12

Database: ice_hockey_draft
Question: Name the player who scored the most goals in a single game in the 2007-2008 season of WHL?
Evidence: name of the player refers to PlayerName; scored the most goals in a single game refers to MAX(G); WHL refers to LEAGUE = 'WHL'; 2007-2008 season refers to SEASON = '2007-2008';
SQL: SELECT T2.PlayerName FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.SEASON = '2007-2008' AND T1.LEAGUE = 'WHL' ORDER BY T1.G DESC LIMIT 1

Database: movie_platform
Question: How many users have more than 100 followers in the list created by users in 2009?
Evidence: more than 100 followers refers to list_followers >100;  list created by the user in 2009 refers to list_creation_date_utc = '2009';
SQL: SELECT COUNT(T1.user_id) FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.list_id = T2.list_id WHERE T2.list_followers > 100 AND T1.list_creation_date_utc LIKE '2009%'

Database: professional_basketball
Question: Name the youngest player who ever won "Rookie of the Year".
Evidence: player name refers to playerID; the youngest refers to max(birthDate); won "Rookie of the Year" refers to award = 'Rookie of the Year'
SQL: SELECT T1.firstName, T1.middleName, T1.lastName FROM players AS T1 INNER JOIN awards_players AS T2 ON T1.playerID = T2.playerID WHERE T2.award = 'Rookie of the Year' ORDER BY T1.birthDate DESC LIMIT 1

Database: superstore
Question: List the products that were ordered by Anne McFarland from the Western store.
Evidence: Anne McFarland' is the "Customer Name"; Western store refers to west_superstore; products refers to "Product Name"
SQL: SELECT DISTINCT T3.`Product Name` FROM west_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T1.`Product ID` WHERE T2.`Customer Name` = 'Anne McFarland'

Database: talkingdata
Question: Calculate the ratio in percentage between the average number of app users belonging to "80s Japanese comic" and "90s Japanese comic".
Evidence: ratio in percentage = DIVIDE(SUM(IF(category = '80s Japanese comic',1,0)), COUNT(app_id)) as '80s'; DIVIDE(SUM(IF(category = '90s Japanese comic',1,0)), COUNT(app_id)) as '90s'; 80s Japanese comic refers to category = '80s Japanese comic'; 90s Japanese comic refers to category = '80s Japanese comic';
SQL: SELECT SUM(IIF(T1.category = '80s Japanese comic', 1, 0)) / COUNT(T1.label_id) AS J8 , SUM(IIF(T1.category = '90s Japanese comic', 1, 0)) / COUNT(T1.label_id) AS J9 FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T1.label_id = T2.label_id

Database: retail_world
Question: How many orders were handled by Michael Suyama. State the order ID.
SQL: SELECT COUNT(T2.OrderID) FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T1.FirstName = 'Michael' AND T1.LastName = 'Suyama'

Database: shakespeare
Question: In Act 1 Scene 2 of the Twelfth Night, what is the total number of of lines said by Viola?
Evidence: Twelfth Night refers to Title = 'Twelfth Night'; total number of lines said by Viola refers to count(character_id) where CharName = 'Viola'
SQL: SELECT COUNT(T4.id) FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id INNER JOIN paragraphs AS T3 ON T2.id = T3.chapter_id INNER JOIN characters AS T4 ON T3.character_id = T4.id WHERE T2.Act = 1 AND T2.Scene = 2 AND T4.id = 1238 AND T4.CharName = 'Viola' AND T1.Title = 'Twelfth Night'

Database: law_episode
Question: In which organization did Constantine Makris win the most awards?
Evidence: win refers to result = 'Winner'; the most awards refers to max(count(award_id))
SQL: SELECT T2.organization FROM Person AS T1 INNER JOIN Award AS T2 ON T1.person_id = T2.person_id WHERE T1.name = 'Constantine Makris' AND T2.result = 'Winner' GROUP BY T2.organization ORDER BY COUNT(T2.award_id) DESC LIMIT 1