Database: soccer_2016
Question: Among the players whose bowling skill is "Legbreak", when was the oldest one of them born?
Evidence: the oldest refers to min(DOB); date of birth refers to DOB
SQL: SELECT MIN(T1.DOB) FROM Player AS T1 INNER JOIN Bowling_Style AS T2 ON T1.Bowling_skill = T2.Bowling_Id WHERE T2.Bowling_Skill = 'Legbreak'

Database: mental_health_survey
Question: How many users answered "No" to question 19?
Evidence: Question 19 refer to QuestionID = 19; No refer to AnswerText = 'No'

SQL: SELECT COUNT(QuestionID) FROM Answer WHERE QuestionID = 19 AND AnswerText LIKE 'No'

Database: movielens
Question: What are the most common film genres made by the worst directors?
Evidence: d_quality = 5 refers to the best directors, d_quality = 0 refers to the worst directors
SQL: SELECT T2.genre FROM directors AS T1 INNER JOIN movies2directors AS T2 ON T1.directorid = T2.directorid WHERE T1.d_quality = 0 GROUP BY T2.genre ORDER BY COUNT(T2.movieid) DESC LIMIT 1

Database: professional_basketball
Question: In 1990, how many players whose teams had the winning rate of more than 75%?
Evidence: in 1990 refers to year = 1990; winning rate of more than 75% refers to Divide(won, games) > 0.75
SQL: SELECT COUNT(DISTINCT T1.playerID) FROM players_teams AS T1 INNER JOIN teams AS T2 ON T1.tmID = T2.tmID AND T1.year = T2.year WHERE CAST(T2.won AS REAL) * 100 / CAST(T2.games AS REAL) > 75 AND T1.year = 1990

Database: authors
Question: Give the title and author's name of the papers published between 2000 and 2005 that include the topic optical properties.
Evidence: published between 2000 and 2005 refers to Year BETWEEN 2000 AND 2005; include the topic optical properties refers to Keyword LIKE '%optical properties%'
SQL: SELECT T1.Title, T2.Name FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T1.Keyword LIKE '%optical properties%' AND T1.Year BETWEEN 2000 AND 2005 AND T1.Title <> ''

Database: olympics
Question: Among all the Olympic competitors from Finland, how many of them are female?
Evidence: competitors from Finland refer to id where region_name = 'Finland'; female refers to gender = 'F';
SQL: SELECT COUNT(T3.id) FROM noc_region AS T1 INNER JOIN person_region AS T2 ON T1.id = T2.region_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T1.region_name = 'Finland' AND T3.gender = 'F'

Database: mental_health_survey
Question: What was the most common answer for the question "What country do you work in?"?
Evidence: most common answer refers to AnswerText where MAX(COUNT(AnswerText(QuestionID = 3)))
SQL: SELECT T1.AnswerText FROM Answer AS T1 INNER JOIN Question AS T2 ON T1.QuestionID = T2.questionid WHERE T2.questiontext = 'What country do you work in?' GROUP BY T1.AnswerText ORDER BY COUNT(T1.AnswerText) DESC LIMIT 1

Database: car_retails
Question: Please list the phone numbers of the top 3 customers that have the highest credit limit and have Leslie Jennings as their sales representitive.
SQL: SELECT t1.phone FROM customers AS t1 INNER JOIN employees AS t2 ON t1.salesRepEmployeeNumber = t2.employeeNumber WHERE t2.firstName = 'Leslie' AND t2.lastName = 'Jennings' ORDER BY t1.creditLimit DESC LIMIT 3

Database: retail_world
Question: List the company names of customers from the city with the most customers.
Evidence: most customers refers to max(count(Relationship))
SQL: SELECT CompanyName FROM `Customer and Suppliers by City` WHERE CITY = ( SELECT City FROM `Customer and Suppliers by City` GROUP BY City ORDER BY COUNT(Relationship) DESC LIMIT 1 )

