Database: cs_semester
Question: Which student is more satisfied with the course Machine Learning Theory, Willie Rechert or Laughton Antonio?
Evidence: sat refers to student's satisfaction degree with the course; more satisfied refers to MAX(sat);
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 (T1.f_name = 'Laughton' OR T1.f_name = 'Willie') AND (T1.l_name = 'Antonio' OR T1.l_name = 'Rechert') AND T3.name = 'Machine Learning Theory' ORDER BY T2.sat DESC LIMIT 1

Database: address
Question: Among all the residential areas in Delaware, how many of them implement daylight saving?
Evidence: "Delaware" is a county; implement daylight savings refers to daylight_saving = 'Yes'
SQL: SELECT COUNT(T1.zip_code) FROM zip_data AS T1 INNER JOIN country AS T2 ON T1.zip_code = T2.zip_code WHERE T2.county = 'DELAWARE' AND T1.daylight_savings = 'Yes'

Database: superstore
Question: Which product did Phillina Ober buy?
Evidence: product refers to "Product Name"
SQL: SELECT DISTINCT T3.`Product Name` FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T2.`Product ID` WHERE T1.`Customer Name` = 'Phillina Ober'

Database: bike_share_1
Question: Which city is Townsend at 7th Station located and how many bikes could it hold?
Evidence: Townsend at 7th Station refers to city = 'Townsend at 7th Station'; number of bikes a station can hold refers to SUM(dock_count);
SQL: SELECT city, SUM(dock_count) FROM station WHERE name = 'Townsend at 7th'

Database: trains
Question: How many short cars are in the shape of hexagon?
Evidence: short cars refers to len = 'short'; in the shape of hexagon refers to shape = 'hexagon'
SQL: SELECT COUNT(id) FROM cars WHERE shape = 'hexagon' AND len = 'short'

Database: food_inspection_2
Question: What is the title of the employee involved in inspection ID 60332?
SQL: SELECT T1.title FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE T2.inspection_id = 60332

Database: retail_world
Question: How many territories are there?
SQL: SELECT COUNT(TerritoryID) FROM Territories

Database: authors
Question: How many papers were published in the journal "Concepts in Magnetic Resonance Part A"?
Evidence: journal "Concepts in Magnetic Resonance Part A" refers to FullName = 'Concepts in Magnetic Resonance Part A'
SQL: SELECT COUNT(T2.Id) FROM Journal AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.JournalId WHERE T1.FullName = 'Concepts in Magnetic Resonance Part A'

Database: soccer_2016
Question: What is the average winning margin of all the matches SC Ganguly has played in?
Evidence: SC Ganguly refers to Player_Name = 'SC Ganguly'; the average winning margin = divide(sum(Win_Margin), count(Match_Id)) where Player_Name = 'SC Ganguly'
SQL: SELECT CAST(SUM(T3.Win_Margin) AS REAL) / COUNT(*) FROM Player AS T1 INNER JOIN Player_Match AS T2 ON T1.Player_Id = T2.Player_Id INNER JOIN Match AS T3 ON T2.Match_Id = T3.Match_Id WHERE T1.Player_Name = 'SC Ganguly'

Database: movie_3
Question: To which country does the address '1386 Nakhon Sawan Boulevard' belong?
SQL: SELECT T1.country FROM country AS T1 INNER JOIN city AS T2 ON T1.country_id = T2.country_id INNER JOIN address AS T3 ON T2.city_id = T3.city_id WHERE T3.address = '1386 Nakhon Sawan Boulevard'

Database: olympics
Question: In Barcelona, how many Olympic games were held?
Evidence: Barcelona refers to city_name = 'Barcelona';
SQL: SELECT COUNT(T1.games_id) FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id WHERE T2.city_name = 'Barcelona'

Database: public_review_platform
Question: Identify the user who has been yelping since 2004. Is he or she an Yelp Elite member?
Evidence: has been yelping since 2004 refers to user_yelping_since_year = 2004
SQL: SELECT DISTINCT T2.user_id FROM Users AS T1 INNER JOIN Elite AS T2 ON T1.user_id = T2.user_id WHERE T1.user_yelping_since_year = 2004

