Database: college_completion
Question: List all the public institutes from the state with the least number of graduate cohort in 2013.
Evidence: public refers to control = 'Public'; institutes refers to chronname; least number of graduate cohort refers to MIN(grad_cohort); in 2013 refers to year = 2013;
SQL: SELECT T1.chronname FROM institution_details AS T1 INNER JOIN state_sector_grads AS T2 ON T1.state = T2.state WHERE T2.year = 2013 AND T1.control = 'Public' ORDER BY T2.grad_cohort LIMIT 1

Database: professional_basketball
Question: What is the minimum weight of all-star players coming from UCLA college?
Evidence: minimum weight refers to Min(weight)
SQL: SELECT MIN(T1.weight) FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE T1.college = 'UCLA'

Database: video_games
Question: Which game platform is the most popular in Europe?
Evidence: game platform refers to game_platform_id; the most popular refers to max(num_sales); in Europe refers to region_name = 'Europe'
SQL: SELECT T.platform_name FROM ( SELECT T4.platform_name, SUM(T2.num_sales) FROM region AS T1 INNER JOIN region_sales AS T2 ON T1.id = T2.region_id INNER JOIN game_platform AS T3 ON T2.game_platform_id = T3.id INNER JOIN platform AS T4 ON T3.platform_id = T4.id WHERE T1.region_name = 'Europe' ORDER BY T2.num_sales DESC LIMIT 1 ) t

Database: public_review_platform
Question: List down the business ID with a star range from 3 to 4, located at Tempe.
Evidence: star range from 3 to 4 refers to stars > = 3 AND stars < 5; 'Tempe' is the name of city
SQL: SELECT business_id FROM Business WHERE city LIKE 'Tempe' AND stars BETWEEN 3 AND 4

Database: public_review_platform
Question: How many reviews have the user whose ID is 3 posted?
SQL: SELECT COUNT(review_length) FROM Reviews WHERE user_id = 3

Database: ice_hockey_draft
Question: What are the names of the players who played for Acadie-Bathurst Titan during the regular season in 1998-1999?
Evidence: names of the players refers to PlayerName; played for Acadie-Bathurst Titan refers to TEAM = 'AcadieandBathurst Titan'; regular season refers to GAMETYPE = 'Regular Season'; in 1998-1999 refers to SEASON = '1998-1999';
SQL: SELECT T2.PlayerName FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.SEASON = '1998-1999' AND T1.GAMETYPE = 'Regular Season' AND T1.TEAM = 'Acadie-Bathurst Titan'

Database: video_games
Question: Provide the ID of 1C Company.
Evidence: ID refers to publisher.id; 1C Company refers to publisher_name = '1C Company'
SQL: SELECT T.id FROM publisher AS T WHERE T.publisher_name = '1C Company'

Database: public_review_platform
Question: List at least 5 users that has received less than 5 low compliments from
other users.
Evidence: less than 5 low compliment refers to number_of_compliments < 5
SQL: SELECT user_id FROM Users_Compliments WHERE number_of_compliments LIKE 'Low' GROUP BY user_id ORDER BY COUNT(number_of_compliments) > 5 LIMIT 5

Database: car_retails
Question: Who is the sales representative that made the order which was sent to 25 Maiden Lane, Floor No. 4?
Evidence: Sales representative is an employee;
SQL: SELECT T2.firstName, T2.lastName FROM customers AS T1 INNER JOIN employees AS T2 ON T1.salesRepEmployeeNumber = T2.employeeNumber WHERE T1.addressLine1 = '25 Maiden Lane' AND T1.addressLine2 = 'Floor No. 4'

Database: retails
Question: In which country do most of the customers come from?
Evidence: country refers to n_name; most of the customers refer to MAX(COUNT(c_custkey));
SQL: SELECT T.n_name FROM ( SELECT T2.n_name, COUNT(T1.c_custkey) AS num FROM customer AS T1 INNER JOIN nation AS T2 ON T1.c_nationkey = T2.n_nationkey GROUP BY T2.n_name ) AS T ORDER BY T.num DESC LIMIT 1

