Database: video_games
Question: What percentage of games are sports?
Evidence: percentage = MULTIPLY(DIVIDE(SUM(genre_name = 'sport'), COUNT(game_name)), 100.0); sports refers to genre_name = 'sport';
SQL: SELECT CAST(COUNT(CASE WHEN T1.genre_name = 'Sports' THEN T2.id ELSE NULL END) AS REAL) * 100 / COUNT(T2.id) FROM genre AS T1 INNER JOIN game AS T2 ON T1.id = T2.genre_id

Database: student_loan
Question: Please provide a gender breakdown for each organization.
Evidence: gender breakdown refers to the number of male and female; male are mentioned in male.name; female refers to enlist.name who are NOT in male.name; organization refers to organ;
SQL: SELECT IIF(T2.name IS NULL, 'female', 'male') AS gender FROM enlist AS T1 LEFT JOIN male AS T2 ON T2.name = T1.name GROUP BY T1.organ

Database: movielens
Question: How many French movies got the highest ranking?
Evidence: France is a country
SQL: SELECT COUNT(movieid) FROM movies WHERE country = 'France' AND movieid IN ( SELECT movieid FROM u2base WHERE rating = ( SELECT MAX(rating) FROM u2base ) )

Database: image_and_language
Question: Which images have more than 20 object samples?
Evidence: images have more than 20 object samples refer to IMG_ID where COUNT(OBJ_SAMPLE_ID) > 20;
SQL: SELECT IMG_ID FROM IMG_OBJ GROUP BY IMG_ID HAVING COUNT(IMG_ID) > 20

Database: legislator
Question: What is the name of the legislator with the ID of W000059?
Evidence: name of the legislator = first_name, last_name; ID of W000059 refers to bioguide_id = 'W000059';
SQL: SELECT first_name, last_name FROM historical WHERE bioguide_id = 'W000059'

Database: university
Question: How many female students were there in Pierre and Marie Curie University in 2015?
Evidence: female students refers to DIVIDE(MULTIPLY(pct_female_students, num_students), 100); in Pierre and Marie Curie University refers to university_name = 'Pierre and Marie Curie University'; in 2015 refers to year = 2015
SQL: SELECT CAST(T1.num_students * T1.pct_female_students AS REAL) / 100 FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T1.year = 2015 AND T2.university_name = 'Pierre and Marie Curie University'

Database: food_inspection_2
Question: What type of inspection was done on July 07, 2010, involving the employee named "Lisa Tillman"?
Evidence: type of inspection refers to inspection_type; on July 07, 2010 refers to inspection_date = '2010-07-07'
SQL: SELECT DISTINCT T2.inspection_type FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE T1.first_name = 'Lisa' AND T1.last_name = 'Tillman' AND T2.inspection_date = '2010-07-07'

