Database: university
Question: For Chosun University, what was its score on "Influence Rank" in 2015?
Evidence: Chosun University refers to university_name = 'Chosun University'; in 2015 refers to year = 2015; on "Influence Rank" refers to criteria_name = 'Influence Rank';
SQL: SELECT T2.score FROM ranking_criteria AS T1 INNER JOIN university_ranking_year AS T2 ON T1.id = T2.ranking_criteria_id INNER JOIN university AS T3 ON T3.id = T2.university_id WHERE T3.university_name = 'Chosun University' AND T1.criteria_name = 'Influence Rank' AND T2.year = 2015

Database: professional_basketball
Question: Please list the coach IDs who received the award twice from 1970 to 1990.
Evidence: from 1970 to 1990 refers to year between 1970 and 1990;  received award twice refers to coachID where Count(coachID) = 2
SQL: SELECT coachID FROM awards_coaches WHERE year BETWEEN 1970 AND 1990 GROUP BY coachID, award HAVING COUNT(award) = 2

Database: student_loan
Question: How many female students have enlisted for the Army?
Evidence: female students refers to enlist.name who are NOT in male.name; Army refers to organ = 'army';
SQL: SELECT SUM(IIF(T3.name IS NULL, 1, 0)) AS "result" FROM enlist AS T1 INNER JOIN person AS T2 ON T1.name = T2.name LEFT JOIN male AS T3 ON T2.name = T3.name WHERE T1.organ = 'army'

Database: student_loan
Question: Which students that are in the marines have been absent for 6 months?
Evidence: in the marines refers to organ = 'marines'; absent for 6 months refers to month = 6
SQL: SELECT T1.name FROM longest_absense_from_school AS T1 INNER JOIN enlist AS T2 ON T1.`name` = T2.`name` WHERE T2.organ = 'marines' AND T1.`month` = 6

Database: law_episode
Question: Please list the titles of all the episodes in which Park Dietz was credited.
Evidence: credited refers to credited = 'true'
SQL: SELECT T1.title 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.credited = 'true' AND T3.name = 'Park Dietz'

Database: cars
Question: How many cars worth greater than 40000 were from the USA?
Evidence: worth greater than 40000 refers to price > 40000; from the USA refers to country = 'USA'
SQL: SELECT COUNT(*) FROM price AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country WHERE T3.country = 'USA' AND T1.price > 40000

Database: public_review_platform
Question: In businesses with a category of food, how many of them have a star rating below 3?
Evidence: category of food refers to category_name = 'Food'; star rating below 3 refers to stars < 3
SQL: SELECT COUNT(DISTINCT T1.business_id) FROM Business AS T1 INNER JOIN Business_Categories AS T2 ON T1.business_id = T2.business_id INNER JOIN Categories AS T3 ON T2.category_id = T3.category_id WHERE T3.category_name = 'Food' AND T1.stars < 3

Database: simpson_episodes
Question: List the name of all awards along with the award category, nominated by Marc Wilmore.
Evidence: "Marc Wilmore" is the name of person
SQL: SELECT award_id, award_category FROM Award WHERE person = 'Marc Wilmore';

Database: shakespeare
Question: What is the description of Act 1, Scene 2 in Twelfth Night?
Evidence: Twelfth Night refers to Title = 'Twelfth Night'
SQL: SELECT T2.Description FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T1.Title = 'Twelfth Night' AND T2.Act = 1 AND T2.Scene = 2

Database: food_inspection
Question: What was the type of inspection Tiramisu Kitchen had on 2014/1/14?
Evidence: Tiramisu Kitchen is the name of the business; inspection on 2014/1/14 refers to date = '2014-01-14';
SQL: SELECT T1.type FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.`date` = '2014-01-14' AND T2.name = 'Tiramisu Kitchen'

