Database: shooting
Question: Of the black officers, how many of them investigated cases between the years 2010 and 2015?
Evidence: black refers to race = 'B'; between the years 2010 and 2015 refers to date between '2010-01-01' and '2015-12-31'; case refers to case_number
SQL: SELECT COUNT(T1.case_number) FROM officers AS T1 INNER JOIN incidents AS T2 ON T2.case_number = T1.case_number WHERE T1.race = 'B' AND T2.date BETWEEN '2010-01-01' AND '2015-12-31'

Database: movies_4
Question: What are the top 5 most popular movie directors?
Evidence: directors refers to job = 'Director'; most popular refers to max(popularity)
SQL: SELECT T3.person_name FROM movie AS T1 INNER JOIN movie_crew AS T2 ON T1.movie_id = T2.movie_id INNER JOIN person AS T3 ON T2.person_id = T3.person_id WHERE T2.job = 'Director' ORDER BY T1.popularity DESC LIMIT 5

Database: authors
Question: Who are the authors of the paper "Determination of Planetary Meteorology from Aerobot Flight Sensors"?
Evidence: 'Determination of Planetary Meteorology from Aerobot Flight Sensors' refer to title of the paper
SQL: SELECT T2.Name FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T1.Title = 'Determination of Planetary Meteorology FROM Aerobot Flight Sensors'

Database: student_loan
Question: Among the students who have been absent for four months, provide any five students' names and enlisted organizations.
Evidence: absent for four months refers to month = 4; enlisted organizations refers to organ;
SQL: SELECT T2.name, T2.organ FROM longest_absense_from_school AS T1 INNER JOIN enlist AS T2 ON T2.name = T1.name WHERE T1.month = 4 LIMIT 5

Database: student_loan
Question: How many students are enlisted in the army?
Evidence: enlisted in the army refers to organ = 'army';
SQL: SELECT COUNT(name) FROM enlist WHERE organ = 'army'

