Database: olympics
Question: How many 24 years old competitors competed in Men's Basketball?
Evidence: 24 years old competitors refer to id where age = 24; Men's Basketball refers to event_name = 'Basketball Men''s Basketball';
SQL: SELECT COUNT(T2.person_id) FROM competitor_event AS T1 INNER JOIN games_competitor AS T2 ON T1.competitor_id = T2.id INNER JOIN event AS T3 ON T1.event_id = T3.id WHERE T3.event_name LIKE 'Basketball Men%s Basketball' AND T2.age = 24

Database: regional_sales
Question: How many orders have order date in 5/31/2018?
Evidence: orders refer to OrderNumber;
SQL: SELECT SUM(IIF(OrderDate = '5/31/18', 1, 0)) FROM `Sales Orders`

Database: simpson_episodes
Question: Based on the credits, state how many roles were played in the 5th episode of simpson 20.
Evidence: 5th episode refers to episode = 5
SQL: SELECT COUNT(DISTINCT T2.role) FROM Episode AS T1 INNER JOIN Credit AS T2 ON T1.episode_id = T2.episode_id WHERE T1.episode = 5;

Database: disney
Question: Provide the directors and MPAA ratings of the musical movies released in 1993.
Evidence: Musical movies refer to genre = 'Musical'; released in 1993 refers to substr(release_date, length(release_date) - 3, length(release_date)) = '1993';
SQL: SELECT T2.director, T1.MPAA_rating FROM movies_total_gross AS T1 INNER JOIN director AS T2 ON T1.movie_title = T2.name WHERE T1.genre = 'Musical' AND SUBSTR(T1.release_date, LENGTH(T1.release_date) - 3, LENGTH(T1.release_date)) = '1993'

Database: shipping
Question: What is the maximum weight being transported to New York during a single shipment?
Evidence: "New York" is the city_name; maximum weight refers to Max(weight)
SQL: SELECT MAX(T1.weight) FROM shipment AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id WHERE T2.city_name = 'New York'

