Database: university
Question: In 2016, what is the name of the university in Australia with the highest score in Citations criteria?
Evidence: In 2016 refers to year = 2016; name of the university refers to university_name; in Australia refers to country_name = 'Australia'; in Citations criteria refers to criteria_name = 'Citations'; highest score refers to MAX(score)
SQL: SELECT T3.university_name 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 INNER JOIN country AS T4 ON T4.id = T3.country_id WHERE T1.criteria_name = 'Citations' AND T2.year = 2016 AND T1.id = 4 AND T4.country_name = 'Australia' ORDER BY T2.score DESC LIMIT 1

Database: food_inspection
Question: How many high risks violations did the Tiramisu Kitchen violate?
Evidence: Tiramisu Kitchen is the name of the business; high risks violations refer to risk_category = 'High Risk';
SQL: SELECT COUNT(T1.business_id) FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T2.name = 'Tiramisu Kitchen' AND T1.risk_category = 'High Risk'

Database: legislator
Question: What type of political party Sherrod Brown has in 2005?
Evidence: political party refers to party; Sherrod Brown is an official_full_name; official_full_name refers to first_name, last_name; 2005 refers to start = 2005
SQL: SELECT T1.party FROM `current-terms` AS T1 INNER JOIN current AS T2 ON T2.bioguide_id = T1.bioguide WHERE T2.first_name = 'Sherrod' AND T2.last_name = 'Brown' AND T1.start LIKE '%2005%'

Database: software_company
Question: Among the customers who come from the place with 25746 inhabitants, how many of them are male?
Evidence: place with 44114 inhabitants refers to GEOID where INHABITANTS_K = 44.114; SEX = 'Male';
SQL: SELECT COUNT(T1.ID) FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID WHERE T2.INHABITANTS_K = 25.746 AND T1.SEX = 'Male'

Database: legislator
Question: How many percent of senators were from class 1?
Evidence: senator refers to type = 'sen'; class 1 refers to class = 1; calculation = MULTIPLY(DIVIDE(COUNT(class = 1 then bioguide), COUNT(bioguide)), 1.0)
SQL: SELECT CAST(SUM(CASE WHEN class = 1 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM `historical-terms` WHERE type = 'sen'

Database: retail_world
Question: In total, how many orders were shipped via United Package?
Evidence: via United Package refers to CompanyName = 'United Package'
SQL: SELECT COUNT(T1.OrderID) FROM Orders AS T1 INNER JOIN Shippers AS T2 ON T1.ShipVia = T2.ShipperID WHERE T2.CompanyName = 'United Package'

Database: food_inspection
Question: How many low risk violations were found in the inspection on 2014/1/14 for Tiramisu Kitchen?
Evidence: Tiramisu Kitchen is the name of the business; inspection on 2014/1/14 refers to date = '2014-01-14'; low risk violations refer to risk_category = 'Low Risk';
SQL: SELECT COUNT(T1.business_id) FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.`date` = '2014-01-14' AND T2.name = 'Tiramisu Kitchen' AND T1.risk_category = 'Low Risk'

Database: professional_basketball
Question: In 1937, how many teams whose players got at least 500 points?
Evidence: in 1937 refers to year = 1937; player got at least 500 points refers to Sum(points) > = 500
SQL: SELECT COUNT(*) FROM ( SELECT T2.name, SUM(T1.points) FROM players_teams AS T1 INNER JOIN teams AS T2 ON T1.tmID = T2.tmID AND T1.year = T2.year WHERE T1.year = 1937 GROUP BY T2.name HAVING SUM(points) >= 500 ) AS T3

Database: law_episode
Question: How many people had filled a role in the episode titled "Cherished", but did not show up in the on-screen credits?
Evidence: titled "Cherished" refers to title = 'Cherished'; did not show up in the on-screen credits refers to credited = ''
SQL: SELECT COUNT(T1.episode_id) FROM Episode AS T1 INNER JOIN Credit AS T2 ON T1.episode_id = T2.episode_id WHERE T1.title = 'Cherished' AND T2.credited = 'false'

Database: law_episode
Question: What is the title of the 3 worst rated episodes?
Evidence: worst rated refers to min(rating)
SQL: SELECT title FROM Episode ORDER BY rating LIMIT 3

Database: cs_semester
Question: Who were the students who failed the course "Applied Deep Learning"? Give the full name.
Evidence: If grade is null or empty, it means that this student fails to pass the course in which grade = NULL;
SQL: SELECT T1.f_name, T1.l_name FROM student AS T1 INNER JOIN registration AS T2 ON T1.student_id = T2.student_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.name = 'Applied Deep Learning ' AND T2.grade IS NULL

Database: movie_3
Question: Give the email address of the person who lives in "1411 Lillydale Drive".
Evidence: "1411 Lillydate Drive" is the address
SQL: SELECT T2.email FROM address AS T1 INNER JOIN staff AS T2 ON T1.address_id = T2.address_id WHERE T1.address = '1411 Lillydale Drive'

Database: movies_4
Question: Among the movie in which Dariusz Wolski works as the director of photography, what is the percentage of those movie whose vote average is over 5.0?
Evidence: director of photography refers to job = 'Director of Photography'; vote average is over 8.0 refers to vote_average > 5; percentage = divide(sum(movie_id) when vote_average > 5, count(movie_id)) as percentage
SQL: SELECT CAST(COUNT(CASE WHEN T1.vote_average > 5 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.vote_average) 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 T3.person_name = 'Dariusz Wolski' AND T2.job = 'Director of Photography'

Database: genes
Question: What percentage of genes located in the cytoskeleton are of unknown class? And of these, how many are not conditional phenotypes?
Evidence: Percentage = count(genes located in the cytoskeleton unknown class) / count(genes located in the cytoskeleton) * 100%
SQL: SELECT SUM(Localization = 'cytoskeleton' AND Phenotype = 'Conditional phenotypes') , CAST(SUM(Localization = 'cytoskeleton') AS REAL) * 100 / COUNT(GeneID) FROM Genes;

Database: superstore
Question: What are the names of the ordered products that have profit deficiency in central superstore?
Evidence: names of the ordered products refers to Product Name; deficiency refers to profit value is negative; profit > 0
SQL: SELECT DISTINCT T2.`Product Name` FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.Region = 'Central' AND T1.Profit < 0

Database: olympics
Question: What is the name of the oldest person who participated in the Olympic Games?
Evidence: the oldest person refers to person_id where MAX(age); name refers to full_name;
SQL: SELECT T1.full_name FROM person AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.person_id ORDER BY T2.age DESC LIMIT 1

Database: menu
Question: How long has the "Clear Green Turtle" dish appeared on the menu, and tell me when its latest update was?
Evidence: Clear Green Turtle is a name of dish; how long a dish appeared on the menu = SUBTRACT(last_appeared, first_appeared); latest update refers to latest updated_at;
SQL: SELECT T1.last_appeared - T1.first_appeared, T2.updated_at FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id WHERE T1.name = 'Clear green turtle'

Database: retail_world
Question: The product 'Mozzarella di Giovanni' belongs in which category? Include the category's description as well.
Evidence: Mozzarella di Giovanni' is a ProductName; category refers to CategoryName;
SQL: SELECT T2.CategoryName, T2.Description FROM Products AS T1 INNER JOIN Categories AS T2 ON T1.CategoryID = T2.CategoryID WHERE T1.ProductName = 'Mozzarella di Giovanni'