Database: cookbook
Question: Among the recipes whose source is the National Potato Board, which recipe has the highest calories?
Evidence: the National Potato Board is a source; the highest calories refers to MAX(calories)
SQL: SELECT T1.title FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id WHERE T1.source = 'National Potato Board' ORDER BY T2.calories DESC LIMIT 1

Database: olympics
Question: How many male competitors were there who participated in 1948 Summer?
Evidence: male competitors refers to id where gender = 'M'; in 1948 Summer refers to games_name = '1948 Summer';
SQL: SELECT COUNT(T2.person_id) FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T1.games_name = '1948 Summer' AND T3.gender = 'M'

Database: disney
Question: What is Disney's highest grossing action movie?
Evidence: action movie refers to movie_title where genre = 'Action'; highest grossing movie refers to MAX(total_gross)
SQL: SELECT movie_title FROM movies_total_gross WHERE genre = 'Action' ORDER BY CAST(REPLACE(trim(total_gross, '$'), ',', '') AS REAL) DESC LIMIT 1

Database: music_platform_2
Question: Which podcast was reviewed the latest? State the date of creation, podcast tile and rating.
Evidence: latest refers to Max(created_at); date of creation refers to created_at
SQL: SELECT T1.podcast_id, T2.created_at, T2.title, T2.rating FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id ORDER BY T2.created_at DESC LIMIT 1

Database: european_football_1
Question: Which team won the match of the Bundesliga division on 2020/10/2?
Evidence: Bundesliga is the name of division; Date = '2020/10/2'; won the match refers to FTR = 'H';
SQL: SELECT CASE WHEN T1.FTR = 'H' THEN T1.HomeTeam WHEN T1.FTR = 'A' THEN T1.AwayTeam END WINNER FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T1.Date = '2020-10-02' AND T2.name = 'Bundesliga'

Database: menu
Question: Calculate the total price of items for menu with ID 12882.
Evidence: total price = SUM(price);
SQL: SELECT SUM(T2.price) FROM MenuPage AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.menu_page_id WHERE T1.menu_id = 12882

Database: synthea
Question: Name the reason Walter Bahringer visited medical professionals in July 2009.
Evidence: reason for visiting medical professionals refers to encounters.REASONDESCRIPTION;  in July 2009 refers to  substr(encounters.DATE, 1, 7) = '2009-07' ;
SQL: SELECT T2.REASONDESCRIPTION FROM patients AS T1 INNER JOIN encounters AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Walter' AND T1.last = 'Bahringer' AND T2.DATE LIKE '2009-07%'

Database: video_games
Question: State the region id of Japan.
Evidence: region id refers to region.id; Japan refers to region_name = 'Japan'
SQL: SELECT T.id FROM region AS T WHERE T.region_name = 'Japan'

Database: public_review_platform
Question: Calculate the increment percentage of elite user for each year since year 2005.
Evidence: since year 2005 refers to year_id Between 2005 and 2014; increment percentage = Divide(Count(user_id(year_id < 2014)), Count (user_id(year_id = 2015))) * 100
SQL: SELECT CAST(COUNT(CASE WHEN year_id < 2014 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(CASE WHEN year_id = 2005 THEN 1.0 ELSE NULL END) AS increment FROM Elite

Database: shakespeare
Question: Please list all the paragraphs in Act 1, Scene 1 in Twelfth Night.
Evidence: Twelfth Night refers to Title = 'Twelfth Night'; list the paragraphs refers to PlainText
SQL: SELECT T3.PlainText 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 WHERE T2.Act = 1 AND T2.Scene = 1 AND T1.Title = 'Twelfth Night'

Database: synthea
Question: List the patient ids whose disease has the most occurrences.
Evidence: patient ids refers to patients.patient; disease with the most occurrence refers to MAX(all_prevalences.OCCURENCES);
SQL: SELECT T1.patient FROM patients AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT INNER JOIN all_prevalences AS T3 ON T3.ITEM = T2.DESCRIPTION ORDER BY T3.OCCURRENCES DESC LIMIT 1