Database: restaurant
Question: How many restaurants can you find in Concord?
Evidence: Concord refers to city = 'concord'
SQL: SELECT COUNT(id_restaurant) FROM location WHERE city = 'concord'

Database: soccer_2016
Question: Who was the man of the series in 2013? Give the full name.
Evidence: full name refers to Player_Name; in 2013 refers to Season_Year = 2013
SQL: SELECT T2.Player_Name FROM Season AS T1 INNER JOIN Player AS T2 ON T1.Man_of_the_Series = T2.Player_Id WHERE T1.Season_Year = 2013

Database: chicago_crime
Question: Who is the person responsible for the crime cases in Central Chicago?
Evidence: the person responsible for the crime cases refers to commander; Central Chicago refers to district_name = 'Central'
SQL: SELECT commander FROM District WHERE district_name = 'Central'

Database: shipping
Question: What was the maximum weight of the shipment carried to Boston? Name the customer of that shipment.
Evidence: "Boston" is the city_name; maximum weight refers to Max(weight); customer refers to cust_name
SQL: SELECT T1.weight, T2.cust_name FROM shipment AS T1 INNER JOIN customer AS T2 ON T1.cust_id = T2.cust_id INNER JOIN city AS T3 ON T3.city_id = T1.city_id WHERE T3.city_name = 'Boston' ORDER BY T1.weight DESC LIMIT 1

Database: world_development_indicators
Question: How many countries have a latest population census in 2011? Indicate their full names.
Evidence: have a latest population census in 2011 refers to LatestPopulationCensus = '2011'; full name refers to LongName
SQL: SELECT COUNT(LongName) FROM country WHERE LatestPopulationCensus = '2011' UNION ALL SELECT LongName FROM country WHERE LatestPopulationCensus = '2011'

Database: chicago_crime
Question: Find the ward office's address and phone number of the ward where the most crimes without arrest occurred.
Evidence: the most crime without arrest refers to Max(Count(arrest = 'FALSE')); phone number refers to ward_office_phone; address refers to ward_office_address
SQL: SELECT T2.ward_office_address, T2.ward_office_phone FROM Crime AS T1 INNER JOIN Ward AS T2 ON T2.ward_no = T1.ward_no WHERE T1.arrest = 'FALSE' GROUP BY T2.ward_office_address, T2.ward_office_phone ORDER BY COUNT(T1.arrest) DESC LIMIT 1

Database: movie_platform
Question: What is the average popularity of each movie that was directed by Christopher Nolan? Indicate which movie directed by him has received the highest number of 5 rating scores.
Evidence: 5 rating scores refer to rating_score; Christopher Nolan refer to director_name; average popularity of each movie refer to AVG(movie_popularity where director_name = 'Christopher Nolan')
SQL: SELECT AVG(T2.movie_popularity) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.director_name = 'Christopher Nolan'

Database: beer_factory
Question: Please list the dates on which a male customer has purchased more than 3 root beers.
Evidence: dates of purchase refers to TransactionDate; male customer refers to Gender = 'M'; purchased more than 3 root beers refers to COUNT(CustomerID) > 3;
SQL: SELECT T2.TransactionDate FROM customers AS T1 INNER JOIN `transaction` AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Gender = 'M' GROUP BY T2.TransactionDate HAVING COUNT(T2.CustomerID) > 3

Database: world_development_indicators
Question: Please list the countries in Latin America & Caribbean with a note on the series code SM.POP.TOTL.
Evidence: Countries refer to the ShortName; Latin America & Caribbean is the name of the region
SQL: SELECT T1.SHORTNAME, T2.Description FROM Country AS T1 INNER JOIN CountryNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T1.Region = 'Latin America & Caribbean' AND T2.Seriescode = 'SM.POP.TOTL'

Database: address
Question: What is the average household income in the city known as "Danzig"?
Evidence: average household income refers to avg_income_per_household; city known as "Danzig" refers to bad_alias = 'Danzig';
SQL: SELECT T2.avg_income_per_household FROM avoid AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.bad_alias = 'Danzig'

