Database: retail_world
Question: Please list the names of all the territories whose sales are taken in charge by Nancy Davolio.
Evidence: names of all territories refers to TerritoryDescription;
SQL: SELECT T3.TerritoryDescription FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID INNER JOIN Territories AS T3 ON T2.TerritoryID = T3.TerritoryID WHERE T1.FirstName = 'Nancy' AND T1.LastName = 'Davolio'

Database: restaurant
Question: In the Bay Area, what is the most common type of food served by restaurants?
Evidence: the Bay Area refers to region = 'bay area'; the most common type of food refers to max(count(food_type))
SQL: SELECT T2.food_type FROM geographic AS T1 INNER JOIN generalinfo AS T2 ON T1.city = T2.city WHERE T1.region = 'bay area' GROUP BY T2.food_type ORDER BY COUNT(T2.food_type) DESC LIMIT 1

Database: disney
Question: Which movie's song title has the highest total gross?
Evidence: The highest total gross refers to MAX(total_gross);
SQL: SELECT T2.song FROM movies_total_gross AS T1 INNER JOIN characters AS T2 ON T1.movie_title = T2.movie_title ORDER BY CAST(REPLACE(trim(T1.total_gross, '$'), ',', '') AS REAL) DESC LIMIT 1

Database: disney
Question: How many voice-actors were involved in the Bambi movie?
Evidence: Bambi is the name of the movie which refers to movie = 'Bambi';
SQL: SELECT COUNT(DISTINCT 'voice-actor') FROM `voice-actors` WHERE movie = 'Bambi'

