Database: movies_4
Question: Give the names of the female cast in Movie No. 1865.
Evidence: female cast refers to gender = 'Female'; name of cast refers to person_name; Movie No. 1865 refers to movie_id = 1865
SQL: SELECT T2.person_name FROM movie_cast AS T1 INNER JOIN person AS T2 ON T1.person_id = T2.person_id INNER JOIN gender AS T3 ON T1.gender_id = T3.gender_id WHERE T1.movie_id = 1865 AND T3.gender = 'Female'

Database: chicago_crime
Question: Give the case number and coordinates of the places where child abduction is reported.
Evidence: "CHILD ABDUCTION" is the secondary_description; coordinates refers to latitude, longitude
SQL: SELECT T1.case_number, T1.latitude, T1.longitude FROM Crime AS T1 INNER JOIN IUCR AS T2 ON T2.iucr_no = T1.iucr_no WHERE T2.secondary_description = 'CHILD ABDUCTION'

Database: coinmarketcap
Question: List the price for Zetacoin on 13/11/1 and the next 7 consecutive days. What is the average price for these 7 days?
Evidence: on 1/11/13 and the next 7 consecutive days refers to DATE BETWEEN '2013-11-01' AND '2013-11-07'; average price refers to AVG(price); Zetacoin refers to name = 'Zetacoin'
SQL: SELECT T2.price FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T1.name = 'Zetacoin' AND T2.date BETWEEN '2013-11-01' AND '2013-11-07' UNION ALL SELECT AVG(T2.PRICE) FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T1.name = 'Zetacoin' AND T2.date BETWEEN '2013-11-01' AND '2013-11-07'

Database: movie_3
Question: Among the films that are released in 2006, how many of them are rated Adults Only in the Motion Picture Association Film Rating?
Evidence: released in 2006 refers to release_year = 2006; rated Adults Only refers to rating = 'NC-17'
SQL: SELECT COUNT(film_id) FROM film WHERE rating = 'NC-17' AND release_year = 2006

Database: shooting
Question: In which year has the greatest number of cases where Handgun was used as weapon?
Evidence: year refers to year(date); the greatest number of cases refers to max(count(case_number)); OS Spray was used as weapon refers to subject_weapon = 'OS Spray'
SQL: SELECT STRFTIME('%Y', date) FROM incidents WHERE subject_weapon = 'Handgun' GROUP BY STRFTIME('%Y', date) ORDER BY COUNT(case_number) DESC LIMIT 1

Database: address
Question: List all the locations of postal points with the area code "410".
Evidence: latitude and longitude coordinates can be used to identify the location; postal points refer to zip_code;
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 = 410

Database: retail_world
Question: List all the customer company names and cities located in Canada.
Evidence: located in Canada refers to Country = 'Canada'
SQL: SELECT CompanyName, City FROM Customers WHERE Country = 'Canada'

Database: books
Question: Identify the publisher of the book Girls' Night In.
Evidence: "Girls' Night In" is the title of the book; publisher is the 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 = 'Girls'' Night In'

Database: movie_3
Question: In films with a rental rate of 2.99, how many of the films are starred by Nina Soto?
Evidence: a rental rate of 2.99 refers to rental_rate = 2.99
SQL: SELECT COUNT(T1.film_id) FROM film_actor AS T1 INNER JOIN actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T1.film_id = T3.film_id WHERE T3.rental_rate = 2.99 AND T2.first_name = 'Nina' AND T2.last_name = 'Soto'

Database: disney
Question: What are the names of the characters voiced by Frank Welker?
Evidence: Frank Welker refers to voice-actor = 'Frank Welker';
SQL: SELECT character FROM `voice-actors` WHERE 'voice-actor' = 'Frank Welker'

Database: superstore
Question: Give the customer segment from the West region that orders the order ID CA-2011-108189.
Evidence: Region = 'West'
SQL: SELECT DISTINCT T2.Segment FROM west_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T1.Region = 'West' AND T1.`Order ID` = 'CA-2011-108189'

