Database: movie
Question: What is the percentage of the actors that showed up in the credit list of movie "Dawn of the Planet of the Apes" that were born after "1970/1/1"?
Evidence: movie "Dawn of the Planet of the Apes" refers to Title = 'Dawn of the Planet of the Apes'; born after "1970/1/1" refers to Date of Birth > '1970/1/1'; percentage = divide(count(ActorID where Date of Birth > '1970/1/1'), count(ActorID))*100%
SQL: SELECT CAST(SUM(CASE WHEN T3.`Date of Birth` > '1970-01-01' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T3.`Date of Birth`) FROM movie AS T1 INNER JOIN characters AS T2 ON T1.MovieID = T2.MovieID INNER JOIN actor AS T3 ON T3.ActorID = T2.ActorID WHERE T1.Title = 'Dawn of the Planet of the Apes'

Database: student_loan
Question: How many students have never been absent from school?
Evidence: have never been absent refers to `month` = 0;
SQL: SELECT COUNT(name) FROM longest_absense_from_school WHERE `month` = 0

Database: car_retails
Question: List out 3 customer numbers who have highest amount payment
Evidence: amount of payment refers to amount;
SQL: SELECT customerNumber FROM payments ORDER BY amount DESC LIMIT 3

Database: ice_hockey_draft
Question: Calculate the average weight in pounds of all players drafted by Arizona Coyotes.
Evidence: average weight in pounds = AVG(weight_in_lbs); weight in pounds refers to weight_in_lbs; players refers to PlayerName; drafted by Arizona Coyotes refers to overallby = 'Arizona Coyotes';
SQL: SELECT CAST(SUM(T1.weight_in_lbs) AS REAL) / COUNT(T2.ELITEID) FROM weight_info AS T1 INNER JOIN PlayerInfo AS T2 ON T1.weight_id = T2.weight WHERE T2.overallby = 'Arizona Coyotes'

Database: airline
Question: How many planes does Southwest Airlines Co. have?
Evidence: planes refers to TAIL_NUM; Southwest Airlines Co. refers to Description = 'Southwest Airlines Co.: WN';
SQL: SELECT COUNT(T3.TAIL_NUM) FROM ( SELECT T1.TAIL_NUM FROM Airlines AS T1 INNER JOIN `Air Carriers` AS T2 ON T1.OP_CARRIER_AIRLINE_ID = T2.Code WHERE T2.Description = 'Southwest Airlines Co.: WN' GROUP BY T1.TAIL_NUM ) T3

Database: codebase_comments
Question: What are the paths of solutions in repository "https://github.com/ecoffey/Bebop.git"
Evidence: path of solutions refers to Path; https://github.com/ecoffey/Bebop.git refers to Url; Url = 'https://github.com/ecoffey/Bebop.git';
SQL: SELECT DISTINCT T2.Path FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Url = 'https://github.com/ecoffey/Bebop.git'

Database: image_and_language
Question: Among the objects that have multiple relations, how many images whose captions for the prediction class ids are "on"?
Evidence: objects that have multiple relations refers to OBJ1_SAMPLE_ID ! = OBJ2_SAMPLE_ID; captions for the prediction class ids are "on" refers to PRED_CLASS = 'on'
SQL: SELECT COUNT(T2.PRED_CLASS_ID) FROM IMG_REL AS T1 INNER JOIN PRED_CLASSES AS T2 ON T1.PRED_CLASS_ID = T2.PRED_CLASS_ID WHERE T1.OBJ1_SAMPLE_ID != T1.OBJ2_SAMPLE_ID AND T2.PRED_CLASS = 'on'

Database: sales
Question: Find the number of customers handled by each of the sales people.
SQL: SELECT COUNT(CustomerID) FROM Sales GROUP BY SalesPersonID

Database: retails
Question: In 1997, how many orders were shipped via mail?
Evidence: 1997 refers to year(l_shipdate) = 1997; shipped via mail refers to l_shipmode = 'MAIL'
SQL: SELECT COUNT(l_orderkey) FROM lineitem WHERE STRFTIME('%Y', l_shipdate) = '1997' AND l_shipmode = 'MAIL'

Database: books
Question: What are the languages of the first two published books?
Evidence: first two published book refers to Min(publication_date); language refers to language_name
SQL: SELECT T2.language_name FROM book AS T1 INNER JOIN book_language AS T2 ON T1.language_id = T2.language_id ORDER BY T1.publication_date ASC LIMIT 2

Database: authors
Question: How many authors were associated with the Microsoft Research when paper number 1 was written?
Evidence: associated with the Microsoft Research refers to Affiliation contains 'Microsoft Research'; paper number 1 refers to PaperId = 1
SQL: SELECT COUNT(PaperId) FROM PaperAuthor WHERE Affiliation LIKE '%Microsoft Research%'

Database: movielens
Question: Among the most rated UK movies, how many of them has running time of less than 2?
Evidence: UK is a country
SQL: SELECT COUNT(T1.movieid) FROM u2base AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid WHERE T2.country = 'UK' AND T2.runningtime < 2 AND T1.rating = 5

Database: authors
Question: What is the full name of the journals that are published in the database papers whose topic is Sustainability?
Evidence: topic is Sustainability refers to Keyword = 'Sustainability'
SQL: SELECT T2.FullName FROM Paper AS T1 INNER JOIN Journal AS T2 ON T1.JournalId = T2.Id WHERE T1.Keyword = 'Sustainability'

Database: retail_complains
Question: How many clients who live in Kansas City provided a 1-star review?
Evidence: 1-star review refers stars = 1;
SQL: SELECT COUNT(T1.Stars) FROM reviews AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T2.city = 'Kansas City' AND T1.Stars = 1

Database: retail_world
Question: Calculate the average payment per product under confections category.
Evidence: under confections category refers to CategoryName = 'Confections';
SQL: SELECT SUM(T2.UnitPrice * T2.Quantity * (1 - T2.Discount)) / COUNT(T1.ProductID) FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID INNER JOIN Categories AS T3 ON T1.CategoryID = T3.CategoryID WHERE T3.CategoryName = 'Confections'

Database: student_loan
Question: Mention the status of payment of student 299.
Evidence: status of payment is mentioned in no_payment_due; bool = 'pos' means the student has payment due; bool = 'neg' means the student has no payment due; student299 is a name of student;
SQL: SELECT bool FROM no_payment_due WHERE name = 'student299'

Database: simpson_episodes
Question: What are the characters that were nominated for Primetime Emmy Award from 2009 to 2010 but did not win?
Evidence: nominated for Primetime Emmy Award but did not win refers to award_category = 'Primetime Emmy' and result = 'Nominee';  from 2009 to 2010 refers to year > = '2009' and  year < = '2010'
SQL: SELECT T2.character FROM Award AS T1 INNER JOIN Character_Award AS T2 ON T1.award_id = T2.award_id WHERE T1.award_category = 'Primetime Emmy' AND T1.year BETWEEN 2009 AND 2010 AND T1.result != 'Winner';

Database: talkingdata
Question: State the category of the label that represented the behavior category of app id 4955831798976240000.
Evidence: label that represented the behavior category refers to label_id;
SQL: SELECT T1.category FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T1.label_id = T2.label_id WHERE T2.app_id = 4955831798976240000

Database: shakespeare
Question: How many scenes can be found in "Twelfth Night, Or What You Will"?
Evidence: "Twelfth Night, Or What You Will" refers to LongTitle
SQL: SELECT COUNT(T2.Scene) AS cnt FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T1.LongTitle = 'Cymbeline, King of Britain'

Database: craftbeer
Question: Where in New York can you locate the brewery that makes the bitterest beer? List both the brewery's name and the name of the city.
Evidence: The more IBU, the more bitter the beer is, bitterest means highest IBU.
SQL: SELECT T2.name, T2.city FROM beers AS T1 INNER JOIN breweries AS T2 ON T1.brewery_id = T2.id WHERE T2.state = 'NY' ORDER BY T1.ibu DESC LIMIT 1

Database: simpson_episodes
Question: How many 7-star votes in star score did the episode Lost Verizon have?
Evidence: 7-stars vote refers to stars = 7; 'Lost Verizon' is the title of episode
SQL: SELECT COUNT(*) FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T1.title = 'Lost Verizon' AND T2.stars = 7;