Database: bike_share_1
Question: What is the percentage of trips that started in San Jose and durations were longer than 800 seconds?
Evidence: percentage of trips = DIVIDE(COUNT(duration>800), COUNT(duration)) as percentage; San Jose refers to city = 'San Jose'; duration>800;
SQL: SELECT CAST(SUM(CASE WHEN T1.duration > 800 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.id) FROM trip AS T1 INNER JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T2.city = 'San Jose'

Database: menu
Question: Which menu page has a bigger width, page 1 of "Zentral Theater Terrace" or page 1 of "Young's Hotel"?
Evidence: if SUM(full_width where page_number = 1 AND menu.name = 'Zentral Theater Terrace') > SUM(full_width where page_number = 1 AND menu.name = 'Young''s Hotel'), it means Zentral Theater Terrace menu page is bigger than Young's Hotel; if SUM(full_width WHERE page_number = 1 AND menu.name = 'Young''s Hotel') < SUM(full_width WHERE page_number = 1 AND menu.name = 'Zentral Theater Terrace'), it means Young's Hotel menu page is bigger than Zentral Theater Terrace;
SQL: SELECT CASE WHEN SUM(CASE WHEN T1.name = 'Zentral Theater Terrace' THEN T2.full_width ELSE 0 END) - SUM(CASE WHEN T1.name = 'Young''s Hotel' THEN T2.full_width ELSE 0 END) > 0 THEN 'Zentral Theater Terrace' ELSE 'Young''s Hotel' END FROM Menu AS T1 INNER JOIN MenuPage AS T2 ON T1.id = T2.menu_id

Database: student_loan
Question: Mention the name of disabled students who have never been absent from school.
Evidence: never been absent from school refers to month = 0
SQL: SELECT T1.name FROM disabled AS T1 INNER JOIN longest_absense_from_school AS T2 ON T1.name = T2.name WHERE T2.month = 0

Database: talkingdata
Question: What is the most common device model among female users between the ages 27 to 28?
Evidence: most common device model refers to MAX(COUNT(device_id)); female refers to gender = 'F'; between the ages 27 to 28 refers to group = 'F27-28';
SQL: SELECT T2.device_model FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.`group` = 'F27-28' AND T1.gender = 'F' ORDER BY T2.device_id DESC LIMIT 1

Database: cs_semester
Question: Among the professors with a teachability of 3 and below, what is the percentage of their student advisees with a low salary?
Evidence: teachability < = 3; percentage = MULTIPLY(DIVIDE(COUNT(salary = 'low'), COUNT(salary)), 1.0);
SQL: SELECT CAST(SUM(CASE WHEN T1.salary = 'low' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.salary) FROM RA AS T1 INNER JOIN prof AS T2 ON T1.prof_id = T2.prof_id WHERE T2.teachingability < 3

Database: donor
Question: What is the project in which 320 students will be impacted if the project is funded? Name the project and state the project cost.
Evidence: 320 students will be impacted refers to students_reached = 320; name the project refers to title; project cost refers tp total_price_excluding_optional_support
SQL: SELECT T1.title, T2.total_price_excluding_optional_support FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T2.students_reached = 320

Database: retail_world
Question: Calculate the production volume of the dairy product 'Mascarpone Fabioli'.
Evidence: 'Mascarpone Fabioli' is a ProductName; calculation = SUM(UnitsInStock, UnitsOnOrder)
SQL: SELECT SUM(UnitsInStock + UnitsOnOrder) FROM Products WHERE ProductName = 'Mascarpone Fabioli'

Database: authors
Question: List all the title of the paper that Jianli Hua published.
Evidence: Jianli Hua is the author of a paper
SQL: SELECT T1.Title FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T2.Name = 'Jianli Hua'

Database: legislator
Question: How many legislators were born in 1736?
Evidence: born in 1736 refers to birthday_bio like '1736%';
SQL: SELECT COUNT(bioguide_id) FROM historical WHERE birthday_bio LIKE '1736%'

Database: public_review_platform
Question: Does Yelp business No."4960" have TV?
Evidence: business No. refers to business_id; have TV refers to attribute_name = 'Has TV';
SQL: SELECT DISTINCT CASE WHEN T1.attribute_name LIKE 'Has TV' THEN 'yes' ELSE 'no' END FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T2.business_id = 4960

Database: language_corpus
Question: What is the revision ID for the page on Catalan titled "Arqueologia"?
Evidence: lid = 1 means it's Catalan language; Arqueologia refers to title = 'Arqueologia'; revision ID refers to revision
SQL: SELECT revision FROM pages WHERE lid = 1 AND title = 'Arqueologia'

Database: student_loan
Question: Among the students that have a payment due, how many students are unemployed?
Evidence: students that have a payment due refers to bool = 'pos';
SQL: SELECT COUNT(T1.name) FROM no_payment_due AS T1 INNER JOIN unemployed AS T2 ON T1.name = T2.name WHERE T1.bool = 'pos'

Database: law_episode
Question: Was Anthony Azzara's role in episode tt0629204 displayed in the credits at the end of the episode?
Evidence: episode tt0629204 refers to episode_id = 'tt0629204'; credited refers to credited = 'true'; not credited refers to credited = ''
SQL: SELECT T1.credited FROM Credit AS T1 INNER JOIN Person AS T2 ON T2.person_id = T1.person_id WHERE T2.name = 'Anthony Azzara' AND T1.episode_id = 'tt0629204'

Database: soccer_2016
Question: Who is the oldest player?
Evidence: name of the player refers to Player_Name; the oldest refers to min(DOB)
SQL: SELECT Player_Name FROM Player ORDER BY DOB ASC LIMIT 1

Database: bike_share_1
Question: Is there any intercity trip were made during 2014? If yes, list out the city name for the start and end station.
Evidence: intercity trip refers to start_station_name! = end_station_name; during 2014 refers to start_date like '%2014%'; start station refers to start_station_name; end station refers to end_station_name;
SQL: SELECT T1.start_station_name, T1.end_station_name FROM trip AS T1 LEFT JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T1.start_date LIKE '%/%/2014%' AND T1.start_station_name != T1.end_station_name