Database: soccer_2016
Question: Among the matches of Delhi Daredevils in 2009, what is the percentage of their matches won by wickets?
Evidence: Delhi Daredevils refers to team_name = 'Delhi Daredevils'; in 2009 refers to Match_Date = '2009%'; won by wickets refers to Win_Type = 'wickets'; percentage refers to DIVIDE(COUNT(Win_Type = 'wickets'), COUNT(Win_Type))
SQL: SELECT CAST(SUM(CASE WHEN T3.Win_Type = 'wickets' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T3.Win_Type) FROM Team AS T1 INNER JOIN Match AS T2 ON T1.Team_Id = T2.Match_Winner INNER JOIN Win_By AS T3 ON T2.Win_Type = T3.Win_Id WHERE T1.Team_Name = 'Delhi Daredevils'

Database: public_review_platform
Question: What is the closing and opening time of businesses located at Gilbert with highest star rating?
Evidence: "Gilbert" is the name of city; highest star rating refers to Max(stars)
SQL: SELECT T2.closing_time, T2.opening_time FROM Business AS T1 INNER JOIN Business_Hours AS T2 ON T1.business_id = T2.business_id WHERE T1.city LIKE 'Gilbert' ORDER BY T1.stars DESC LIMIT 1

Database: video_games
Question: List the region name where games reached 300000 sales and above.
Evidence: reached 300000 sales and above refers to num_sales > 3
SQL: SELECT DISTINCT T1.region_name FROM region AS T1 INNER JOIN region_sales AS T2 ON T1.id = T2.region_id WHERE T2.num_sales * 100000 > 300000

Database: restaurant
Question: List the review and label of the restaurants in Mission Blvd., Hayward.
Evidence: Mission Blvd. refers to street_name = 'mission blvd'; Hayward refers to city = 'hayward'
SQL: SELECT T2.review, T2.label FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T2.city = 'hayward' AND T1.street_name = 'mission blvd'

Database: university
Question: How many criteria belong to ranking system ID 3?
SQL: SELECT COUNT(id) FROM ranking_criteria WHERE ranking_system_id = 3

Database: human_resources
Question: Give the number of female employees.
Evidence: number of female employees means COUNT(gender = 'F')
SQL: SELECT COUNT(*) FROM employee WHERE gender = 'F'

Database: donor
Question: How many projects have their resources provided by the vendor Lakeshore Learning Materials and are created by a teacher with a doctor degree?
Evidence: Lakeshore Learning Materials is vendor_name;  teacher with a doctor degree refers to teacher_prefix = 'Dr.';
SQL: SELECT COUNT(T1.projectid) FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.vendor_name = 'Lakeshore Learning Materials' AND T2.teacher_prefix = 'Dr.'

Database: university
Question: How many times did the Yale University achieve a score of no less than 10 in the Quality of Education Rank?
Evidence: Yale University refers to university_name = 'Yale University'; a score of no less than 10 refers to score > = 10; in the Quality of Education Rank refers to criteria_name = 'Quality of Education Rank'
SQL: SELECT COUNT(*) 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 = 'Yale University' AND T2.score >= 10 AND T1.criteria_name = 'Quality of Education Rank'

Database: legislator
Question: Among all the current female legislators, how many of them have not been registered in Federal Election Commission data?
Evidence: have not been registered refers to fec_id IS NULL; female refers to gender_bio = 'F'
SQL: SELECT COUNT(*) FROM current WHERE (fec_id IS NULL OR fec_id = '') AND gender_bio = 'F'

Database: retail_world
Question: How many customers are located in London?
Evidence: London refers to City = 'London'
SQL: SELECT COUNT(CustomerID) FROM Customers WHERE City = 'London'

Database: retail_world
Question: List down the company names which supplied products for the order on 14th August, 1996.
Evidence: products refers to Order_Details.ProductID; on 14th August, 1996 refers to OrderDate = '8/14/1996'
SQL: SELECT T1.CompanyName FROM Suppliers AS T1 INNER JOIN Products AS T2 ON T1.SupplierID = T2.SupplierID INNER JOIN `Order Details` AS T3 ON T2.ProductID = T3.ProductID INNER JOIN Orders AS T4 ON T3.OrderID = T4.OrderID WHERE date(T4.OrderDate) = '1996-08-14'

Database: mental_health_survey
Question: How many respondents who participated in the survey in 2019 have ever sought treatment for a mental health disorder from a mental health professional?
Evidence: respondents' and 'users' are synonyms, have ever sought treatment for a mental health disorder from a mental health professional refers to AnswerText(SurveyID = 2019& QuestionID = 7) = 1
SQL: SELECT COUNT(T1.UserID) FROM Answer AS T1 INNER JOIN Question AS T2 ON T1.QuestionID = T2.questionid WHERE T1.QuestionID = 7 AND T1.SurveyID = 2019 AND T1.AnswerText = 1

Database: video_games
Question: How many game publisher IDs have published games on the X360 platform?
Evidence: X360 refers to platform_name = 'X360';
SQL: SELECT COUNT(T1.game_publisher_id) FROM game_platform AS T1 INNER JOIN platform AS T2 ON T1.platform_id = T2.id WHERE T2.platform_name = 'X360'