Database: disney
Question: Please list the release dates of all the movies in which Alan Tudyk is a voice actor.
Evidence: FALSE;
SQL: SELECT T2.release_date FROM `voice-actors` AS T1 INNER JOIN characters AS T2 ON T1.movie = T2.movie_title WHERE T1.`voice-actor` = 'Alan Tudyk'

Database: retail_world
Question: What is the Island Trading customer's complete address?
Evidence: Island Trading refers to CompanyName = 'Island Trading'; complete address = Address, City, Region, Country, PostalCode
SQL: SELECT Address, City, Region, Country, PostalCode FROM Customers WHERE CompanyName = 'Island Trading'

Database: menu
Question: How many dishes are there on the menu "Zentral Theater Terrace"?
Evidence: Zentral Theater Terrace is a name of menu;
SQL: SELECT SUM(CASE WHEN T3.name = 'Zentral Theater Terrace' THEN 1 ELSE 0 END) FROM MenuItem AS T1 INNER JOIN MenuPage AS T2 ON T1.menu_page_id = T2.id INNER JOIN Menu AS T3 ON T2.menu_id = T3.id

Database: food_inspection_2
Question: Give the address of the schools that passed the inspection in March 2010.
Evidence: school refers to facility_type = 'School'; pass refers to results = 'Pass'; in March 2010 refers to inspection_date like '2010-03%'
SQL: SELECT DISTINCT T1.address FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE strftime('%Y-%m', T2.inspection_date) = '2010-03' AND T2.results = 'Pass' AND T1.facility_type = 'School'

Database: retails
Question: List all the nations in Europe.
Evidence: nation refers to n_name; Europe refers to r_name = 'EUROPE'
SQL: SELECT T2.n_name FROM region AS T1 INNER JOIN nation AS T2 ON T1.r_regionkey = T2.n_regionkey WHERE T1.r_name = 'EUROPE'

Database: student_loan
Question: Does student348 have a due payment?
Evidence: payment due refers to bool = 'pos' means the student has payment due , bool = 'neg' means the student does not have payment due;
SQL: SELECT bool FROM no_payment_due WHERE name = 'student348'

Database: talkingdata
Question: Among the users who uses a vivo device, how many of them are female and under 30?
Evidence: vivo device refers to phone_brand = 'vivo'; female refers to gender = 'F'; under 30 refers to age < 30;
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.phone_brand = 'vivo' AND T1.age < 30

Database: citeseer
Question: For all words cited in paper ID 315017, state the other paper ID and class label which also cited those words.
SQL: SELECT T1.class_label, T2.word_cited_id FROM paper AS T1 INNER JOIN content AS T2 ON T1.paper_id = T2.paper_id WHERE T1.paper_id = 315017

Database: cs_semester
Question: What is the average gpa of Ogdon Zywicki's research assistants?
Evidence: research assistant refers to the student who serves for research where the abbreviation is RA; prof_id refers to professor’s ID; GPA is an abbreviated name of Grade Point Average where average = AVG(gpa);
SQL: SELECT SUM(T3.gpa) / COUNT(T1.student_id) FROM RA AS T1 INNER JOIN prof AS T2 ON T1.prof_id = T2.prof_id INNER JOIN student AS T3 ON T1.student_id = T3.student_id WHERE T2.first_name = 'Ogdon' AND T2.last_name = 'Zywicki'

Database: software_company
Question: What is the occupation and response of female customers within the number of inhabitants range of 20 to 25?
Evidence: female customers within the number of inhabitants range of 20 to 25 refer to SEX = 'Female' where INHABITANTS_K BETWEEN 20 AND 25;
SQL: SELECT DISTINCT T1.OCCUPATION, T2.RESPONSE FROM Customers AS T1 INNER JOIN Mailings1_2 AS T2 ON T1.ID = T2.REFID INNER JOIN Demog AS T3 ON T1.GEOID = T3.GEOID WHERE T1.SEX = 'Female' AND T3.INHABITANTS_K >= 20 AND T3.INHABITANTS_K <= 25

