Database: mental_health_survey
Question: How many female users were surveyed in the mental health survey for 2017 in the state of Nebraska?
Evidence: AnswerText = 'Yes' where questiontext = 'Do you have a family history of mental illness?'; AnswerText = 'Female' where questionid = 2; AnswerText = 'Nebraska' where questionid = 4
SQL: SELECT COUNT(*) FROM ( SELECT T2.UserID FROM Question AS T1 INNER JOIN Answer AS T2 ON T1.questionid = T2.QuestionID INNER JOIN Survey AS T3 ON T2.SurveyID = T3.SurveyID WHERE T3.Description = 'mental health survey for 2017' AND T1.questionid = 2 AND T2.AnswerText = 'Female' UNION SELECT T2.UserID FROM Question AS T1 INNER JOIN Answer AS T2 ON T1.questionid = T2.QuestionID INNER JOIN Survey AS T3 ON T2.SurveyID = T3.SurveyID WHERE T1.questionid = 4 AND T2.AnswerText = 'Nebraska' AND T3.Description = 'mental health survey for 2017' )

Database: professional_basketball
Question: List the full name and age of the player when he won the "Finals MVP" in 2003.
Evidence: full name refers to firstName, middleName, lastName; age = subtract(2003, year(birthDate)); won the "Finals MVP" refers to award = 'Finals MVP'; in 2003 refers to year = 2003
SQL: SELECT T1.firstName, T1.middleName, T1.lastName , 2003 - strftime('%Y', T1.birthDate) FROM awards_players AS T2 JOIN players AS T1 ON T2.playerID = T1.playerID WHERE T2.award = 'Finals MVP' AND T2.year = 2003

Database: retail_complains
Question: Among the clients in Middle Atlantic, how many are them are female and no more than 18 years old?
Evidence: in Middle Atlantic refers to division = 'Middle Atlantic'; female refers to sex = 'Female'; no more than 18 refers to age < 18
SQL: SELECT COUNT(T1.sex) FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T2.division = 'Middle Atlantic' AND T1.sex = 'Female' AND T1.age < 18

Database: soccer_2016
Question: What is the bowling skill of SC Ganguly?
Evidence: SC Ganguly refers to Player_Name = 'SC Ganguly'
SQL: SELECT T1.Bowling_Skill FROM Bowling_Style AS T1 INNER JOIN Player AS T2 ON T2.Bowling_skill = T1.Bowling_Id WHERE T2.Player_Name = 'SC Ganguly'

Database: soccer_2016
Question: When did the Sunrisers Hyderabad win their first match?
Evidence: Sunrisers Hyderabad refers to Team_Name = 'Sunrisers Hyderabad'; win their first match refers to Match_Winner and min(Match_Date)
SQL: SELECT T1.Match_Date FROM `Match` AS T1 INNER JOIN Team AS T2 ON T1.Match_Winner = T2.Team_Id WHERE T2.Team_Name = 'Sunrisers Hyderabad'

