Database: video_games
Question: List the name of all games published by 'Pioneer LDC'.
Evidence: name of games refers to game_name; 'Pioneer LDC' refers to publisher_name = 'Pioneer LDC';
SQL: SELECT T3.game_name FROM publisher AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.publisher_id INNER JOIN game AS T3 ON T2.game_id = T3.id WHERE T1.publisher_name = 'Pioneer LDC'

Database: simpson_episodes
Question: Please indicate which writer has an episode star score greater than 5 in 2009.
Evidence: writer refers to role = 'writer'; star score greater than 5 refers to stars > 5; in 2009 refers to year = 2009
SQL: SELECT T1.person FROM Award AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE SUBSTR(T1.year, 1, 4) = '2009' AND T1.role = 'writer' AND T2.votes > 5;

Database: movies_4
Question: Provide the genre of a movie title with a tagline of "A long time ago in a galaxy far, far away…".
Evidence: genre refers to genre_name; tagline of "A long time ago in a galaxy far, far away…" refers to tagline = 'A long time ago in a galaxy far, far away…'
SQL: SELECT T3.genre_name FROM movie AS T1 INNER JOIN movie_genres AS T2 ON T1.movie_id = T2.movie_id INNER JOIN genre AS T3 ON T3.genre_id = T2.genre_id WHERE T1.tagline = 'A long time ago in a galaxy far, far away...'

Database: social_media
Question: Show the text of the tweet with the highest klout from Connecticut.
Evidence: highest klout refers to Max(Klout); 'Connecticut' is the State
SQL: SELECT T1.text FROM twitter AS T1 INNER JOIN location AS T2 ON T2.LocationID = T1.LocationID WHERE T2.State = 'Connecticut' ORDER BY T1.Klout DESC LIMIT 1

Database: chicago_crime
Question: In the most populated ward, how many incidents of domestic violence were reported in a bar or tavern?
Evidence: the most populated refers to max(population); domestic violence refers to domestic = 'TRUE'; in a bar or tavern refers to location_description = 'BAR OR TAVERN'
SQL: SELECT COUNT(T2.report_no) FROM Ward AS T1 INNER JOIN Crime AS T2 ON T1.ward_no = T2.ward_no WHERE T2.domestic = 'TRUE' AND T2.location_description = 'BAR OR TAVERN' ORDER BY T1.Population DESC LIMIT 1

Database: food_inspection
Question: List down the owner's name with a zip code 94104.
Evidence: zip code 94104 refers to owner_zip = '94104';
SQL: SELECT DISTINCT owner_name FROM businesses WHERE owner_zip = '94104'

Database: movie_platform
Question: Please list the names of the top three movies in the number of likes related to the critic made by the user rating the movie.
Evidence: likes related to the critic made by the user rating the movie refers to critic_likes; top refers to Max(critic_likes);
SQL: SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.critic_likes DESC LIMIT 3

Database: movielens
Question: Please list the genre of the movies that are directed by the directors with the highest level of average revenue.
SQL: SELECT T2.genre FROM directors AS T1 INNER JOIN movies2directors AS T2 ON T1.directorid = T2.directorid WHERE T1.avg_revenue = 4

Database: retail_world
Question: List out the full name of employee who has birth day on "3/4/1955 12:00:00 AM".
Evidence: full name refers to FirstName, LastName; brith day refers to BirthDate
SQL: SELECT FirstName, LastName FROM Employees WHERE BirthDate = '1955-03-04 00:00:00'

