Database: synthea
Question: How many unmarried women were checked for normal pregnancy?
Evidence: unmarried refers to marital = 'S'; women refers to gender = 'F'; normal pregnancy refers to conditions.DESCRIPTION = 'normal pregnancy';
SQL: SELECT COUNT(DISTINCT T2.patient) FROM conditions AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T1.DESCRIPTION = 'Normal pregnancy' AND T2.gender = 'F' AND T2.marital = 'S'

Database: professional_basketball
Question: Among the players who have won the award of Rookie of the year, what is the height of the tallest player?
Evidence: "Rookie of the Year" is the award; tallest player refers to Max(height)
SQL: SELECT T1.height 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.height DESC LIMIT 1

Database: public_review_platform
Question: What is the number of reviews from user No. "21679"?
Evidence: user No. refers to user_id;
SQL: SELECT COUNT(review_length) FROM Reviews WHERE user_id = 21679

Database: menu
Question: Among the dishes, how many of them are for free?
Evidence: free refers to lowest_price = 0;
SQL: SELECT COUNT(*) FROM Dish WHERE lowest_price = 0

Database: movie_3
Question: List down film titles from id 1 to 10.
Evidence: id 1 to 10 refers to film_id BETWEEN 1 and 10
SQL: SELECT title FROM film WHERE film_id BETWEEN 1 AND 10

Database: movie
Question: How much longer in percentage is the screen time of the most important character in Batman than the least important one?
Evidence: most important character refers to max(screentime); least important character refers to min(screentime); movie Batman refers to title = 'Batman'; percentage = divide(subtract(max(screentime) , min(screentime)) , min(screentime)) * 100%
SQL: SELECT (MAX(CAST(SUBSTR(T2.screentime, 3, 2) AS REAL)) - MIN(CAST(SUBSTR(T2.screentime, 3, 2) AS REAL))) * 100 / MIN(CAST(SUBSTR(T2.screentime, 3, 2) AS REAL)) FROM movie AS T1 INNER JOIN characters AS T2 ON T1.MovieID = T2.MovieID WHERE T1.Title = 'Batman'