Database: software_company
Question: How many customers have never married?
Evidence: MARITAL_STATUS = 'Never-married';
SQL: SELECT COUNT(ID) FROM Customers WHERE MARITAL_STATUS = 'Never-married'

Database: synthea
Question: What was the condition of Elly Koss on 2009/1/8?
Evidence: condition on 2009/1/8 refers to DESCRIPTION from conditions where START = '2009-01-08';
SQL: SELECT T2.description FROM patients AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Elly' AND T1.last = 'Koss' AND T2.START = '2009-01-08'

Database: retails
Question: List the names of customers whose accounts are in debt.
Evidence: name of customer refers to c_name; account in debt refers to c_acctbal < 0
SQL: SELECT c_name FROM customer WHERE c_acctbal < 0

Database: genes
Question: Among the pairs of genes that are not from the class of motorproteins, how many of them are negatively correlated?
Evidence: If Expression_Corr < 0, it means the negatively correlated
SQL: SELECT COUNT(T1.GeneID) FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 WHERE T2.Expression_Corr < 0 AND T1.Class = 'Motorproteins'

Database: retail_world
Question: How many employees is a UK citizen and are they all covering the same region?
Evidence: is a UK citizen refers to Country = 'UK'
SQL: SELECT COUNT(T1.EmployeeID), T3.RegionID FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID INNER JOIN Territories AS T3 ON T2.TerritoryID = T3.TerritoryID WHERE T1.Country = 'UK' GROUP BY T3.RegionID

Database: image_and_language
Question: Give all the bounding boxes for image 2222 whose object classes are feathers.
Evidence: bounding boxes refers to (x, y, W, H); image 2222 refers to IMG_ID = 2222; object classes are feathers refers to OBJ_CLASS = 'feathers'
SQL: SELECT T2.X, T2.Y, T2.H, T2.W FROM OBJ_CLASSES AS T1 INNER JOIN IMG_OBJ AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.IMG_ID = 2222 AND T1.OBJ_CLASS = 'feathers'

Database: movie_3
Question: Find the full name and email address of inactive customers whose record was created in 2006.
Evidence: full name refers to first_name, last_name; record created in 2006 refers to create_date = 2006; inactive customers refers to active = 0
SQL: SELECT first_name, last_name, email FROM customer WHERE STRFTIME('%Y',create_date) = '2006' AND active = 0

Database: movie_3
Question: What are the addresses for the stores?
SQL: SELECT T2.address FROM store AS T1 INNER JOIN address AS T2 ON T1.address_id = T2.address_id

Database: synthea
Question: How many male patients are diagnosed with hypertension as compared to female patients?
Evidence: male refers to gender = 'M'; diagnosed with hypertension refers to conditions.DESCRIPTION = 'Hypertension'; female refers to gender = 'F'; number of male patients with hypertension = count(patient WHERE gender = 'M' AND conditions.DESCRIPTION = 'Hypertension'); number of female patients with hypertension = count(patient WHERE gender = 'F' AND conditions.DESCRIPTION = 'Hypertension');
SQL: SELECT COUNT(DISTINCT CASE WHEN T2.gender = 'M' THEN T2.patient END) AS Male , COUNT(DISTINCT CASE WHEN T2.gender = 'F' THEN T2.patient END) AS Female FROM conditions AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T1.DESCRIPTION = 'Hypertension'

Database: soccer_2016
Question: Among the matches, what percentage have a winning margin above 100?
Evidence: winning margin above 100 refers to Win_Margin > 100; percentage = divide(count(Match_Id) when Win_Margin > 100, count(Match_Id)) as percentage
SQL: SELECT CAST(COUNT(CASE WHEN Win_Margin > 100 THEN 1 ELSE 0 END) AS REAL) * 100 / TOTAL(Match_Id) FROM `Match`

Database: shakespeare
Question: Describe the full title which had the character named Servant to Montague.
Evidence: full title refers to LongTitle; character named Servant to Montague refers to characters.Description = 'Servant to Montague'
SQL: SELECT DISTINCT T1.LongTitle 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 T4.Description = 'Servant to Montague'