Database: college_completion
Question: Calculate the percentage of Asian students among students of other races who graduated from institution in Alabama in year 2013 within 100 percent of normal / expected time.
Evidence: Asian refers to race = 'A'; Alabama refers to state = 'Alabama'; graduated within 100 percent of normal/expected time refers to grad_100; percentage = MULTIPLY(DIVIDE(SUM(race = 'A'), SUM(grad_cohort)), 100);
SQL: SELECT CAST(SUM(CASE WHEN T2.race = 'A' THEN 1 ELSE 0 END) AS REAL) * 100 / SUM(T2.grad_cohort) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T1.unitid = T2.unitid WHERE T2.year = 2013 AND T1.state = 'Alabama'

Database: beer_factory
Question: Which brewery brewed the most sold root beer in 2015?
Evidence: brewery refers to BreweryName; most sold root beer refers to MAX(COUNT(BrandID)); in 2015 refers to TransactionDate > = '2015-01-01' AND TransactionDate < = '2015-12-31';
SQL: SELECT T3.BreweryName FROM rootbeer AS T1 INNER JOIN `transaction` AS T2 ON T1.RootBeerID = T2.RootBeerID INNER JOIN rootbeerbrand AS T3 ON T1.BrandID = T3.BrandID WHERE T2.TransactionDate LIKE '2015%' GROUP BY T3.BrandID ORDER BY COUNT(T1.BrandID) DESC LIMIT 1

Database: address
Question: What is the area code of Bishopville, SC?
Evidence: "Bishopville" is the city; 'SC' is the state
SQL: SELECT T1.area_code FROM area_code AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.city = 'Bishopville' AND T2.state = 'SC'

Database: soccer_2016
Question: How old is Ishan Kishan in 2022?
Evidence: old refers to SUBTRACT(2022, SUBSTR(DOB, 1, 4)); Ishan Kishan refers to Player_Name = 'Ishan Kishan';
SQL: SELECT 2022 - SUBSTR(DOB, 1, 4) FROM Player WHERE Player_Name = 'Ishan Kishan'

Database: books
Question: Which country does Malina Johnson live in?
Evidence: country refers to country_name
SQL: SELECT T4.country_name FROM customer AS T1 INNER JOIN customer_address AS T2 ON T1.customer_id = T2.customer_id INNER JOIN address AS T3 ON T3.address_id = T2.address_id INNER JOIN country AS T4 ON T4.country_id = T3.country_id WHERE T1.first_name = 'Malina' AND T1.last_name = 'Johnson' AND T2.status_id = 2

Database: talkingdata
Question: Please list the event IDs of the events that have happened on the device of the oldest user.
Evidence: oldest user refers to MAX(age);
SQL: SELECT T2.event_id FROM gender_age AS T1 INNER JOIN events AS T2 ON T1.device_id = T2.device_id ORDER BY T1.age DESC LIMIT 1

Database: superstore
Question: Among all the orders made by Aimee Bixby, how many of them chose the slowest delivery speed?
Evidence: made by Aimee Bixby refers to "Customer Name" = 'Aimee Bixby'; the slowest delivery speed refers to "Ship Mode" = 'Standard Class';
SQL: SELECT COUNT(DISTINCT T2.`Order ID`) FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T1.`Customer Name` = 'Aimee Bixby' AND T2.`Ship Mode` = 'Standard Class'

Database: world
Question: What are the cities for country called "Â´Uman" in local name.
SQL: SELECT T1.Name FROM City AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.Code WHERE T2.LocalName = 'Â´Uman'

Database: simpson_episodes
Question: What is the name of the person that has the highest number of nominated award but didn't win?
Evidence: nominated refers to result = 'Nominee'; highest number of nominated award refers to Max(Count(person))
SQL: SELECT person FROM Award WHERE result = 'Nominee' GROUP BY person ORDER BY COUNT(person) DESC LIMIT 1;