Database: superstore
Question: What is the percentage of orders with 0.2 discount in the Central superstore were purchased by customers who live in Texas?
Evidence: live in Texas refers to State = 'Texas'; percentage = divide(sum(Order ID) when Discount = 0.2, sum(Order ID)) as percentage
SQL: SELECT CAST(SUM(CASE  WHEN T2.Discount = 0.2 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T1.State = 'Texas'

Database: regional_sales
Question: What are the names of the top 3 customers who paid the highest amount of price per order after discount?
Evidence: highest price per order after discount refers to Max(Subtract(Multiply (Unit Price, Order Quantity), Discount Applied)); name of customer refers to Customer Names
SQL: SELECT `Customer Names` FROM ( SELECT T1.`Customer Names` , REPLACE(T2.`Unit Price`, ',', '') * T2.`Order Quantity` - REPLACE(T2.`Unit Price`, ',', '') * T2.`Discount Applied` AS T FROM Customers T1 INNER JOIN `Sales Orders` T2 ON T2._CustomerID = T1.CustomerID ) ORDER BY T DESC LIMIT 3

Database: public_review_platform
Question: How long is the Yelp business No. 15098 opened on Monday?
Evidence: Yelp business No. 15098 refers to business_id = '15098'; Monday refers to day_of_week = 'Monday'
SQL: SELECT SUBSTR(T1.closing_time, 1, 2) + 12 - SUBSTR(T1.opening_time, 1, 2) AS YYSJ FROM Business_Hours AS T1 INNER JOIN Days AS T2 ON T1.day_id = T2.day_id WHERE T2.day_of_week = 'Monday' AND T1.business_id = 15098

Database: sales
Question: Name the product that sold the most quantity.
Evidence: most quantity refers to MAX(Quantity);
SQL: SELECT T2.Name FROM Sales AS T1 INNER JOIN Products AS T2 ON T1.ProductID = T2.ProductID ORDER BY T1.Quantity DESC LIMIT 1

Database: professional_basketball
Question: Which coach of the Chicago Bulls during the year 1981 won the NBA Coach of the Year award in the 1970s?
Evidence: "Chicago Bull" is the name of team; during the year 1981 refers to year = 1981; 'NBA Coach of the Year' is the award; in the 1970s refers to year between 1970 to 1979
SQL: SELECT DISTINCT T2.coachID FROM coaches AS T1 INNER JOIN awards_coaches AS T2 ON T1.coachID = T2.coachID INNER JOIN teams AS T3 ON T3.tmID = T1.tmID WHERE T2.award = 'NBA Coach of the Year' AND T2.year BETWEEN 1970 AND 1979 AND T1.year = 1981 AND T3.name = 'Chicago Bulls'

Database: student_loan
Question: How many female students joined a marines and air force organization?
Evidence: joined a marines refers to organ = 'marines'; air force organization refers to organ = 'air_force';
SQL: SELECT COUNT(name) FROM enlist WHERE organ IN ('marines', 'air_force') AND name NOT IN ( SELECT name FROM male )

Database: music_platform_2
Question: Which "music" podcast has the longest title?
Evidence: music podcasts refers to category = 'music'; longest title refers to title = Max(length(title))
SQL: SELECT T2.title FROM categories AS T1 INNER JOIN podcasts AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.category = 'music' ORDER BY LENGTH(T2.title) DESC LIMIT 1

Database: professional_basketball
Question: Please list the team names which have at least 3 all-star players.
Evidence: team with at least 3 all star player refers to tmID where Count(player_allstar.playerID) > = 3
SQL: SELECT T1.tmID FROM players_teams AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID GROUP BY T1.tmID HAVING COUNT(DISTINCT T1.playerID) >= 3

Database: professional_basketball
Question: List the full name of players who are drafted from round 1 in 1973 but not born in USA.
Evidence: full name refers to firstName, middleName, lastName; in 1973 refers to year = 1973; not born in USA refers to birthCountry <> 'USA'
SQL: SELECT T1.firstName, T1.middleName, T1.lastName FROM players AS T1 INNER JOIN draft AS T2 ON T1.playerID = T2.playerID WHERE T2.draftRound = 1 AND T1.birthCountry != 'USA' AND T2.draftYear = 1973

Database: soccer_2016
Question: Calculate the average players out in the first innings per match. How many of them were out by the leg before wicket?
Evidence: out by the leg refers to Out_Name = 'lbw'; out in the first innings refers to Innings_No = 2;
SQL: SELECT CAST(COUNT(T1.Player_Out) AS REAL) / COUNT(T1.Match_Id), SUM(CASE WHEN T2.Out_Name = 'lbw' THEN 1 ELSE 0 END) FROM Wicket_Taken AS T1 INNER JOIN Out_Type AS T2 ON T1.Kind_Out = T2.Out_Id WHERE T1.Innings_No = 2

Database: language_corpus
Question: What's the occurrence of the biwords pair whose first word is "àbac" and second word is "xinès"?
Evidence: àbac refers to word = 'àbac'; xinès refers to word = 'xinès'; occurrence refers to occurrences
SQL: SELECT occurrences FROM biwords WHERE w1st = ( SELECT wid FROM words WHERE word = 'àbac' ) AND w2nd = ( SELECT wid FROM words WHERE word = 'xinès' )

Database: university
Question: What is the score of university ID 68 in 2015?
Evidence: in 2015 refers to year = 2015
SQL: SELECT score FROM university_ranking_year WHERE year = 2015 AND university_id = 68

Database: sales_in_weather
Question: Give the number of stores which opened on the weather station that recorded the fastest average wind speed.
Evidence: fastest average wind speed refers to Max(avgspeed); number of store refers to count(store_nbr)
SQL: SELECT COUNT(T.store_nbr) FROM ( SELECT DISTINCT store_nbr FROM relation WHERE station_nbr = ( SELECT station_nbr FROM weather ORDER BY avgspeed DESC LIMIT 1 ) ) T