Database: european_football_1
Question: For a game had a score of 1-8 in the year of 2011, what division was that game in? Give the full name of the division.
Evidence: 2011 refers to season; a score of 1-8 refers to FTHG = '1' and FTAG = '8';
SQL: SELECT T2.division, T2.name FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T1.season = 2011 AND T1.FTHG = 1 AND T1.FTAG = 8

Database: talkingdata
Question: Please list any three events that happened on the 1st of May 2016 that have the same latitude of 31.
Evidence: on the 1st of May 2016 refers to timestamp like '2016-05-01%';
SQL: SELECT event_id FROM events WHERE timestamp LIKE '2016-05-01%' AND latitude = 31 LIMIT 3

Database: talkingdata
Question: How many events in total have happened on all the vivo devices in the year 2016?
Evidence: vivo devices refers to phone_brand = 'vivo'; in the year 2016 refers to year(timestamp) = 2016;
SQL: SELECT COUNT(T1.event_id) FROM events AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.event_id = T2.device_id WHERE STRFTIME('%Y', T1.timestamp) = '2016' AND T2.phone_brand = 'vivo'

Database: synthea
Question: List out the stop date of the care plan of dead patients.
Evidence: stop date of the care plan refers to careplans.STOP; dead patients refers to deathdate is not null;
SQL: SELECT DISTINCT T1.STOP FROM careplans AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T2.deathdate IS NOT NULL AND T1.STOP IS NOT NULL

Database: cars
Question: How many of the cars from Japan weighed less than 3000?
Evidence: from Japan refers to country = 'Japan'; weighed less than 3000 refers to weight < 3000
SQL: SELECT COUNT(*) FROM price AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country INNER JOIN data AS T4 ON T4.ID = T1.ID WHERE T3.country = 'Japan' AND T4.weight < 3000

Database: video_games
Question: Calculate the difference in sales between the games released in 1990 and 2000.
Evidence: difference = SUBTRACT(SUM(num_sales WHERE release_year = 2000), SUM(num_sales WHERE release_year = 1990));
SQL: SELECT SUM(CASE WHEN T2.release_year = 2000 THEN T1.num_sales ELSE 0 END) - SUM(CASE WHEN T2.release_year = 1990 THEN T1.num_sales ELSE 0 END) FROM region_sales AS T1 INNER JOIN game_platform AS T2 ON T1.game_platform_id = T2.id

Database: movies_4
Question: What is the average number of crews for a movie?
Evidence: average number of crews = divide(count(person_id), COUNT(movie_id))
SQL: SELECT CAST(SUM(CD) AS REAL) / COUNT(movie_id) FROM ( SELECT movie_id, COUNT(person_id) AS CD FROM movie_crew GROUP BY movie_id )

Database: movielens
Question: What is the average number of casts of movies that are from the USA?
Evidence: USA is a country
SQL: SELECT AVG(T2.cast_num) FROM movies AS T1 INNER JOIN movies2actors AS T2 ON T1.movieid = T2.movieid WHERE T1.country = 'USA'

Database: address
Question: Give the name and the position of the cbsa officer from the area with the zip code 45503.
Evidence: position refers to latitude, longitude
SQL: SELECT T1.CBSA_name, T2.latitude, T2.longitude FROM CBSA AS T1 INNER JOIN zip_data AS T2 ON T1.CBSA = T2.CBSA WHERE T2.zip_code = 45503 GROUP BY T1.CBSA_name, T2.latitude, T2.longitude

Database: movie_3
Question: How many film categories are there?
SQL: SELECT COUNT(DISTINCT category_id) FROM category

Database: address
Question: Among the types of postal points in Saint Croix, what percentage of postal points is the post office?
Evidence: DIVIDE(COUNT(type = 'Post Office' ), COUNT(type)) as percentage where county = 'SAINT CROIX';
SQL: SELECT CAST(COUNT(CASE WHEN T2.type = 'Post Office' THEN T1.zip_code ELSE NULL END) AS REAL) * 100 / COUNT(T1.zip_code) FROM country AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.county = 'SAINT CROIX'

Database: music_platform_2
Question: What is the review with the title "Hosts bring the show down" for?
Evidence: "Hosts bring the show down" refers to title of review
SQL: SELECT title FROM podcasts WHERE podcast_id = ( SELECT podcast_id FROM reviews WHERE title = 'Hosts bring the show down' )

