Database: movielens
Question: Action movies are mostly directed by directors of which country?
SQL: SELECT T3.country FROM movies2directors AS T1 INNER JOIN directors AS T2 ON T1.directorid = T2.directorid INNER JOIN movies AS T3 ON T1.movieid = T3.movieid WHERE T1.genre = 'Action' GROUP BY T3.country ORDER BY COUNT(T3.country) DESC LIMIT 1

Database: software_company
Question: Give the level of education and occupation of customers ages from 20 to 35 with an income K of 2000 and below.
Evidence: customers ages from 20 to 35 refer to ID where age BETWEEN 20 AND 35; income K of 2000 and below refers to INCOME_K < 2000; level of education refers to EDUCATIONNUM;
SQL: SELECT T1.EDUCATIONNUM, T1.OCCUPATION FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID WHERE T2.INCOME_K < 2000 AND T1.age >= 20 AND T1.age <= 35

Database: video_games
Question: Give the game name of the game ID 44.
SQL: SELECT T.game_name FROM game AS T WHERE T.id = 44

Database: music_tracker
Question: Name the title of the top three releases with the highest number of downloads.
Evidence: title refers to groupName; the highest number of downloads refers to MAX(totalSnatched);
SQL: SELECT groupName FROM torrents ORDER BY totalSnatched DESC LIMIT 3

Database: sales
Question: Name the customers who received 'Touring Rim' as a free gift.
Evidence: name of the customer = FirstName, MiddleInitial, LastName; 'Touring Rim' is name of product;
SQL: SELECT DISTINCT T1.FirstName, T1.MiddleInitial, T1.LastName FROM Customers AS T1 INNER JOIN Sales AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN Products AS T3 ON T2.ProductID = T3.ProductID WHERE T3.Name = 'Touring Rim' AND T3.Price = 0

Database: professional_basketball
Question: Among the coaches who have served more than 2 NBA teams, during which coach's period of coaching, a team has the least numbers of games lost in the post-season games?
Evidence: served more than 2 NBA teams refers to count (tmID) > = 2; least number of game lost in post season refers to Min(post_losses)
SQL: SELECT coachID FROM coaches WHERE lgID = 'NBA' AND post_wins != 0 AND post_losses != 0 AND coachID IN ( SELECT coachID FROM coaches WHERE lgID = 'NBA' GROUP BY coachID HAVING COUNT(tmID) > 2 ) ORDER BY post_losses ASC LIMIT 1

Database: law_episode
Question: Which episode has the two keywords "nun" and "priest"?
Evidence: episode refers to title; the two keywords "nun" and "priest" refers to keyword = 'nun' or keyword = 'priest';
SQL: SELECT T1.title FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id WHERE T2.keyword IN ('nun', 'priest')

Database: bike_share_1
Question: How many bikes could Evelyn Park and Ride hold and how many users who started on that station are subscribers?
Evidence: number of bikes a station can hold refers to SUM(dock_count); Evelyn Park and Ride refers to name = 'Evelyn Park and Ride'; started on the station refers to start_station_name; subscribers refers to subscription_type = 'subscriber';
SQL: SELECT SUM(T2.dock_count), COUNT(T1.subscription_type) FROM trip AS T1 INNER JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T2.name = 'Evelyn Park and Ride' AND T1.start_station_name = T2.name AND T1.subscription_type = 'Subscriber'

Database: simpson_episodes
Question: How many episodes aired in the year 2009 have over 15% of voters giving 10 stars in star score?
Evidence: aired in the year 2009 refers to air_date like '2009%'; 10 stars in star score refers to stars = 10; over 15% of voters refers to Votes.percent > 15
SQL: SELECT COUNT(*) FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE SUBSTR(T1.air_date, 1, 4) = '2009' AND T2.stars = 10 AND T2.percent > 15;

Database: movie_3
Question: What is the category of the film Agent Truman?
Evidence: 'Agent Truman' is a title of a film; category refers to name
SQL: SELECT T3.name FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T2.category_id = T3.category_id WHERE T1.title = 'AGENT TRUMAN'

