Database: food_inspection_2
Question: Please list the full names of all the sanitarians who have inspected the facility Burbank.
Evidence: full name refers to first_name, last_name; the facility Burbank refers to dba_name = 'Burbank'
SQL: SELECT DISTINCT T1.first_name, T1.last_name FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id INNER JOIN establishment AS T3 ON T2.license_no = T3.license_no WHERE T3.dba_name = 'Burbank' AND T1.title = 'Sanitarian'

Database: movie_platform
Question: Which movie is more popular, "The General" or "Il grido"?
Evidence: The General and Il grido are movie_title; more popular movie refers to higher (movie_popularity);
SQL: SELECT movie_title FROM movies WHERE movie_title = 'The General' OR movie_title = 'Il grido' ORDER BY movie_popularity DESC LIMIT 1

Database: movies_4
Question: How many female crews are in the movie "Mr. Smith Goes to Washington"?
Evidence: female crews refers to gender = 'Female'; "Mr. Smith Goes to Washington" refers to title = 'Mr. Smith Goes to Washington'
SQL: SELECT COUNT(T3.gender) FROM movie AS T1 INNER JOIN movie_cast AS T2 ON T1.movie_id = T2.movie_id INNER JOIN gender AS T3 ON T2.gender_id = T3.gender_id WHERE T1.title = 'Mr. Smith Goes to Washington' AND T3.gender = 'Female'

Database: regional_sales
Question: What is the amount of discount applied to the product with the highest net profit and what is the name of the said product?
Evidence: highest net profit refers to Max(Subtract(Unit Price, Unit Cost)); name of product refers to Product Name
SQL: SELECT T1.`Unit Price` * T1.`Discount Applied`, T2.`Product Name` FROM `Sales Orders` AS T1 INNER JOIN Products AS T2 ON T2.ProductID = T1._ProductID ORDER BY REPLACE(T1.`Unit Price`, ',', '') - REPLACE(T1.`Unit Cost`, ',', '') DESC LIMIT 1

Database: retail_world
Question: List the cities where the product 'Mishi Kobe Niku' were shipped to.
Evidence: cities refers to ShipCity; 'Mishi Kobe Niku' is a ProductName
SQL: SELECT T1.ShipCity FROM Orders AS T1 INNER JOIN `Order Details` AS T2 ON T1.OrderID = T2.OrderID INNER JOIN Products AS T3 ON T2.ProductID = T3.ProductID WHERE T3.ProductName = 'Mishi Kobe Niku'

Database: movie_3
Question: What is the title of the animated films that have the shortest length?
Evidence: animated film means animation; animation is a name of a category
SQL: SELECT T1.title FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T2.category_id = T3.category_id ORDER BY T1.length LIMIT 1

Database: talkingdata
Question: How many females use ZUK Z1 phones in the age group under 23?
Evidence: females refers to gender = 'F'; ZUK Z1 refers to phone_brand = 'ZUK' AND device_model = 'Z1'; under 23 refers to `group` = 'F23-' ;
SQL: SELECT COUNT(T1.device_id) FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.gender = 'F' AND T2.device_model = 'Z1' AND T1.`group` = 'F23-' AND T2.phone_brand = 'ZUK'

Database: restaurant
Question: In which counties can you find the restaurant with the highest number of branches?
Evidence: restaurant refers to label; the highest number of branches refers to max(count(city))
SQL: SELECT T2.county FROM generalinfo AS T1 INNER JOIN geographic AS T2 ON T1.city = T2.city GROUP BY T2.county ORDER BY COUNT(T1.label) DESC LIMIT 1

Database: legislator
Question: Among all the current female legislators, how many of them have attended in Senate roll call votes?
Evidence: female refers to gender_bio = 'F'; have attended in Senate roll call votes refers to lis_id is not null;
SQL: SELECT COUNT(lis_id) FROM current WHERE gender_bio = 'F' AND lis_id IS NOT NULL

Database: legislator
Question: How many class 1 senators belong to the Republican party?
Evidence: senators refers to type = 'sen';
SQL: SELECT COUNT(bioguide) FROM `current-terms` WHERE class = 1 AND party = 'Republican'

