Database: social_media
Question: Please list all the cities from where tweets with neutral sentiments were posted.
Evidence: neutral sentiment refers to Sentiment = 0
SQL: SELECT DISTINCT T2.City FROM twitter AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID WHERE Sentiment = 0

Database: address
Question: What is the number of households in the "FL-10" district?
SQL: SELECT SUM(CASE WHEN T2.district = 'FL-10' THEN 1 ELSE 0 END) FROM zip_data AS T1 INNER JOIN zip_congress AS T2 ON T1.zip_code = T2.zip_code

Database: college_completion
Question: Which city is "Rensselaer Polytechnic Institute" located in?
Evidence: Rensselaer Polytechnic Institute refers to chronname = 'Rensselaer Polytechnic Institute';
SQL: SELECT T FROM ( SELECT DISTINCT CASE WHEN chronname = 'Rensselaer Polytechnic Institute' THEN city ELSE NULL END AS T FROM institution_details ) WHERE T IS NOT NULL

Database: beer_factory
Question: State the coordinate of Sac State American River Courtyard.
Evidence: coordinate = Latitude, Longitude; Sac State American River Courtyard refers to LocationName = 'Sac State American River Courtyard';
SQL: SELECT T2.Latitude, T2.Longitude FROM location AS T1 INNER JOIN geolocation AS T2 ON T1.LocationID = T2.LocationID WHERE T1.LocationName = 'Sac State American River Courtyard'

Database: world_development_indicators
Question: Which countries have notes on the indicator BX.KLT.DINV.CD.WD?
Evidence: indicator BX.KLT.DINV.CD.WD refers to Seriescode = 'BX.KLT.DINV.CD.WD'
SQL: SELECT T1.ShortName FROM Country AS T1 INNER JOIN CountryNotes AS T2 ON T1.CountryCode = T2.Countrycode INNER JOIN Series AS T3 ON T2.Seriescode = T3.SeriesCode WHERE T3.Seriescode = 'BX.KLT.DINV.CD.WD'

Database: retails
Question: List all the addresses for the suppliers of the biggest parts.
Evidence: addresses refers to s_address; the biggest part refers to max(p_size)
SQL: SELECT T2.s_address FROM partsupp AS T1 INNER JOIN supplier AS T2 ON T1.ps_suppkey = T2.s_suppkey INNER JOIN part AS T3 ON T1.ps_partkey = T3.p_partkey ORDER BY T3.p_size DESC LIMIT 1

Database: student_loan
Question: How many unemployed students are enlisted in the Army organization?
Evidence: organization refers to organ; organ = 'army';
SQL: SELECT COUNT(T1.name) FROM enlist AS T1 INNER JOIN unemployed AS T2 ON T2.name = T1.name WHERE T1.organ = 'army'

Database: retail_world
Question: On what date did the Du monde entier company request that 9 units of Filo Mix be sent to it?
Evidence: 9 units of Filo Mix refer to ProductName where Quantity = 9; Du monde entier is the name of the customer; date refers to OrderDate;
SQL: SELECT T2.OrderDate FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN `Order Details` AS T3 ON T2.OrderID = T3.OrderID INNER JOIN Products AS T4 ON T3.ProductID = T4.ProductID WHERE T4.ProductName = 'Filo Mix' AND T3.Quantity = 9 AND T1.CompanyName = 'Du monde entier'

Database: soccer_2016
Question: List all Zimbabwean players.
Evidence: Zimbabwean refers to Country_Name = 'Zimbabwea'; players refers to Player_Name
SQL: SELECT T1.Player_Name FROM Player AS T1 INNER JOIN Country AS T2 ON T1.Country_Name = T2.Country_Id WHERE T2.Country_Name = 'Zimbabwea'

