Database: simpson_episodes
Question: Which episode id did award Outstanding Animated Program (For Programming Less Than One Hour) with an episode star score of 10?
Evidence: star score of 10 refers to stars = 10
SQL: SELECT DISTINCT T1.episode_id FROM Award AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T1.award = 'Outstanding Animated Program (For Programming Less Than One Hour)' AND T2.stars = 10;

Database: superstore
Question: What is the product name of order CA-2011-115791 in the East superstore?
Evidence: order CA-2011-115791 refers to "Order ID" = 'CA-2011-115791'
SQL: SELECT DISTINCT T2.`Product Name` FROM east_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T1.`Order ID` = 'CA-2011-141817'

Database: authors
Question: For the paper which was presented by "Zvezdan Protić", was it preprinted?
Evidence: Year = 0 means this paper is preprint, or not published
SQL: SELECT CASE WHEN T1.Year = 0 THEN 'TRUE' ELSE 'FALSE' END FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T2.Name = 'Zvezdan Protić' AND T1.ConferenceId = 0 AND T1.JournalId = 0

Database: book_publishing_company
Question: Who are the employees working for publisher not located in USA? State the employee's name and publisher name.
Evidence: not located at USA refers to country! = 'USA'
SQL: SELECT T1.fname, T1.lname, T2.pub_name FROM employee AS T1 INNER JOIN publishers AS T2 ON T1.pub_id = T2.pub_id WHERE T2.country != 'USA'

Database: retail_complains
Question: What is the full name of clients who have issue about balance transfer?
Evidence: full name refers to first, middle, last; issue about balance transfer refers to Issue = 'Balance transfer'
SQL: SELECT T1.first, T1.middle, T1.last FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.Issue = 'Balance transfer'

Database: movie_platform
Question: How many users rated the movie "The Magnificent Ambersons" gave a rating score of no more than 2? List all the URL to the rating on Mubi.
Evidence: The Magnificent Ambersons refers to movie_title; rating score of no more than 2 refers to rating_score<2; URL to rating refers to rating_url
SQL: SELECT COUNT(T2.user_id), T2.rating_url FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'The Magnificent Ambersons' AND T2.rating_score <= 2

Database: synthea
Question: During all the observations of Elly Koss, what was the highest Systolic Blood Pressure observed?
Evidence: the highest Systolic Blood Pressure refers to MAX(DESCRIPTION = 'Systolic Blood Pressure') from observations;
SQL: SELECT T2.value, T2.units FROM patients AS T1 INNER JOIN observations AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Elly' AND T1.last = 'Koss' AND T2.description = 'Systolic Blood Pressure' ORDER BY T2.VALUE DESC LIMIT 1

Database: cars
Question: Which country produced the highest number of cars? Calculate the annual average number of cars that the said country produced from the very start to the present.
Evidence: the highest number of cars refers to max(country); annual average number = divide(count(ID), count(model_year))
SQL: SELECT T2.country, CAST(COUNT(T1.ID) AS REAL) / COUNT(DISTINCT T1.model_year) FROM production AS T1 INNER JOIN country AS T2 ON T1.country = T2.origin GROUP BY T2.country ORDER BY COUNT(T2.country) DESC LIMIT 1

Database: bike_share_1
Question: Which bicycle is the least used bike. Check if the start and end station are from the same city and calculate the total duration travelled by the bicycle in hours for a trip made within the same city.
Evidence: least used bike refers to bike_id with MIN(COUNT(main_trip.id)); start station refers to start_station_name; end station refers to end_station_name; total duration in hour = DIVIDE(duration, 3600) AS hour;
SQL: SELECT T2.bike_id, T2.start_station_name, T2.end_station_name, T1.city , CAST(T2.duration AS REAL) / 3600 FROM station AS T1 INNER JOIN trip AS T2 ON T1.name = T2.start_station_name GROUP BY T2.bike_id ORDER BY COUNT(T2.id) DESC LIMIT 1

Database: world
Question: List down the official language of the countries which declared independence after 1990,
Evidence: official lanaguage refers to IsOfficial = 'T'; declared independence after 1990 refers to IndepYear > 1990;
SQL: SELECT T1.Name, T2.Language FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.IndepYear > 1990 AND T2.IsOfficial = 'T'

Database: movie_3
Question: How many films have a duration between 100 to 110 minutes?
Evidence: duration between 100 to 110 minutes refers to length between 100 and 110
SQL: SELECT COUNT(film_id) FROM film WHERE length BETWEEN 100 AND 110

Database: sales
Question: Among the products with product ID lower than 15, how many of them costs 10 and below?
Evidence: product ID lower than 15 refers to ProductID < 15; costs 10 and below refers to Price; Price < = 10;
SQL: SELECT COUNT(ProductID) FROM Products WHERE ProductID < 15 AND Price <= 10

Database: image_and_language
Question: What is the prediction relationship class id of the tallest image?
Evidence: prediction relationship class id refers to PRED_CLASS_ID; tallest image refers to max(H)
SQL: SELECT T1.PRED_CLASS_ID FROM IMG_REL AS T1 INNER JOIN IMG_OBJ AS T2 ON T1.IMG_ID = T2.IMG_ID ORDER BY T2.H DESC LIMIT 1

Database: regional_sales
Question: List all the name of products with the ID of 30 to 40.
Evidence: products with the ID of 30 to 40 refer to Product Name WHERE ProductID BETWEEN 30 AND 40;
SQL: SELECT T FROM ( SELECT CASE  WHEN ProductID BETWEEN 30 AND 40 THEN `Product Name` ELSE NULL END AS T FROM Products ) WHERE T IS NOT NULL

Database: public_review_platform
Question: Please list the categories of the Yelp_Business that closes at 12PM on Sundays.
Evidence: categories refers to category_name; closes at 12PM refers to closing_time = '12PM'; on Sundays refers to day_of_week = 'Sunday'
SQL: SELECT T4.category_name FROM Business_Hours AS T1 INNER JOIN Days AS T2 ON T1.day_id = T2.day_id INNER JOIN Business_Categories AS T3 ON T1.business_id = T3.business_id INNER JOIN Categories AS T4 ON T4.category_id = T4.category_id WHERE T1.closing_time = '12PM' AND T2.day_of_week = 'Sunday' GROUP BY T4.category_name

Database: talkingdata
Question: Among the users who use SUGAR, calculate the percentage of those who are above 20 years old.
Evidence: SUGAR refers to phone_brand = 'SUGAR'; percentage = MULTIPLY(DIVIDE(SUM(age > 20), COUNT(device_id)) 1.0); above 20 years old refers to age > 20;
SQL: SELECT SUM(IIF(T1.age > 20, 1, 0)) / COUNT(T1.device_id) AS per FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.phone_brand = 'SUGAR'

Database: superstore
Question: List the name of all the products with order quantities greater than or equal to 10 in the central superstore that has been shipped by the slowest delivery method.
Evidence: name of all the products refers to Product Name; order quantities greater than or equal to 10 refers to COUNT("Order ID") > = 10; slowest delivery refers to "Ship Mode" = 'Standard Class'
SQL: SELECT DISTINCT T2.`Product Name` FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T1.`Ship Mode` = 'Standard Class' AND T1.Quantity >= 10

Database: food_inspection
Question: What is the name of the establishment with the lowest inspection score of all time?
Evidence: the lowest inspection score refers to MIN(score);
SQL: SELECT T2.name FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.score = ( SELECT MIN(score) FROM inspections )