Database: college_completion
Question: What is the number of female graduates between 2011 to 2013 from the state where 'Gateway Community College' is located?
Evidence: female refers to gender = 'F'; graduates refers to grad_cohort; between 2011 to 2013 refers to year BETWEEN 2011 AND 2013; Gateway Community College refers to chronname = 'Gateway Community College';
SQL: SELECT COUNT(T2.grad_cohort) FROM institution_details AS T1 INNER JOIN state_sector_grads AS T2 ON T1.state = T2.state WHERE T2.year BETWEEN 2011 AND 2013 AND T1.chronname = 'Gateway Community College' AND T2.gender = 'F'

Database: soccer_2016
Question: List the player's name who played as a captain.
Evidence: played as a captain refers to Role_Desc = 'captain'; player refers to Player_Name
SQL: SELECT T2.Player_Name FROM Player_Match AS T1 INNER JOIN Player AS T2 ON T1.Player_Id = T2.Player_Id INNER JOIN Rolee AS T3 ON T1.Role_Id = T3.Role_Id WHERE T3.Role_Desc = 'Captain' GROUP BY T2.Player_Name

Database: ice_hockey_draft
Question: How many games did the tallest player have ever played?
Evidence: tallest player refers to MAX(height_in_cm);
SQL: SELECT T1.GP FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.ELITEID = ( SELECT t.ELITEID FROM PlayerInfo t ORDER BY t.height DESC LIMIT 1 )

Database: movie_platform
Question: Which title list has not been updated for the longest period of time? State how long it has not been updated?
Evidence: not been updated for the longest period of time refers to MIN(list_update_timestamp_utc); how long it has not been updated refers to SUBTRACT(CURRENT_TIMESTAMP, list_update_timestamp_utc)
SQL: SELECT list_title , datetime(CURRENT_TIMESTAMP, 'localtime') - datetime(list_update_timestamp_utc) FROM lists ORDER BY list_update_timestamp_utc LIMIT 1

Database: address
Question: List down the country of the cities with a population greater than 97% of the average population of all countries in 2020.
Evidence: population_2020 > MULTIPLY(0.97, AVG(population_2020));
SQL: SELECT T1.county FROM country AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.population_2020 > 0.97 * ( SELECT AVG(population_2020) FROM zip_data )

Database: student_loan
Question: Among the students that filed for bankruptcy, how many of them have been enrolled in OCC?
Evidence: OCC refers to school = 'occ';
SQL: SELECT COUNT(T1.name) FROM filed_for_bankrupcy AS T1 INNER JOIN enrolled AS T2 ON T1.name = T2.name WHERE T2.school = 'occ'

Database: movie_3
Question: How many actors starred in the film id 508?
SQL: SELECT COUNT(actor_id) FROM film_actor WHERE film_id = 508

Database: public_review_platform
Question: There was only one tip that user No. 69722 gave to the Yelp business, what was the ratings of that business?
Evidence: short tip refers to tip_lenghth = 'short'; user No. refers to user_id; ratings refers to stars; stars = 5 means great experience; stars = 4 means good experience; stars = 3 means average experience; stars = 2 means bad experience; stars = 1 means terrible experience;

SQL: SELECT T2.stars FROM Tips AS T1 INNER JOIN Business AS T2 ON T1.business_id = T2.business_id WHERE T1.user_id = 69722

Database: soccer_2016
Question: How many matches have 7 points of winning margin?
Evidence: have 7 points of winning margin refers to win_margin = 7;
SQL: SELECT COUNT(Match_Id) FROM Match WHERE win_margin = 7

Database: retail_world
Question: Of all the orders that have ordered Ikura, how many of them enjoys a unit price that's lower than its standard unit price?
Evidence: Ikura refers to ProductName = 'Ikura'; ordered unit price that's lower than its standard unit price refers to "Order Details".UnitPrice < "Product".UnitPrice;
SQL: SELECT COUNT(T2.OrderID) FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T1.ProductName = 'Ikura' AND T2.UnitPrice < T1.UnitPrice

