Database: address
Question: Among the postal points in Texas, provide the zip codes and cities of postal points which have total beneficiaries of above 10000.
Evidence: Texas is the name of the state, in which name = 'Texas'; total beneficiaries of above 10000 refer to total_beneficiaries > 10000;
SQL: SELECT T2.zip_code, T2.city FROM state AS T1 INNER JOIN zip_data AS T2 ON T1.abbreviation = T2.state WHERE T1.name = 'Texas' AND T2.total_beneficiaries > 10000

Database: software_company
Question: What is the average age of first 60,000 customers who sent a true response to the incentive mailing sent by the marketing department?
Evidence: RESPONSE = 'true'; AVG(age);
SQL: SELECT AVG(T1.age) FROM Customers AS T1 INNER JOIN Mailings1_2 AS T2 ON T1.ID = T2.REFID WHERE T2.RESPONSE = 'true'

Database: cs_semester
Question: Provide the registered courses' names by undergraduate students with GPA of 3.7 and above.
Evidence: Undergraduate students refers to type = 'UG'; GPA of 3.7 and above refers to gpa > 3.7;
SQL: SELECT DISTINCT T1.f_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.type = 'UG' AND T1.gpa > 3.7

Database: address
Question: What percentage of households are in "Coroyell" out of its state?
Evidence: DIVIDE(SUM(households where county = 'CORYELL'), SUM(households)) as percentage;
SQL: SELECT CAST(SUM(CASE WHEN T1.county = 'CORYELL' THEN T2.households ELSE 0 END) AS REAL) * 100 / SUM(T2.households) FROM country AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code

Database: language_corpus
Question: Which Wikipedia page number does the Catalan language's name, Acampada, appear on?
Evidence: Wikipedia page number refers to page; title = 'Acampada';
SQL: SELECT page FROM pages WHERE title = 'Acampada'

Database: donor
Question: How many donors from New Jersey have made a donation for an honoree?
Evidence: from New Jersey refers to donor_state = 'NJ'; for an honoree refers to for_honoree = 't';
SQL: SELECT COUNT(donationid) FROM donations WHERE for_honoree = 't' AND donor_state = 'NJ'

Database: movie_platform
Question: How much is the popularity of the movie that has the highest popularity between 1920 to 1929 and when did the movie received its first rating score of 1 from the users who were a paying subscriber when they rated the movie ?
Evidence: movie with highest popularity refers to MAX(movie_popularity); movie_release_year BETWEEN 1920 AND 1929; when the movie received its first rating score of 1 refers to oldest date in rating_timestamp_utc where rating score = 1; user was a paying subscriber when they rated the movie refers to user_has_payment_method = 1;
SQL: SELECT MAX(T2.movie_popularity), MIN(T1.rating_timestamp_utc) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year BETWEEN 1920 AND 1929 AND T1.rating_score = 1 AND T1.user_has_payment_method = 1

Database: movie_3
Question: What are the actors that have the same forename as Johnny? Please include in your answer the full names of these actors.
Evidence: forename means first_name; full name refers to first_name, last_name
SQL: SELECT first_name, last_name FROM actor WHERE first_name = 'Johnny'

Database: superstore
Question: Name the item ordered by Jonathan Doherty with the highest quantity in the East region.
Evidence: Jonathan Doherty is the "Customer Name"; highest quantity refers to MAX(Quantity); Region = 'East'
SQL: SELECT 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` = 'Jonathan Doherty' AND T2.Region = 'East' ORDER BY T1.Quantity DESC LIMIT 1

Database: college_completion
Question: Tell the number of 4-year public schools in UT whose graduation rate exceeds the average for the state.
Evidence: 4-year refers to level = '4-year'; public refers to control = 'Public'; UT refers to state_abbr = 'UT'; graduation rate exceeds the average for the state refers to awards_per_value > awards_per_state_value;
SQL: SELECT COUNT(DISTINCT T1.chronname) FROM institution_details AS T1 INNER JOIN state_sector_grads AS T2 ON T2.state = T1.state WHERE T2.state_abbr = 'UT' AND T1.level = '4-year' AND T1.control = 'Public' AND T1.awards_per_value > T1.awards_per_state_value

Database: books
Question: How many publishers have the word "book" in their name?
Evidence: publisher have the word 'book' refers to publisher_name LIKE '%book%'
SQL: SELECT COUNT(*) FROM publisher WHERE publisher_name LIKE '%book%'

Database: retail_world
Question: What is the country location of the employee who handled order id 10257?
SQL: SELECT T1.Country FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T2.OrderID = 10257

Database: movie_3
Question: Among the classic movies, how many movies have a rental rate of less than 1?
Evidence: classic movie refers to name = 'Classics'; rental rate of less than 1 refers to rental_rate < 1; movie refers to film_id
SQL: SELECT COUNT(T1.film_id) FROM film_category AS T1 INNER JOIN category AS T2 ON T1.category_id = T2.category_id INNER JOIN film AS T3 ON T1.film_id = T3.film_id WHERE T3.rental_rate < 1 AND T2.name = 'Classics'

Database: address
Question: Who is the CBSA officer of the post point in the area with the highest number of employees?
Evidence: CBSA officer refers to CBSA_name; the highest number of employees refers to MAX(employees);
SQL: SELECT T1.CBSA_name FROM CBSA AS T1 INNER JOIN zip_data AS T2 ON T1.CBSA = T2.CBSA WHERE T2.employees = ( SELECT MAX(employees) FROM zip_data )

Database: video_games
Question: How many games include the word 'Box' in their name?
Evidence: games include the word 'Box' in their name refers to game_name = '%Box%';
SQL: SELECT COUNT(*) FROM ( SELECT T.game_name FROM game AS T WHERE T.game_name LIKE '%Box%' )

Database: olympics
Question: Which city hosted the most games?
Evidence: Which city refers to city_name; the most games refer to MAX(COUNT(city_name));
SQL: SELECT T2.city_name FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id GROUP BY T2.city_name ORDER BY COUNT(T2.city_name) DESC LIMIT 1

Database: soccer_2016
Question: How many umpires are from South Africa?
Evidence: South Africa refers to Country_Name = 'South Africa'
SQL: SELECT SUM(CASE WHEN T1.Country_Name = 'South Africa' THEN 1 ELSE 0 END) FROM Country AS T1 INNER JOIN Umpire AS T2 ON T1.Country_ID = T2.Umpire_Country

Database: talkingdata
Question: How many users belong to "Financial Information" category?
SQL: SELECT COUNT(T1.app_id) FROM app_labels AS T1 INNER JOIN label_categories AS T2 ON T1.label_id = T2.label_id WHERE T2.category = 'Financial Information'

Database: books
Question: List all the books published by BBC Audiobooks.
Evidence: "BBC Audiobooks" refers to publisher_name; books refers to title
SQL: SELECT T1.title FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id WHERE T2.publisher_name = 'BBC Audiobooks'

Database: movie_3
Question: What are the special features for the film "Smoochy Control"?
Evidence: "SMOOCHY CONTROL" is the title of film
SQL: SELECT special_features FROM film WHERE title = 'SMOOCHY CONTROL'

Database: address
Question: Give the location coordinates of the city with area code 636.
Evidence: location coordinate refers to (latitude, longitude)
SQL: SELECT T2.latitude, T2.longitude FROM area_code AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.area_code = 636

Database: cars
Question: What are the miles per gallon of the most expensive car?
Evidence: miles per gallon refers to mpg; the most expensive refers to max(price)
SQL: SELECT T1.mpg FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID ORDER BY T2.price DESC LIMIT 1