Database: cs_semester
Question: How many students does Ogdon Zywicki advise?
Evidence: Ogdon Zywicki is a professor;
SQL: SELECT COUNT(T1.student_id) FROM RA AS T1 INNER JOIN prof AS T2 ON T1.prof_id = T2.prof_id WHERE T2.first_name = 'Ogdon' AND T2.last_name = 'Zywicki'

Database: bike_share_1
Question: Among the subscriber, how many of them finished the 2nd at Folsom and Civic Center BART (7th at Market) as their start and end stations respectively for no more than 490 seconds under minimum visibility of 4 miles.
Evidence: subscription_type = 'Subscriber'; no more than 490 seconds refers to duration<490; start_station_name = '2nd at Folsom'; end_station_name = 'Civic Center BART (7th at Market)'; min_visibility_miles = 4;
SQL: SELECT COUNT(T1.id) FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code WHERE T1.subscription_type = 'Subscriber' AND T2.min_visibility_miles = 4 AND T1.duration < 490 AND T1.start_station_name = '2nd at Folsom' AND T1.end_station_name = 'Civic Center BART (7th at Market)'

Database: public_review_platform
Question: List the business ID of shopping business that have 4 stars ratings.
Evidence: shopping business refers to category_name = 'Shopping'; 4 stars ratings refers to stars = 4
SQL: SELECT T1.business_id FROM Business AS T1 INNER JOIN Business_Categories AS T2 ON T1.business_id = T2.business_id INNER JOIN Categories AS T3 ON T2.category_id = T3.category_id WHERE T3.category_name = 'Shopping' AND T1.stars = 4

Database: movies_4
Question: What is the title of the first crime movie ever released?
Evidence: first crime movie ever released refers to min(release_date) and genre_name = 'Crime'
SQL: SELECT T1.title FROM movie AS T1 INNER JOIN movie_genres AS T2 ON T1.movie_id = T2.movie_id INNER JOIN genre AS T3 ON T2.genre_id = T3.genre_id WHERE T3.genre_name = 'Crime' ORDER BY T1.release_date LIMIT 1

Database: sales
Question: List the customer's ID and last name of the customer that purchased a product with a quantity greater than 90% of the average quantity of all listed products.
Evidence: quantity greater than 90% of the average quantity = Quantity > MULTIPLY(AVG(Quantity), 0.9);
SQL: SELECT T2.CustomerID, T2.LastName FROM Sales AS T1 INNER JOIN Customers AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Quantity > ( SELECT AVG(Quantity) FROM Sales ) * 0.9

Database: car_retails
Question: What is the phone number of all companies where the last name of the contact person starts with the letter M and are not from Germany?
Evidence: last name of contact person starts with M refers to lastName LIKE 'M%'; Germany is a country; not from Germany refers to country<>'Germany';
SQL: SELECT phone FROM customers WHERE contactLastName LIKE 'M%' AND country != 'Germany'

Database: airline
Question: What is the origin airport id that recorded the longest delay due to a late aircraft?
Evidence: origin airport id refers to ORIGIN_AIRPORT_ID; longest delay due to a late aircraft refers to MAX(LATE_AIRCRAFT_DELAY);
SQL: SELECT ORIGIN_AIRPORT_ID FROM Airlines ORDER BY LATE_AIRCRAFT_DELAY DESC LIMIT 1

Database: synthea
Question: Calculate the total type of allergies for German people.
Evidence: type of allergies refers to DESCRIPTION from allergies; German people refer to PATIENT where ethnicity = 'german';
SQL: SELECT COUNT(DISTINCT T2.DESCRIPTION) FROM patients AS T1 INNER JOIN allergies AS T2 ON T1.patient = T2.PATIENT WHERE T1.ethnicity = 'german'

Database: authors
Question: List all of the conferences where a paper was published in 2008.
Evidence: Published in 2008 refer to Year = 2008


SQL: SELECT DISTINCT T2.FullName FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T1.Year = 2008