Database: retail_world
Question: Among the employees working as Sales Representatives, how many of them are located in the UK?
Evidence: Sales Representatives refers to Title = 'Sales Representative'; UK refers to Country = 'UK';
SQL: SELECT COUNT(Country) FROM Employees WHERE Title = 'Sales Representative' AND Country = 'UK'

Database: social_media
Question: From which city were more tweets posted, Bangkok or Chiang Mai?
Evidence: "Bangkok" and "Chiang Mai" are both City
SQL: SELECT SUM(CASE WHEN T2.City = 'Bangkok' THEN 1 ELSE 0 END) AS bNum , SUM(CASE WHEN T2.City = 'Chiang Mai' THEN 1 ELSE 0 END) AS cNum FROM twitter AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID WHERE T2.City IN ('Bangkok', 'Chiang Mai')

Database: olympics
Question: How many different events are there of Modern Pentathlon?
Evidence: Modern Pentathlon refers to sport_name = 'Modern Pentathlon';
SQL: SELECT COUNT(DISTINCT T2.event_name) FROM sport AS T1 INNER JOIN event AS T2 ON T1.id = T2.sport_id WHERE T1.sport_name = 'Modern Pentathlon'

Database: university
Question: What is the percentage of Harvard university's international students in 2011?
Evidence: Harvard university's refers to university_name = 'Harvard University'; in 2011 refers to year = 2011; percentage of Harvard university's international students refers to pct_international_students
SQL: SELECT T1.pct_international_students FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T1.year = 2011 AND T2.university_name = 'Harvard University'

Database: synthea
Question: List down the last name of patients who are allergic to dairy products.
Evidence: allergic to dairy products refers to allergies where DESCRIPTION = 'Allergy to dairy product';
SQL: SELECT DISTINCT T1.last FROM patients AS T1 INNER JOIN allergies AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Allergy to dairy product'

Database: public_review_platform
Question: Among the active businesses located at Goodyear, AZ, list the category and atrributes of business with a high review count.
Evidence: active business ID refers to active = 'true'; Goodyear is a city; AZ is a state; high review count refers to review_count = 'High'
SQL: SELECT T3.category_name, T5.attribute_name 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 INNER JOIN Business_Attributes AS T4 ON T1.business_id = T4.business_id INNER JOIN Attributes AS T5 ON T4.attribute_id = T5.attribute_id WHERE T1.review_count = 'High' AND T1.city = 'Goodyear' AND T1.state = 'AZ' AND T1.active = 'true'

Database: book_publishing_company
Question: Name all the authors for 'Sushi, Anyone?'.
Evidence: most year to date sales refers to MAX(ytd_sales); on contract refers to contract = 1; name of author = au_fname, au_lname
SQL: SELECT T3.au_fname, T3.au_lname FROM titles AS T1 INNER JOIN titleauthor AS T2 ON T1.title_id = T2.title_id INNER JOIN authors AS T3 ON T2.au_id = T3.au_id WHERE T1.title = 'Sushi, Anyone?'

Database: donor
Question: Which item provided to a project whose main subject area is Literacy & Language has the highest unit price?
Evidence: main subject area refers to primary_focus_area = 'Literacy & Language'; highest unit price refers to Max(item_unit_price);
SQL: SELECT T1.item_name FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T2.primary_focus_area = 'Literacy & Language' ORDER BY T1.item_unit_price DESC LIMIT 1

Database: retail_world
Question: Among the beverages, which product has the highest customer satisfaction?
Evidence: beverage refers to CategoryName = 'Beverages'; highest customer satisfaction refers to max(ReorderLevel)
SQL: SELECT T1.ProductName FROM Products AS T1 INNER JOIN Categories AS T2 ON T1.CategoryID = T2.CategoryID WHERE T2.CategoryName = 'Beverages' ORDER BY T1.ReorderLevel DESC LIMIT 1