Database: bike_share_1
Question: What is the percentage of the trip were done by a subscriber?
Evidence: subscription_type = 'Subscriber'; DIVIDE(COUNT(id where subscription_type = 'Subscriber'), COUNT(id)) as percentage;
SQL: SELECT CAST(COUNT(subscription_type) AS REAL) * 100 / ( SELECT COUNT(subscription_type) FROM trip ) FROM trip WHERE subscription_type = 'Subscriber'

Database: movie_3
Question: What is the average number of actors acted in comedy movies?
Evidence: comedy is the name of a category; average number of actors refers to AVG(actor_id)
SQL: SELECT AVG(T1.actor_id) FROM film_actor 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 INNER JOIN actor AS T4 ON T4.actor_id = T1.actor_id WHERE T3.name = 'comedy'

Database: legislator
Question: State all the Facebook ID for current legislators under the democrat party.
SQL: SELECT T2.facebook_id FROM `current-terms` AS T1 INNER JOIN `social-media` AS T2 ON T1.bioguide = T2.bioguide WHERE T1.party = 'Democrat' GROUP BY T2.facebook_id

Database: movie_3
Question: List down the actors' full names who performed in "CHOCOLATE DUCK" film.
Evidence: "CHOCOLATE DUCK" is the title of film; full name refers to first_name, last_name
SQL: SELECT T3.first_name, T3.last_name FROM film_actor AS T1 INNER JOIN film AS T2 ON T1.film_id = T2.film_id INNER JOIN actor AS T3 ON T1.actor_id = T3.actor_id WHERE T2.title = 'CHOCOLATE DUCK'

Database: soccer_2016
Question: What is the city of M Chinnaswamy Stadium?
Evidence: city refers to City_Name; M Chinnaswamy Stadium refers to Venue_Name = 'M Chinnaswamy Stadium'
SQL: SELECT T1.City_Name FROM City AS T1 INNER JOIN Venue AS T2 ON T2.City_Id = T1.City_Id WHERE T2.Venue_Name = 'M Chinnaswamy Stadium'

Database: regional_sales
Question: Describe the product names delivered in 2021 for the customer "Sundial".
Evidence: delivered in 2021 refer to DeliveryDate LIKE '%/21'; 'Sundial' is the Customer Names
SQL: SELECT T FROM ( SELECT DISTINCT CASE  WHEN T2.DeliveryDate LIKE '%/%/21' AND T1.`Customer Names` = 'Sundial ' THEN T3.`Product Name` END AS T FROM Customers T1 INNER JOIN `Sales Orders` T2 ON T2._CustomerID = T1.CustomerID INNER JOIN Products T3 ON T3.ProductID = T2._ProductID ) WHERE T IS NOT NULL

Database: donor
Question: What payment method was used for Needed Resource Materials For My Students?
Evidence: Needed Resource Materials For My Students refer to title
SQL: SELECT T3.payment_method FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid INNER JOIN donations AS T3 ON T2.projectid = T3.projectid WHERE T1.title = 'Needed Resource Materials For My Students'

Database: donor
Question: What is the average unit price of AKJ Books items?
Evidence: AKJ Books items refers to vendor_name = 'AKJ Books'; average unit price refers to DIVIDE(sum(item_unit_price),count(resourceid))
SQL: SELECT SUM(item_unit_price) / SUM(item_quantity) FROM resources WHERE vendor_name = 'AKJ Books'

Database: retail_world
Question: Among the seafood products, which product have the highest total production of the production?
Evidence: seafood product refers to CategoryName = 'Seafood'; product refers to ProductID; highest total production refers to max(add(units in stock, units on order))
SQL: SELECT T1.ProductName FROM Products AS T1 INNER JOIN Categories AS T2 ON T1.CategoryID = T2.CategoryID WHERE T2.CategoryName = 'Seafood' ORDER BY T1.UnitsInStock + T1.UnitsOnOrder DESC LIMIT 1

Database: soccer_2016
Question: What type did match ID 336000 win?
Evidence: type of match won refers to Win_Type
SQL: SELECT T2.Win_Type FROM Match AS T1 INNER JOIN Win_By AS T2 ON T1.Win_Type = T2.Win_Id WHERE T1.Match_Id = 336000