Database: movie_3
Question: Among the films starred by Nick Wahlberg, what is the percentage of the films with G rating?
Evidence: 'Nick Wahlberg' is a full name of an actor; full name refers to first_name, last_name; G rating refers to rating = 'G'; calculation = DIVIDE(SUM(rating = 'G'), SUM(rating)) * 100
SQL: SELECT CAST(SUM(IIF(T3.rating = 'G', 1, 0)) AS REAL) / COUNT(T3.film_id) FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T1.first_name = 'Elvis' AND T1.last_name = 'Marx'

Database: movie_3
Question: List the address in Texas in the ascending order of city id.
Evidence: 'Texas' is a district
SQL: SELECT address FROM address WHERE district = 'Texas' AND city_id = ( SELECT MIN(city_id) FROM address WHERE district = 'Texas' )

Database: human_resources
Question: Which employee has the highest salary? Please give his or her full name.
Evidence: the highest salary refers to MAX(salary); full name = firstname, lastname
SQL: SELECT firstname, lastname FROM employee ORDER BY salary DESC LIMIT 1

Database: world
Question: List any five countries which use English as an official language.
Evidence: English as an official language refers to `Language` = 'English' AND IsOfficial = 'T';
SQL: SELECT T1.Name FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = 'English' AND T2.IsOfficial = 'T' LIMIT 5

Database: professional_basketball
Question: Of all the teams coached by the winner of the 1994 NBA Coach of the Year award, which team has lost the most times playing at home?
Evidence: of 1994 refers to year = 1994; 'NBA Coach of the Year' is the award; lost the most time at home refers to Max(homeLost)
SQL: SELECT T3.tmID FROM awards_coaches AS T1 INNER JOIN coaches AS T2 ON T1.coachID = T2.coachID INNER JOIN teams AS T3 ON T3.tmID = T2.tmID WHERE T1.year = 1994 AND T1.award = 'NBA Coach of the Year' GROUP BY T3.tmID ORDER BY SUM(T3.homeLost) DESC LIMIT 1

Database: university
Question: Give the student staff ratio of university ID 35.
SQL: SELECT student_staff_ratio FROM university_year WHERE university_id = 35

Database: books
Question: Write down the author's name of the book most recently published.
Evidence: author's name refers to author_name; book most recently published refers to Max(publication_date)
SQL: SELECT T3.author_name FROM book AS T1 INNER JOIN book_author AS T2 ON T1.book_id = T2.book_id INNER JOIN author AS T3 ON T3.author_id = T2.author_id ORDER BY T1.publication_date DESC LIMIT 1

Database: movie_3
Question: What are the last updated date for English film titles that were released in 2006?
Evidence: the last updated date refers to last_update; English is name of language; released in 2006 refers to release_year = 2006


SQL: SELECT DISTINCT T1.last_update FROM film AS T1 INNER JOIN `language` AS T2 ON T1.language_id = T2.language_id WHERE T2.`name` = 'English' AND T1.release_year = 2006

Database: university
Question: Calculate the difference between the total number of students and the number of international international students in Univeristy of Tokyo from 2011 to 2014.
Evidence: international students refers to DIVIDE(MULTIPLY(num_students, pct_international_students), 100); difference refers to SUBTRACT(SUM(num_students), SUM(DIVIDE(MULTIPLY(num_students, pct_international_students), 100))); in University of Tokyo refers to university_name = 'University of Tokyo'; from 2011 to 2014 refers to year BETWEEN 2011 AND 2014
SQL: SELECT SUM(T1.num_students) - SUM(CAST(T1.num_students * T1.pct_international_students AS REAL) / 100) FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T1.year BETWEEN 2011 AND 2014 AND T2.university_name = 'University of Tokyo'

Database: student_loan
Question: How many disabled students have zero absences?
Evidence: zero absences refers to month = 0;
SQL: SELECT COUNT(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 brand of the device used by the most users in the M23-26 user group?
Evidence: brand of the device refers to phone_brand; M23-26 user group refers to `group` = 'M23-26';
SQL: SELECT T.phone_brand FROM ( SELECT T2.phone_brand, COUNT(T1.device_id) AS num FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.`group` = 'M23-26' GROUP BY T2.phone_brand ) AS T ORDER BY T.num DESC LIMIT 1