Database: simpson_episodes
Question: What is the number of votes for 10-star for the episode that has the keyword "reference to the fantastic four"?
Evidence: 10-star refers to stars = 10
SQL: SELECT T2.votes FROM Keyword AS T1 INNER JOIN Vote AS T2 ON T1.episode_id = T2.episode_id WHERE T2.stars = 10 AND T1.keyword = 'reference to the fantastic four';

Database: retail_complains
Question: How many stars did "Eagle Capital" received from Little Rock on 2013/4/4?
Evidence: Eagle Capital refers to Product = 'Eagle Capital'; Little Rock is a city; on 2013/4/4 refers to Date = '2013-04-04';
SQL: SELECT COUNT(T1.Stars) FROM reviews AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T1.Product = 'Eagle Capital' AND T2.city = 'Little Rock' AND T1.Date = '2013-04-04'

Database: software_company
Question: How many teenagers are working as Machine-op-inspct?
Evidence: teenager is a person aged between 13 and 19 years; OCCUPATION = 'Machine-op-inspct';
SQL: SELECT COUNT(ID) teenager_number FROM Customers WHERE OCCUPATION = 'Machine-op-inspct' AND age >= 13 AND age <= 19

Database: retail_world
Question: How many orders were shipped by "Speedy Express"?
Evidence: "Speedy Express" is the name of the shipping company; orders refer to OrderID;
SQL: SELECT COUNT(T1.OrderID) FROM Orders AS T1 INNER JOIN Shippers AS T2 ON T1.ShipVia = T2.ShipperID WHERE T2.CompanyName = 'Speedy Express'

Database: law_episode
Question: How many times was episode 20 of the Law and Order series nominated for the Primetime Emmy Awards in 1999?
Evidence: nominated refers to result = 'nominee'; the Law and Order series refers to series = 'Law and Order'; the Primetime Emmy Awards refers to organization = 'Primetime Emmy Awards'; in 1999 refers to year = 1999
SQL: SELECT COUNT(T2.award_id) FROM Episode AS T1 INNER JOIN Award AS T2 ON T1.episode_id = T2.episode_id WHERE T2.year = 1999 AND T2.result = 'Nominee' AND T1.episode = 20 AND T2.organization = 'Primetime Emmy Awards' AND T1.series = 'Law and Order'

Database: restaurant
Question: On which streets in the city of San Francisco are there restaurants with a review of 1.7?
Evidence: street refers to street_name; review of 1.7 refers to review = 1.7
SQL: SELECT T2.street_name FROM generalinfo AS T1 INNER JOIN location AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T1.city = 'san francisco' AND T1.review = 1.7

Database: legislator
Question: List the official full names and genders of legislators who have Collins as their last name.
Evidence: genders refers to gender_bio; Collins is a last_name
SQL: SELECT official_full_name, gender_bio FROM current WHERE last_name = 'Collins'

Database: music_tracker
Question: Please list all release titles whose tag is jazz in 2005.
Evidence: release titles refer to groupName; groupYear = 2005;
SQL: SELECT T1.groupName FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T1.groupYear = 2005 AND T2.tag LIKE 'jazz'

Database: language_corpus
Question: What is the average words of the 10 fewest words title?
Evidence: average words = avg(words); 10 fewest words refers to words > = 10
SQL: SELECT CAST(SUM(CASE WHEN words >= 10 THEN words ELSE 0 END) AS REAL) / SUM(CASE WHEN words >= 10 THEN 1 ELSE 0 END) FROM pages

Database: address
Question: In which county is the residential area with the highest average income per household located?
Evidence: highest average income per household refers to Max(avg_income_per_household)
SQL: SELECT T2.county FROM zip_data AS T1 INNER JOIN country AS T2 ON T1.zip_code = T2.zip_code WHERE T2.county = 'ARECIBO' GROUP BY T2.county ORDER BY T1.avg_income_per_household DESC LIMIT 1