Database: language_corpus
Question: Which of these pages have more words, the page titled "Afluent" or "Asclepi"?
Evidence: COUNT(words where title = 'Afluent')> COUNT(words where title = 'Asclepi')
SQL: SELECT CASE WHEN ( SELECT words FROM pages WHERE title = 'Asclepi' ) > ( SELECT words FROM pages WHERE title = 'Afluent' ) THEN 'Asclepi' ELSE 'Afluent' END

Database: retail_world
Question: How many days was the fastest shipping of Berglunds snabbkp's order?
Evidence: Berglunds snabbkp is the CompanyName; fastest shipping = Min(Subtract(ShippedDate, OrderDate))
SQL: SELECT datediff(T2.ShippedDate, T2.OrderDate) FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.CompanyName = 'Berglunds snabbkp' ORDER BY datediff(T2.ShippedDate, T2.OrderDate) LIMIT 1

Database: cookbook
Question: List all the ingredients of Apricot Yogurt Parfaits.
Evidence: Apricot Yogurt Parfaits refers to title
SQL: SELECT T3.name, T3.category FROM Recipe AS T1 INNER JOIN Quantity AS T2 ON T1.recipe_id = T2.recipe_id INNER JOIN Ingredient AS T3 ON T3.ingredient_id = T2.ingredient_id WHERE T1.title = 'Apricot Yogurt Parfaits'

Database: public_review_platform
Question: How many Yelp_Businesses in Scottsdale have received positive comments in the Elitestar rating?
Evidence: Scottsdale refers to city = 'Scottsdale'; positive comments refers to stars > 3; Elitestar rating refers to stars;
SQL: SELECT COUNT(business_id) FROM Business WHERE city LIKE 'Scottsdale' AND stars > 3

Database: public_review_platform
Question: Count the active businesses that has an attribute of caters with low review count.
Evidence: active businesses refers to active = 'true'; attribute of caters refers to attribute_name = 'Caters'
SQL: SELECT COUNT(T1.business_id) FROM Business AS T1 INNER JOIN Business_Attributes AS T2 ON T1.business_id = T2.business_id INNER JOIN Attributes AS T3 ON T2.attribute_id = T3.attribute_id WHERE T3.attribute_name LIKE 'Caters' AND T1.review_count LIKE 'Low' AND T1.active LIKE 'TRUE'

Database: authors
Question: Provide the title of the latest publication published by it's author 'Zuliang Du'.
Evidence: 'Zuliang Du' is the name of paper author; latest publication refers to MAX(Year)
SQL: SELECT T2.Title FROM PaperAuthor AS T1 INNER JOIN Paper AS T2 ON T1.PaperId = T2.Id WHERE T1.Name = 'Zuliang Du' ORDER BY T2.Year DESC LIMIT 1

Database: retail_world
Question: What is the average salary of the employees who takes charge of the sales of over 4 territories?
Evidence: average salary = DIVIDE(SUM(Salary), COUNT(EmployeeID)); employees who takes charge of over 4 territories refers to EmployeeID WHERE COUNT(TerritoryID) > 4;
SQL: SELECT AVG(T1.Salary) FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID GROUP BY T1.EmployeeID HAVING COUNT(T2.TerritoryID) > 4

Database: simpson_episodes
Question: What's the rating of the episode in which Dan Castellaneta won the Outstanding Voice-Over Performance award in 2009?
Evidence: "Dan Castellaneta" is the person;  2009 is year;  won refers result = 'Winner'
SQL: SELECT T2.rating FROM Award AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE T1.award = 'Outstanding Voice-Over Performance' AND SUBSTR(T1.year, 1, 4) = '2009' AND T1.person = 'Dan Castellaneta';

Database: donor
Question: State the short description for the project which got the donation at 14:44:29 on 2012/9/6.
Evidence: donation at 14:44:29 on 2012/9/6 refers to donation_timestamp = '2012/9/6 14:44:29';
SQL: SELECT T1.short_description FROM essays AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T2.donation_timestamp LIKE '2012-09-06 14:44:29'