Database: regional_sales
Question: Find the average yearly order by customer Weimei Corp for 2018, 2019 and 2020.
Evidence: "Weimei Corp" is the Customer Names; in 2018, 2019 and 2020 refers to SUBSTR (OrderDate, -2) IN ('18', '19', '20') : Average order = Divide (Count (OrderNumber), 3)
SQL: SELECT COUNT(T1.OrderNumber) / 3 FROM `Sales Orders` AS T1 INNER JOIN Customers AS T2 ON T2.CustomerID = T1._CustomerID WHERE (T1.OrderDate LIKE '%/%/18' AND T2.`Customer Names` = 'Weimei Corp') OR (T1.OrderDate LIKE '%/%/19' AND T2.`Customer Names` = 'Weimei Corp') OR (T1.OrderDate LIKE '%/%/20' AND T2.`Customer Names` = 'Weimei Corp')

Database: address
Question: Among the cities with area code 608, how many cities implement daylight savings?
Evidence: implement daylight savings refers to daylight_savings = 'Yes';
SQL: SELECT COUNT(T2.city) FROM area_code AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.area_code = 608 AND T2.daylight_savings = 'Yes'

Database: movie_platform
Question: How much higher is the average rating score of the movie "Innocence Unprotected" than the movie "When Will I Be Loved"?
Evidence: Innocence Unprotected' and 'When Will I Be Loved' are movie_title; Average rating score = Divide(Sum(rating_score), Count(rating_id));
SQL: SELECT SUM(CASE WHEN T2.movie_title = 'Innocence Unprotected' THEN T1.rating_score ELSE 0 END) / SUM(CASE WHEN T2.movie_title = 'Innocence Unprotected' THEN 1 ELSE 0 END) - SUM(CASE WHEN T2.movie_title = 'When Will I Be Loved' THEN T1.rating_score ELSE 0 END) / SUM(CASE WHEN T2.movie_title = 'When Will I Be Loved' THEN 1 ELSE 0 END) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id

Database: shipping
Question: How many trucks were manufactured in year 2009?
Evidence: manufactured in year 2009 refers to model_year = 2009
SQL: SELECT COUNT(truck_id) FROM truck WHERE model_year = 2009

Database: books
Question: What is the average number of pages of David Coward's books?
Evidence: number of pages refers to num_pages; average = Divide (Sum(num_pages), Count(book_id))
SQL: SELECT AVG(T1.num_pages) FROM book AS T1 INNER JOIN book_author AS T2 ON T1.book_id = T2.book_id INNER JOIN author AS T3 ON T3.author_id = T2.author_id WHERE T3.author_name = 'David Coward'

Database: software_company
Question: What is the average education level of customers from the place with the highest average income per month?
Evidence: place with the highest average income per month refers to GEOID where MAX(INCOME_K); average education level refers to AVG(EDUCATIONNUM);
SQL: SELECT AVG(T1.EDUCATIONNUM) FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID ORDER BY T2.INCOME_K DESC LIMIT 1

Database: restaurant
Question: In which regions are there no pizza restaurants?
Evidence: no pizza restaurants refers to food_type = 'pizza'
SQL: SELECT DISTINCT T2.region FROM generalinfo AS T1 INNER JOIN geographic AS T2 ON T1.city = T2.city WHERE T1.food_type = 'pizza' AND T2.region != 'unknown'

Database: retail_complains
Question: What is the full name of client whose email address is emily.garcia43@outlook.com?
Evidence: full name refers to first middle last
SQL: SELECT first, middle, last FROM client WHERE email = 'emily.garcia43@outlook.com'

Database: retail_complains
Question: What is the percentage of the complaint calls from Mr Mason Javen Lopez has got the consent provided by the customer?
Evidence: percentage = MULTIPLY(DIVIDE(SUM("Consumer consent provided?" = 'Consent provided'), COUNT(client_id)), 1.0); Mr refers to sex = 'Male'; consent provided by the customer refers to "Consumer consent provided?" = 'Consent provided';
SQL: SELECT CAST(SUM(CASE WHEN T2.`Consumer consent provided?` = 'Consent provided' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T2.`Consumer consent provided?`) FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T1.sex = 'Male' AND T1.first = 'Mason' AND T1.middle = 'Javen' AND T1.last = 'Lopez'