Database: menu
Question: State the full height and width for menu called "El Fuerte Del Palmar".
Evidence: width refers to full_width; El Fuerte Del Palmar is a name of menu;
SQL: SELECT T1.full_height, T1.full_width FROM MenuPage AS T1 INNER JOIN Menu AS T2 ON T2.id = T1.menu_id WHERE T2.name = 'El Fuerte Del Palmar'

Database: sales
Question: Identify the name of the sales person with employee ID 7.
Evidence: name of the sales person = FirstName, MiddleInitial, LastName;
SQL: SELECT FirstName, MiddleInitial, LastName FROM Employees WHERE EmployeeID = 7

Database: movie
Question: Give the biography of the actor who played "Michael Moscovitz".
Evidence: "Michael Moscovitz" refers to Character Name = 'Michael Moscovitz'
SQL: SELECT T2.Biography FROM characters AS T1 INNER JOIN actor AS T2 ON T1.ActorID = T2.ActorID WHERE T1.`Character Name` = 'Michael Moscovitz'

Database: restaurant
Question: Which restaurant on the street Alameda de las Pulgas in the city of Menlo Park is the worst rated?
Evidence: restaurant refers to label; street Alameda de las Pulgas refers to street_name = 'avenida de las pulgas'; the worst rated refers to min(review)
SQL: SELECT T2.label FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T1.street_name = 'avenida de las pulgas' AND T2.city = 'menlo park' ORDER BY review LIMIT 1

Database: authors
Question: How many papers were presented at 'ECSQARU' in 2003?
Evidence: Papers refers to Paper.Id; ECSQARU is the ShortName of the conference; 2003 refers to Year = '2003'
SQL: SELECT COUNT(T1.Id) FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T2.ShortName = 'ECSQARU' AND T1.Year = '2003'

Database: address
Question: What is the elevation of the city belonging to Hampden, Massachusetts?
Evidence: the county of Hampden is located in the state of Massachusetts.
SQL: SELECT T3.elevation FROM state AS T1 INNER JOIN country AS T2 ON T1.abbreviation = T2.state INNER JOIN zip_data AS T3 ON T2.zip_code = T3.zip_code WHERE T1.name = 'Massachusetts' AND T2.county = 'HAMPDEN' GROUP BY T3.elevation

Database: superstore
Question: What is the name of the product that Aimee Bixby bought?
Evidence: name of the product refers to "Product Name"
SQL: SELECT DISTINCT T3.`Product Name` FROM east_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T1.`Product ID` WHERE T2.`Customer Name` = 'Aimee Bixby'

Database: professional_basketball
Question: Please list the name of the coach who has served more than 2 NBA teams.
Evidence: "NBA" is the lgID; server more than 2 teams refers to Count(tmID) = 2
SQL: SELECT coachID FROM coaches GROUP BY coachID HAVING COUNT(DISTINCT tmID) > 2

Database: books
Question: What is the name of the publisher of the book "The Illuminati"?
Evidence: "The Illuminati" is the title of the book; name of publisher refers to publisher_name
SQL: SELECT T2.publisher_name FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id WHERE T1.title = 'The Illuminati'

Database: talkingdata
Question: Please list the categories of the app users who are not active when event no.2 happened.
Evidence: not active refers to is_active = 0; event no. refers to event_id; event_id = 2;
SQL: SELECT DISTINCT T1.category FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T1.label_id = T2.label_id INNER JOIN app_events AS T3 ON T2.app_id = T3.app_id WHERE T3.event_id = 2 AND T3.is_active = 0

Database: world
Question: How many countries have no GNP?
Evidence: no GNP refers to GNP = 0;
SQL: SELECT COUNT(*) FROM Country WHERE GNP = 0

Database: university
Question: Between 2011 to 2016, in which countries can you find the universities where at least 50% of its students are international students?
Evidence: Between 2011 to 2016 refers to year BETWEEN 2011 AND 2016; at least 50% of its students are international students refers to pct_international_students > 50; which country refers to country_name
SQL: SELECT DISTINCT T3.country_name FROM university AS T1 INNER JOIN university_year AS T2 ON T1.id = T2.university_id INNER JOIN country AS T3 ON T3.id = T1.country_id WHERE T2.pct_international_students > 50 AND T2.year BETWEEN 2011 AND 2016

Database: authors
Question: In how many papers and in what years was the International Conference on Database Theory published?
Evidence: the International Conference on Database Theory refers to FullName = 'International Conference on Database Theory'; published refers to year ! = 0
SQL: SELECT COUNT(T1.Id) AS PAPER, COUNT(DISTINCT T1.Year) AS YEARS FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE year != 0 AND T2.FullName = 'International Conference on Database Theory'

Database: student_loan
Question: List all students that have been absent for 6 months.
Evidence: absent for 6 months `month` = 6;
SQL: SELECT name FROM longest_absense_from_school WHERE `month` = 6

Database: soccer_2016
Question: How many times does M Chinnaswamy Stadium host games than Maharashtra Cricket Association Stadium?
Evidence: M Chinnaswamy Stadium refers to Venue_Name = 'M Chinnaswamy Stadium'; Maharashtra Cricket Association Stadium refers to Venue_Name = 'Maharashtra Cricket Association Stadium'; how many times = divide(count(Match_Id where Venue_Name = 'M Chinnaswamy Stadium'), count(Match_Id where Venue_Name = 'Maharashtra Cricket Association Stadium'))
SQL: SELECT SUM(CASE WHEN T2.Venue_Name = 'M Chinnaswamy Stadium' THEN 1 ELSE 0 END) - SUM(CASE WHEN T2.Venue_Name = 'Maharashtra Cricket Association Stadium' THEN 1 ELSE 0 END) FROM `Match` AS T1 INNER JOIN Venue AS T2 ON T1.Venue_Id = T2.Venue_Id

Database: public_review_platform
Question: What business category is the Yelp business which got the most 5 star reviews in?
Evidence: business category refers to category_name; most 5 star reviews refers to MAX(COUNT(category_name WHERE star_reviews = 5));
SQL: SELECT T1.category_name FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id INNER JOIN Business AS T3 ON T2.business_id = T3.business_id INNER JOIN Reviews AS T4 ON T3.business_id = T4.business_id WHERE T4.review_stars = 5 GROUP BY T1.category_name ORDER BY COUNT(T1.category_name) DESC LIMIT 1

Database: retail_world
Question: How many orders were shipped to GREAL via United Package?
Evidence: GREAL refers to CustomerID = 'GREAL'; 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 T1.CustomerID = 'GREAL' AND T2.CompanyName = 'United Package'

Database: authors
Question: Which year did the "Internet, Multimedia Systems and Applications" conference publish the most papers?
Evidence: 'Internet, Multimedia Systems and Applications' is the FullName of paper; published the most papers refers to MAX(COUNT(year))
SQL: SELECT T2.Year FROM Conference AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.ConferenceId WHERE T1.FullName = 'Internet, Multimedia Systems and Applications' GROUP BY T2.Year ORDER BY COUNT(T2.Id) DESC LIMIT 1

Database: computer_student
Question: List the person IDs and course levels of the affiliated professors in faculty.
Evidence: person IDs refers to person.p_id; affiliated professors in faculty refers to professor = 1 and hasPosition = 'Faculty_aff'
SQL: SELECT T1.p_id, T3.courseLevel FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T1.hasPosition = 'Faculty_aff'

Database: menu
Question: Write down the top ten menus with the highest dish count.
Evidence: highest dish count refers to MAX(dish_count);
SQL: SELECT name FROM Menu GROUP BY name ORDER BY dish_count DESC LIMIT 10