Database: soccer_2016
Question: On average, how many players from each country bat with their right hand?
Evidence: bat with their right hand refers to Batting_hand = 'Right-hand bat'; average = divide(count(Player_Id) when Batting_hand = 'Right-hand bat', count(Country_Name))
SQL: SELECT CAST(SUM(CASE WHEN T1.Batting_hand = 'Right-hand bat' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T2.Country_Name) FROM Batting_Style AS T1 INNER JOIN Player AS T2 ON T1.Batting_id = T2.Batting_hand

Database: public_review_platform
Question: Calculate the percentage of business with attribute name of "Accepts Credit Cards".
Evidence: percentage refers to DIVIDE(COUNT(attribute_name = 'Accepts Credit Cards'), COUNT(business_id))*100%
SQL: SELECT CAST(SUM(CASE WHEN T1.attribute_name = 'Accepts Credit Cards' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.attribute_name) FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id

Database: movie_3
Question: What is the name of the client who has the largest quantity of rented material without returning it?
Evidence: name refers to first_name, last_name; without returning a rented material refers to return_date is null
SQL: SELECT T.first_name FROM ( SELECT T2.first_name, COUNT(T1.rental_date) AS num FROM rental AS T1 INNER JOIN customer AS T2 ON T1.customer_id = T2.customer_id GROUP BY T2.first_name ) AS T ORDER BY T.num DESC LIMIT 1

Database: movies_4
Question: State the genre of the movie title with a runtime of only 14 minutes.
Evidence: genre refers to genre_name; runtime of only 14 minutes refers to runtime = 14
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 T2.genre_id = T3.genre_id WHERE T1.runtime = 14

Database: student_loan
Question: Find the average number of absences for each student.
Evidence: average refers to DIVIDE(SUM(month), COUNT(name))
SQL: SELECT AVG(month) FROM longest_absense_from_school

Database: authors
Question: What are the keywords for the paper which was published on "Modeling Identification and Control" in 1994?
Evidence: 'Modeling Identification and Control' is the FullName of the journal; 1994 refers to Year = '1994'; if the year is "0", it means this paper is preprint, or not published
SQL: SELECT T2.Keyword FROM Journal AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.JournalId WHERE T1.FullName = 'Modeling Identification and Control' AND T2.Year = 1994

Database: retail_world
Question: Who was taking charge of orders from Morristown?
Evidence: Morristown refers to TerritoryDescription = 'Morristown'
SQL: SELECT T1.FirstName, T1.LastName FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID INNER JOIN Territories AS T3 ON T2.TerritoryID = T3.TerritoryID WHERE T3.TerritoryDescription = 'Morristown'

Database: movies_4
Question: List the names of camera supervisors in the crew.
Evidence: names refers to person_name; camera supervisors refers to job = 'Camera Supervisor';
SQL: SELECT T1.person_name FROM person AS T1 INNER JOIN movie_crew AS T2 ON T1.person_id = T2.person_id WHERE T2.job = 'Camera Supervisor'

Database: public_review_platform
Question: What city does the business have a business hour from 10 am to 12 pm on Sunday?
Evidence: 10 am refers to opening_time = '10AM'; 12 pm refers to closing_time = '12PM'; on Sunday refers to day_of_week = 'Sunday'
SQL: SELECT T1.city FROM Business AS T1 INNER JOIN Business_Hours AS T2 ON T1.business_id = T2.business_id INNER JOIN Days AS T3 ON T2.day_id = T3.day_id WHERE T2.opening_time LIKE '10AM' AND T2.closing_time LIKE '12PM' AND T3.day_of_week LIKE 'Sunday'

Database: books
Question: What is the total shipping cost of all the orders made by Page Holsey? Indicate how many of the said orders were ordered in 2022.
Evidence: shipping cost refers to cost; ordered in 2022 refers to order_date LIKE '2022%'
SQL: SELECT SUM(T3.cost) FROM customer AS T1 INNER JOIN cust_order AS T2 ON T1.customer_id = T2.customer_id INNER JOIN shipping_method AS T3 ON T3.method_id = T2.shipping_method_id WHERE T1.first_name = 'Page' AND T1.last_name = 'Holsey' AND STRFTIME('%Y', T2.order_date) = '2022'

Database: cookbook
Question: Please list the names of all the ingredients needed for the recipe "Raspberry Chiffon Pie" that do not need preprocessing.
Evidence: Raspberry Chiffon Pie refers to title; do not need preprocessing refers to preparation IS NULL
SQL: SELECT T3.name 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 = 'Raspberry Chiffon Pie' AND T2.preparation IS NULL

Database: soccer_2016
Question: For how many times has player no.41 won the "man of the match" award?
Evidence: player no.41 won the "man of the match" refers to Man_of_the_Match = 41
SQL: SELECT COUNT(Match_Id) FROM `Match` WHERE Man_of_the_Match = 41

Database: disney
Question: Provide the title, director, and release date of the movie voice-acted by Freddie Jones.
Evidence: Freddie Jones refers to voice-actor = 'Freddie Jones'; title refers to movie_title;
SQL: SELECT T1.movie, T3.director, T2.release_date FROM `voice-actors` AS T1 INNER JOIN characters AS T2 ON T1.movie = T2.movie_title INNER JOIN director AS T3 ON T3.name = T2.movie_title WHERE T1.`voice-actor` = 'Freddie Jones'

Database: simpson_episodes
Question: Please check is "limbo dancing" the keyword for title "Dangerous Curves"?
SQL: SELECT CASE WHEN T2.Keyword = 'limbo dancing' THEN 'Yes' ELSE 'No' END AS result FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id WHERE T1.title = 'Dangerous Curves';

Database: movie_3
Question: What are the address numbers that are located in Gansu district?
Evidence: address numbers refers to address_id;
SQL: SELECT address_id FROM address WHERE district = 'Gansu'