Database: cars
Question: What is the percentage of cars that was produced by Japan among those that have a sweep volume of no less than 30?
Evidence: produced by Japan refers to country = 'Japan'; a sweep volume of no less than 30 refers to divide(displacement, cylinders) > 30; percentage = divide(count(ID where country = 'Japan'), count(ID)) * 100% where divide(displacement, cylinders) > 30
SQL: SELECT CAST(SUM(CASE WHEN T3.country = 'Japan' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country WHERE T1.displacement / T1.cylinders > 30

Database: university
Question: What was the score for University of Florida in "N and S" in 2014?
Evidence: University of Florida refers to university_name = 'University of Florida'; in 2014 refers to year = 2014; in "N and S" refers to criteria_name = 'N and S'
SQL: SELECT T2.score FROM ranking_criteria AS T1 INNER JOIN university_ranking_year AS T2 ON T1.id = T2.ranking_criteria_id INNER JOIN university AS T3 ON T3.id = T2.university_id WHERE T3.university_name = 'University of Florida' AND T2.year = 2014 AND T1.criteria_name = 'N and S'

Database: authors
Question: How many papers are preprint or not published?
Evidence: preprint or not published refer to Year = 0;
SQL: SELECT COUNT(Id) FROM Paper WHERE Year = 0 OR (ConferenceId = 0 AND JournalId = 0)

Database: soccer_2016
Question: When did Chennai Super Kings play its first match?
Evidence: match date refers to Match_Date; Chennai Super Kings refers to Team_Name = 'Chennai Super Kings'; first match refers to min(Match_Date)
SQL: SELECT Match_Date FROM `Match` WHERE team_1 = ( SELECT Team_Id FROM Team WHERE Team_Name = 'Chennai Super Kings' ) OR Team_2 = ( SELECT Team_Id FROM Team WHERE Team_Name = 'Chennai Super Kings' ) ORDER BY Match_Date ASC LIMIT 1

Database: retail_complains
Question: List down the full name of clients who have disputed the response from company.
Evidence: full name refers to first, middle, last; disputed the response refers to Consumer disputed? = 'Yes'
SQL: SELECT T1.first, T1.middle, T1.last FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.`Consumer disputed?` = 'Yes'

Database: beer_factory
Question: What are the brands of the root beers that received 5-star ratings from no less than 5 customers?
Evidence: brand of the root beer refers to BrandName; 5-star ratings refers to StarRating = 5; no less than 5 customers refers to COUNT(CustomerID) > = 5;
SQL: SELECT T1.BrandName FROM rootbeerbrand AS T1 INNER JOIN rootbeerreview AS T2 ON T1.BrandID = T2.BrandID WHERE T2.StarRating = 5 GROUP BY T2.BrandID HAVING COUNT(T2.StarRating) >= 5

Database: movies_4
Question: How many animators does Movie No. 129 have?
Evidence: animators refers to job = 'Animation'; Movie No. 129 refers to movie_id = 129
SQL: SELECT COUNT(movie_id) FROM movie_crew WHERE movie_id = 129 AND job = 'Animation'

Database: cs_semester
Question: Provide the full names and emails of unpaid research assistants.
Evidence: full names = f_name, l_name; research assistant refers to the student who serves for research where the abbreviation is RA; unpaid research assistant refers to salary = 'free';
SQL: SELECT T2.f_name, T2.l_name, T2.email FROM RA AS T1 INNER JOIN student AS T2 ON T1.student_id = T2.student_id WHERE T1.salary = 'free'

Database: soccer_2016
Question: Give the player id of the player who was at the non-striker end for the most number of balls in the match 501219.
Evidence: most number of balls refers to max(Ball_Id); match 501219 refers to Match_Id = 501219;
player id also refers to non_striker or ball_id
SQL: SELECT Ball_Id FROM Ball_by_Ball WHERE Non_Striker = Ball_Id ORDER BY Ball_Id DESC LIMIT 1

Database: public_review_platform
Question: What is the review length of user 60776 to business with business ID 1?
Evidence: "60776" is the user_id
SQL: SELECT review_length FROM Reviews WHERE user_id = 60776 AND business_id = 1

Database: social_media
Question: Calculate the total likes collected by tweets in `ru` posted by male users.
Evidence: 'ru' refers to Lang = 'ru'; male user refers to Gender = 'Male'
SQL: SELECT SUM(T1.Likes) FROM twitter AS T1 INNER JOIN user AS T2 ON T1.UserID = T2.UserID WHERE T1.Lang = 'ru' AND T2.Gender = 'Male'

Database: movielens
Question: How many different female users have rated movies from France?
Evidence: France is a country; Female users mean that u_gender = 'F'
SQL: SELECT COUNT(DISTINCT T2.userid) FROM users AS T1 INNER JOIN u2base AS T2 ON T1.userid = T2.userid INNER JOIN movies AS T3 ON T2.movieid = T3.movieid WHERE T1.u_gender = 'F' AND T3.country = 'France'

Database: computer_student
Question: Which member of the faculty are teaching the most courses and what is his/her general course level?
Evidence: member of the faculty refers to hasPosition <> 0, most courses refers to max(count(course.course_id))
SQL: SELECT T1.p_id, T3.courseLevel FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id GROUP BY T1.p_id ORDER BY COUNT(T2.course_id) DESC LIMIT 1