Database: computer_student
Question: Among the students being advised by Advisor 5, how many students are in the 5th year?
Evidence: Advisor 5 refers to p_id_dummy = 5; are in the 5th year refers to yearsInProgram = 'Year_5'
SQL: SELECT COUNT(*) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 5 AND T2.student = 1 AND T2.yearsInProgram = 'Year_5'

Database: synthea
Question: What is the most common condition among the patients who received influenza seasonal injectable preservative free immunization?
Evidence: the most common condition refers to MAX(DESCRIPTION) from conditions; patients who received influenza seasonal injectable preservative free immunization refer to PATIENT where DESCRIPTION = 'Influenza seasonal injectable preservative free' from immunizations;
SQL: SELECT T2.DESCRIPTION FROM immunizations AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT WHERE T1.DESCRIPTION = 'Influenza  seasonal  injectable  preservative free' GROUP BY T2.DESCRIPTION ORDER BY COUNT(T2.DESCRIPTION) DESC LIMIT 1

Database: menu
Question: Where is the place that menu with ID 12472 was created for?
Evidence: place refers to location;
SQL: SELECT location FROM Menu WHERE id = 12472

Database: sales
Question: List down product names of free gifts.
Evidence: free gifts refers to Price = 0;
SQL: SELECT Name FROM Products WHERE Price = 0

Database: books
Question: Calculate the total price of books ordered by customer named Lucas Wyldbore.
Evidence: total price refers to Sum(price); full name is composed of first name, last name
SQL: SELECT SUM(T1.price) FROM order_line AS T1 INNER JOIN cust_order AS T2 ON T2.order_id = T1.order_id INNER JOIN customer AS T3 ON T3.customer_id = T2.customer_id WHERE T3.first_name = 'Lucas' AND T3.last_name = 'Wyldbore'

Database: regional_sales
Question: Which regions have online sales channels that have the most discounts?
Evidence: most discount refers to Max(Discount Applied)
SQL: SELECT T2.Region FROM `Sales Orders` AS T1 INNER JOIN `Sales Team` AS T2 ON T2.SalesTeamID = T1._SalesTeamID WHERE T1.`Sales Channel` = 'Online' ORDER BY T1.`Discount Applied` DESC LIMIT 1

Database: legislator
Question: How many districts did John Conyers, Jr. serve in total?
SQL: SELECT COUNT(T3.district) FROM ( SELECT T2.district FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.official_full_name = 'John Conyers, Jr.' GROUP BY T2.district ) T3

Database: cookbook
Question: How many calories on average does a recipe that comes from "Produce for Better Health Foundation and 5 a Day" contain?
Evidence: Produce for Better Health Foundation and 5 a Day is a source of recipe; calculation = DIVIDE(SUM(calories), COUNT(recipe_id))
SQL: SELECT AVG(T2.calories) FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id WHERE T1.source = 'Produce for Better Health Foundation and 5 a Day'

Database: disney
Question: Calculate the percentage of directors whose films grossed over $100 million.
Evidence: DIVIDE(COUNT(director where total_gross > 100000000), COUNT(director)) as percentage;
SQL: SELECT CAST(COUNT(DISTINCT CASE WHEN CAST(REPLACE(trim(T1.total_gross, '$'), ',', '') AS REAL) > 100000000 THEN T3.director ELSE NULL END) AS REAL) * 100 / COUNT(DISTINCT T3.director) FROM movies_total_gross AS T1 INNER JOIN characters AS T2 ON T1.movie_title = T2.movie_title INNER JOIN director AS T3 ON T1.movie_title = T3.name

Database: movie
Question: Show the birth city of the actor who played "Gabriel Martin".
Evidence: "Gabriel Martin" refers to Character Name = 'Gabriel Martin'
SQL: SELECT T2.`Birth City` FROM characters AS T1 INNER JOIN actor AS T2 ON T1.ActorID = T2.ActorID WHERE T1.`Character Name` = 'Gabriel Martin'