Database: simpson_episodes
Question: How many people were not born in Connecticut, USA?
Evidence: not born in Connecticut, USA refers to birth_region ! = 'Connecticut' and birth_country ! = 'USA'
SQL: SELECT COUNT(name) FROM Person WHERE birth_region != 'Connecticut' AND birth_country != 'USA';

Database: law_episode
Question: How many times is the number of keywords in "Refuge: Part 1" episode than "Shield" episode?
Evidence: "Refuge: Part 1" episode refers to title = 'Refuge: Part 1'; "Shield" episode refers to title = 'Shield'; times = divide(count(keyword where title = 'Refuge: Part 1'), count(keyword where title = 'Shield'))
SQL: SELECT CAST(SUM(CASE WHEN T1.title = 'Refuge: Part 1' THEN 1 ELSE 0 END) AS REAL) / SUM(CASE WHEN T1.title = 'Shield' THEN 1 ELSE 0 END) FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id

Database: shakespeare
Question: In Shakespeare's works between 1600 to 1610, how many of these have a character as a "Third Servingman"?
Evidence: between 1600 to 1610 refers to DATE > = 1600 AND DATE < = 1610; "Third Servingman" refers to CharName = 'Third Servingman'
SQL: SELECT COUNT(DISTINCT T2.work_id) FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id INNER JOIN paragraphs AS T3 ON T2.id = T3.chapter_id INNER JOIN characters AS T4 ON T3.character_id = T4.id WHERE T1.DATE BETWEEN 1600 AND 1610 AND T4.CharName = 'Third Servingman'

Database: beer_factory
Question: List the brands of root beer produced by Dr Pepper Snapple Group and calculate their percentage of purchases between 2014 to 2016.
Evidence: brand of root beer refers to BrandName; produced by Dr Pepper Snapple Group refers to BreweryName = 'Dr Pepper Snapple Group'; percentage of purchases = MULTIPLY(DIVIDE(SUM(BrandID WHERE PurchaseDate > = '2014-01-01' AND PurchaseDate < = '2016-12-31'), COUNT(BrandID) WHERE BreweryName = 'Dr Pepper Snapple Group'), 1.0); between 2014 to 2016 refers to PurchaseDate > = '2014-01-01' AND PurchaseDate < = '2016-12-31;
SQL: SELECT T1.BrandName , CAST(SUM(CASE WHEN T2.PurchaseDate >= '2014-01-01' AND T2.PurchaseDate <= '2016-12-31' THEN 1 ELSE 0 END) AS REAL) / COUNT(T2.BrandID) AS purchase FROM rootbeerbrand AS T1 INNER JOIN rootbeer AS T2 ON T1.BrandID = T2.BrandID WHERE T1.BreweryName = 'Dr Pepper Snapple Group' GROUP BY T2.BrandID

Database: chicago_crime
Question: On average, how many community areas are there in a side?
Evidence: average = Divide(Count(ward_no), Count(side))
SQL: SELECT CAST(COUNT(T1.ward_no) AS REAL) / COUNT(DISTINCT T3.side) FROM Ward AS T1 INNER JOIN Crime AS T2 ON T2.ward_no = T1.ward_no INNER JOIN Community_Area AS T3 ON T3.community_area_no = T2.community_area_no

Database: trains
Question: How many trains are running west?
Evidence: west is a direction
SQL: SELECT COUNT(id) FROM trains WHERE direction = 'west'

Database: law_episode
Question: On what episode did Julia Roberts win the "Outstanding Guest Actress in a Drama Series" award during the 1999 Primetime Emmy Awards? Tell me her role.
Evidence: win refers to result = 'Winner'; the "Outstanding Guest Actress in a Drama Series" award refers to award = 'Outstanding Guest Actress in a Drama Series'; the 1999 refers to year = 1999; Primetime Emmy Awards refers to organization = 'Primetime Emmy Awards'
SQL: SELECT T3.episode_id, T2.role FROM Person AS T1 INNER JOIN Award AS T2 ON T1.person_id = T2.person_id INNER JOIN Episode AS T3 ON T2.episode_id = T3.episode_id WHERE T2.year = 1999 AND T2.award = 'Outstanding Guest Actress in a Drama Series' AND T2.organization = 'Primetime Emmy Awards' AND T1.name = 'Julia Roberts' AND T2.result = 'Nominee'