Database: coinmarketcap
Question: Which crytocurrency was traded in the highest value on 2016/1/8?
Evidence: traded in the highest value refers to max(volume_24h); on 2016/1/8 refers to date = '2016-01-08'
SQL: SELECT T1.name FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T2.date = '2016-01-08' AND T2.volume_24h = ( SELECT MAX(volume_24h) FROM historical WHERE date = '2016-01-08' )

Database: legislator
Question: List all of the ids of the representatives belonging to the Democrat party in district 13 that ended their term on 1/3/2019?
Evidence: ids refers to bioguide; representatives refers to type = 'rep'; ended the term on 1/3/2019 refers to end = '2019-01-03';
SQL: SELECT bioguide FROM `current-terms` WHERE type = 'rep' AND party = 'Democrat' AND end = '2019-01-03' AND district = 13

Database: books
Question: List all the authors named "George".
Evidence: author named 'George' refers to author_name = 'George%'
SQL: SELECT author_name FROM author WHERE author_name LIKE 'George%'

Database: image_and_language
Question: Count the number of 'dress' object classes and include their X and Y coordinates in image ID 1764.
Evidence: dress' object classes refer to OBJ_CLASS = 'dress'; image ID 1764 refers to IMG_ID = 1764; X and Y refer to coordinates of the bounding box;
SQL: SELECT T1.X, T1.Y FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T1.IMG_ID = 1764 AND T2.OBJ_CLASS = 'dress'

Database: retail_world
Question: Who is the sales representative of the customer who has made the highest payment? Include the full name of employee and his/her supervisor.
Evidence: highest payment refers to Max(Multiply(Quantity, UnitPrice, Subtract(1, Discount))); full name refers to FirstName, LastName; his/her supervisor refers to 'ReportsTo'
SQL: SELECT T4.LastName, T4.FirstName, T4.ReportsTo , T1.Quantity * T1.UnitPrice * (1 - T1.Discount) AS payment FROM `Order Details` AS T1 INNER JOIN Orders AS T2 ON T1.OrderID = T2.OrderID INNER JOIN Customers AS T3 ON T2.CustomerID = T3.CustomerID INNER JOIN Employees AS T4 ON T2.EmployeeID = T4.EmployeeID ORDER BY payment DESC LIMIT 1

Database: talkingdata
Question: What is the gender of the youngest user?
Evidence: youngest user refers to MIN(age);
SQL: SELECT gender FROM gender_age WHERE age = ( SELECT MIN(age) FROM gender_age )

Database: synthea
Question: How long was Mr. Major D'Amore prescribed with Amoxicillin 250 MG / Clavulanate 125 MG [Augmentin]?
Evidence: how long = SUBTRACT(julianday(medications.STOP, julianday(medications.START))); Amoxicillin 250 MG / Clavulanate 125 MG [Augmentin] refers to medications.DESCRIPTION = 'Amoxicillin 250 MG / Clavulanate 125 MG [Augmentin]';
SQL: SELECT strftime('%J', T2.STOP) - strftime('%J', T2.START) AS days FROM patients AS T1 INNER JOIN medications AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = ' Amoxicillin 250 MG / Clavulanate 125 MG [Augmentin]' AND T1.first = 'Major' AND T1.last = 'D''Amore'

Database: european_football_1
Question: Which country had the game that Away team made the most goals?
Evidence: the most goals refer to MAX(FTAG), which is a short name for Final-time Away-team Goals;
SQL: SELECT T2.country FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division GROUP BY T2.country ORDER BY SUM(T1.FTAG) DESC LIMIT 1

Database: retail_world
Question: Please name any three products that have been discontinued in the meat or poultry category.
Evidence: three products that have been discontinued refer to ProductName LIMIT 3 where Discontinued = 1; CategoryName = 'Meat/Poultry';
SQL: SELECT T2.ProductName FROM Categories AS T1 INNER JOIN Products AS T2 ON T1.CategoryID = T2.CategoryID WHERE T2.Discontinued = 1 AND T1.CategoryName = 'Meat/Poultry' LIMIT 3