Database: beer_factory
Question: What is the percentage of female customers who subscribed to the email list?
Evidence: percentage = MULTIPLY(DIVIDE(COUNT(CustomerID WHERE Gender = 'F'), COUNT(CustomerID) WHERE SubscribedToEmailList = 'TRUE'), 1.0); female refers to Gender = 'F'; subscribed to the email list refers to SubscribedToEmailList = 'TRUE';
SQL: SELECT CAST(COUNT(CASE WHEN Gender = 'F' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(SubscribedToEmailList) FROM customers WHERE SubscribedToEmailList = 'TRUE'

Database: video_games
Question: Which publisher has published the most games in the 'Puzzle' genre?
Evidence: which publisher refers to publisher_name; publisher that has published the most games refers to MAX(COUNT(publisher_name)); puzzle genre refers to genre_name = 'Puzzle';
SQL: SELECT T.publisher_name FROM ( SELECT T1.publisher_name, COUNT(T3.id) FROM publisher AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.publisher_id INNER JOIN game AS T3 ON T2.game_id = T3.id INNER JOIN genre AS T4 ON T3.genre_id = T4.id WHERE T4.genre_name = 'Puzzle' GROUP BY T1.publisher_name ORDER BY COUNT(T3.id) DESC LIMIT 1 ) t

Database: chicago_crime
Question: What is the full name of the alderman of ward no.21?
Evidence: full name of alderman refers to alderman_first_name, alderman_last_name, alderman_name_suffix
SQL: SELECT alderman_first_name, alderman_last_name, alderman_name_suffix FROM Ward WHERE ward_no = 21

Database: chicago_crime
Question: How many crimes described as 'The theft of a motor vehicle' by the FBI have taken place in the Lake View community?
Evidence: lake view community refers to community_area_name = 'Lake View'; 'The theft of a motor vehicle' is the description
SQL: SELECT SUM(CASE WHEN T3.community_area_name = 'Lake View' THEN 1 ELSE 0 END) FROM FBI_Code AS T1 INNER JOIN Crime AS T2 ON T2.fbi_code_no = T1.fbi_code_no INNER JOIN Community_Area AS T3 ON T3.community_area_no = T2.community_area_no WHERE T1.description = 'The theft of a motor vehicle.'

Database: software_company
Question: Of the first 60,000 customers who sent a true response to the incentive mailing sent by the marketing department, how many of them are female?
Evidence: RESPONSE = 'true'; SEX = 'Female';
SQL: SELECT COUNT(T1.ID) FROM Customers AS T1 INNER JOIN Mailings1_2 AS T2 ON T1.ID = T2.REFID WHERE T1.SEX = 'Female' AND T2.RESPONSE = 'true'

Database: student_loan
Question: Which school has the highest number of disabled students?
Evidence: highest number of disabled students refers to MAX(COUNT(disabled.name))
SQL: SELECT T.school FROM ( SELECT T2.school, COUNT(T2.name) AS num FROM disabled AS T1 INNER JOIN enrolled AS T2 ON T1.name = T2.name GROUP BY T2.school ) T ORDER BY T.num DESC LIMIT 1

Database: talkingdata
Question: Indicate the location of all the events that occurred on April 30, 2016.
Evidence: location = longitude, latitude; on April 30, 2016 refers timestamp BETWEEN '2016-04-30 00:00:00' AND '2016-04-30 23:59:59';
SQL: SELECT longitude, latitude FROM events WHERE date(timestamp) = '2016-04-30'

Database: restaurant
Question: How many streets with restaurants are there in the Northern California region?
SQL: SELECT COUNT(T1.city) FROM geographic AS T1 INNER JOIN location AS T2 ON T1.city = T2.city WHERE T1.region = 'northern california'

Database: retails
Question: How many customers in the machinery segment are in debt?
Evidence: machinery segment refers to c_mktsegment = 'MACHINERY'; in debt refers to c_acctbal < 0
SQL: SELECT COUNT(c_custkey) FROM customer WHERE c_acctbal < 0 AND c_mktsegment = 'MACHINERY'

Database: synthea
Question: How many patients on average receive combined chemotherapy and radiation therapy procedures each year?
Evidence: average = DIVIDE(COUNT(procedures.PATIENT), COUNT(substr(procedures.DATE, 1, 4))); combined chemotherapy and radiation therapy refers to procedures.DESCRIPTION = 'Combined chemotherapy and radiation therapy (procedure)';
SQL: SELECT CAST(COUNT(PATIENT) AS REAL) / COUNT(DISTINCT strftime('%Y', DATE)) FROM procedures WHERE DESCRIPTION = 'Combined chemotherapy and radiation therapy (procedure)'

Database: talkingdata
Question: State the number of the "魅蓝Note 2" users who are in the "F29-32" group.
Evidence: 魅蓝Note 2 refers to device_model = '魅蓝Note 2';
SQL: SELECT COUNT(T2.device_id) FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.`group` = 'F29-32' AND T2.device_model = '魅蓝Note 2'

Database: authors
Question: What is the full name of the journal that published the paper "Multiple paternity in a natural population of a salamander with long-term sperm storage"?
Evidence: paper "Multiple paternity in a natural population of a salamander with long-term sperm storage" refers to Title = 'Multiple paternity in a natural population of a salamander with long-term sperm storage'
SQL: SELECT T2.FullName FROM Paper AS T1 INNER JOIN Journal AS T2 ON T1.JournalId = T2.Id WHERE T1.Title = 'Multiple paternity in a natural population of a salamander with long-term sperm storage'

Database: chicago_crime
Question: What are the general and specific descriptions of the most common crime incidents that happened in an aircraft?
Evidence: in aircraft refers to location_description = 'AIRCRAFT'; general description refers to primary_description; specific description refers to secondary_description; most common crime incidents refers to Max(Count(iucr_no))
SQL: SELECT T2.primary_description, T2.secondary_description FROM Crime AS T1 INNER JOIN IUCR AS T2 ON T1.iucr_no = T2.iucr_no WHERE T1.location_description = 'AIRCRAFT' GROUP BY T1.iucr_no ORDER BY COUNT(T1.iucr_no) DESC LIMIT 1

Database: books
Question: Among all addresses provided by customers, identify the percentage that are not in use anymore.
Evidence: address not in use refers to address_status = 'Inactive'; percentage = Divide (Count(address_status = 'Inactive'), Count(address_status)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T2.address_status = 'Inactive' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM customer_address AS T1 INNER JOIN address_status AS T2 ON T2.status_id = T1.status_id

Database: mental_health_survey
Question: How many questions did user No.5 answer?
Evidence: user No.5 refers to userID = 5
SQL: SELECT COUNT(QuestionID) FROM Answer WHERE UserID = 5