Database: retail_world
Question: List the supplier company names located in Germany.
Evidence: located in Germany refers to Country = 'Germany';
SQL: SELECT CompanyName FROM Suppliers WHERE Country = 'Germany'

Database: chicago_crime
Question: More crimes happened in which community area in January, 2018, Woodlawn or Lincoln Square?
Evidence: in January 2018 refers to date like '%1/2018%'; Woodlawn or Lincoln Square refers to community_area_name in ('Woodlawn', 'Lincoln Square'); number of crime refers to COUNT(report_no); the higher the report_no, the more crimes happened in the community;
SQL: SELECT T1.community_area_name FROM Community_Area AS T1 INNER JOIN Crime AS T2 ON T1.community_area_no = T2.community_area_no WHERE T1.community_area_name IN ('Woodlawn', 'Lincoln Square') AND T2.date LIKE '%1/2018%' GROUP BY T1.community_area_name ORDER BY COUNT(T1.community_area_name) DESC LIMIT 1

Database: professional_basketball
Question: How many field goals did George Mikan make overall between 1951 and 1953?
Evidence: between 1951 and 1953 refers to season_id; field goal refers to fg_made
SQL: SELECT COUNT(fg_made) FROM player_allstar WHERE first_name = 'George' AND last_name = 'Mikan' AND season_id BETWEEN 1951 AND 1953

Database: movie
Question: What is the runtime of the movie starred by Jackie Chan with a rating greater than 7?
Evidence: starred by Jackie Chan refers to Name = 'Jackie Chan'; rating greater than 7 refers to Rating > 7
SQL: SELECT T1.Runtime FROM movie AS T1 INNER JOIN characters AS T2 ON T1.MovieID = T2.MovieID INNER JOIN actor AS T3 ON T3.ActorID = T2.ActorID WHERE T3.Name = 'Jackie Chan' AND T1.Rating > 7

Database: college_completion
Question: How many 2-year public schools are there in "California"?
Evidence: 2-year refers to level = '2-year'; public refers to control = 'public'; California refers to state = 'California';
SQL: SELECT COUNT(stateid) FROM state_sector_details WHERE state = 'California' AND level = '2-year' AND control = 'Public'

Database: professional_basketball
Question: State the name of teams ranked first five or more times and lost a league two or more times between 1980 and 2000?
Evidence: name of team refers to teams.name; between 1980 and 2000 refers to year between 1980 and 2000; ranked first five or more times refers to count(rank = 1) > = 5; lost a league two or more times refers to lost > 2
SQL: SELECT T1.name FROM teams AS T1 INNER JOIN series_post AS T2 ON T1.tmID = T2.tmIDLoser AND T1.year = T2.year WHERE T1.rank < 5 AND T2.lgIDLoser > 2 AND T2.year BETWEEN 1980 AND 2000

Database: beer_factory
Question: How many customers are named Charles in Sacramento?
Evidence: Sacramento refers to City = 'Sacramento';
SQL: SELECT COUNT(CustomerID) FROM customers WHERE First = 'Charles' AND City = 'Sacramento'

Database: music_tracker
Question: Indicates groups with id from 10 to 20 with singles downloaded at least 20.
Evidence: releaseType = 'single'; downloaded at least 20 refers to totalSnatched ≥ 20; id from 10 to 20 refer to id between 10 and 20; groups refer to groupName;
SQL: SELECT groupName FROM torrents WHERE totalSnatched >= 20 AND releaseType LIKE 'single' AND id BETWEEN 10 AND 20

Database: shipping
Question: Calculate the difference between the number of shipments shipped by the truck with the model year 2005 and model year 2006.
Evidence: "2005" and "2006" are both model_year of truck; difference = Subtract (Count (ship_id where model_year = 2005), Count(ship_id where model_year = 2006))
SQL: SELECT SUM(CASE WHEN T1.model_year = '2005' THEN 1 ELSE 0 END) - SUM(CASE WHEN T1.model_year = '2006' THEN 1 ELSE 0 END) FROM truck AS T1 INNER JOIN shipment AS T2 ON T1.truck_id = T2.truck_id