Database: citeseer
Question: In the papers classified as ML, how many cited butz01algorithmic?
Evidence: classification refers to class_label; paper cited by refers to citing_paper_id; citing_paper_id = 'butz01algorithmic';
SQL: SELECT COUNT(T1.paper_id) FROM paper AS T1 INNER JOIN cites AS T2 ON T1.paper_id = T2.citing_paper_id WHERE T1.class_label = 'ML' AND T2.cited_paper_id = 'butz01algorithmic'

Database: human_resources
Question: Among the employees who work as a Trainee, how many of them have a salary of over &20,000 a year?
Evidence: Trainee is a position title; salary of over 20,000 refers to salary > '20000'
SQL: SELECT COUNT(*) FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE CAST(REPLACE(SUBSTR(T1.salary, 4), ',', '') AS REAL) > 20000 AND T2.positiontitle = 'Trainee'

Database: video_games
Question: What is the genre ID of the '2Xtreme' game?
Evidence: the '2Xtreme' game refers to game_name = '2Xtreme'
SQL: SELECT T.genre_id FROM game AS T WHERE T.game_name = '2Xtreme'

Database: video_games
Question: What year were the first game released?
Evidence: year the first game was released refers to MIN(release_year);
SQL: SELECT T.release_year FROM game_platform AS T ORDER BY T.release_year ASC LIMIT 1

Database: cars
Question: Among the cars with an engine displacement of no less than 400 cubic millimeter, how many cars cost at least 30,000?
Evidence: engine displacement of no less than 400 cubic millimeter refers to displacement > 400; cost at least 30,000 refers to price > 30000
SQL: SELECT COUNT(*) FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T1.displacement > 400 AND T2.price > 30000

Database: retail_world
Question: How many orders have Margaret Peacock placed?
SQL: SELECT COUNT(T2.EmployeeID) FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T1.FirstName = 'Margaret' AND T1.LastName = 'Peacock'

Database: food_inspection
Question: Which business was the first one to get a low risk violation because of "Permit license or inspection report not posted"? Give the name of the business.
Evidence: low risk violation because of "Permit license or inspection report not posted" refers to risk_category = 'Low Risk' where description = 'Permit license or inspection report not posted'; business was the first one refers to name where MIN(date);
SQL: SELECT T2.name FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.`date` = ( SELECT MIN(`date`) FROM violations WHERE risk_category = 'Low Risk' AND description = 'Permit license or inspection report not posted' ) AND T1.risk_category = 'Low Risk' AND T1.description = 'Permit license or inspection report not posted'

Database: address
Question: Please list the Asian populations of all the residential areas with the bad alias "URB San Joaquin".
Evidence: "URB San Joaquin" is the bad_alias
SQL: SELECT SUM(T1.asian_population) FROM zip_data AS T1 INNER JOIN avoid AS T2 ON T1.zip_code = T2.zip_code WHERE T2.bad_alias = 'URB San Joaquin'

Database: books
Question: How many books were published by publisher "Thomas Nelson"?
Evidence: "Thomas Nelson" is the publisher_name
SQL: SELECT COUNT(*) FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id WHERE T2.publisher_name = 'Thomas Nelson'

Database: video_games
Question: Tell the genre of the game "Resident Evil: Revelations".
Evidence: genre refers to genre_name; game "Resident Evil: Revelations" refers to game_name = 'Resident Evil: Revelations'
SQL: SELECT T2.genre_name FROM game AS T1 INNER JOIN genre AS T2 ON T1.genre_id = T2.id WHERE T1.game_name = 'Resident Evil: Revelations'

Database: social_media
Question: Give the number of users who do not show their genders.
Evidence: do not show their gender refers to Gender = 'Unknown'
SQL: SELECT COUNT(UserID) AS user_number FROM user WHERE Gender = 'Unknown'

Database: regional_sales
Question: What are the names of the sales teams that have served to customer Apotheca, Ltd?
Evidence: name of sales team refers to Sales Team; 'Apotheca, Ltd' is the Customer Names
SQL: SELECT DISTINCT T3.`Sales Team` FROM Customers AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._CustomerID = T1.CustomerID INNER JOIN `Sales Team` AS T3 ON T3.SalesTeamID = T2._SalesTeamID WHERE T1.`Customer Names` = 'Apotheca, Ltd'