Database: retail_world
Question: Describe the ordered products which were the most overdue from required date.
Evidence: the most overdue from required date refers to MIN(SUBTRACT(ShippedDate, RequiredDate) < 0)
SQL: SELECT DISTINCT T3.ProductName FROM Orders AS T1 INNER JOIN `Order Details` AS T2 ON T1.OrderID = T2.OrderID INNER JOIN Products AS T3 ON T2.ProductID = T3.ProductID WHERE DATEDIFF(T1.ShippedDate, T1.RequiredDate) < 0

Database: authors
Question: Please provide the titles of any two papers that are either preprinted or unpublished along with the full name of the journal to which those papers belong.
Evidence: papers that are either preprinted or unpublished along refers to Year = 0
SQL: SELECT T1.Title, T2.FullName FROM Paper AS T1 INNER JOIN Journal AS T2 ON T1.JournalId = T2.Id WHERE T1.Year < 1 LIMIT 2

Database: public_review_platform
Question: How many reviews made by user whose ID is 3 are long?
Evidence: long refers to review_length = 'Long';
SQL: SELECT COUNT(review_length) FROM Reviews WHERE user_id = 3 AND review_length LIKE 'Long'

Database: movie_3
Question: How many actors have starred in the film ACADEMY DINOSAUR?
Evidence: "ACADEMY DINOSAUR" is the title of film
SQL: SELECT COUNT(T1.actor_id) FROM film_actor AS T1 INNER JOIN film AS T2 ON T1.film_id = T2.film_id WHERE T2.title = 'ACADEMY DINOSAUR'

Database: sales
Question: Give the full name of the employee who has sold the most quantity.
Evidence: full name of the employee = FirstName, LastName; most quantity refers to MAX(Quantity);
SQL: SELECT T1.FirstName, T1.LastName FROM Employees AS T1 INNER JOIN Sales AS T2 ON T1.EmployeeID = T2.SalesPersonID ORDER BY T2.Quantity DESC LIMIT 1

Database: movie_platform
Question: In which year was the movie "La Antena" released?
Evidence: movie La Antena refers to movie_title = 'La Antena'; which year refers to movie_release_year;
SQL: SELECT movie_release_year FROM movies WHERE movie_title = 'La Antena'

Database: university
Question: Give the id of "Center for World University Rankings".
Evidence: "Center for World University Rankings" refers to system_name = 'Center for World University Rankings';
SQL: SELECT id FROM ranking_system WHERE system_name = 'Center for World University Rankings'

Database: book_publishing_company
Question: What's on the notes for the order happened on 1994/9/14?
Evidence: order happened on refers to ord_date
SQL: SELECT T1.notes FROM titles AS T1 INNER JOIN sales AS T2 ON T1.title_id = T2.title_id WHERE STRFTIME('%Y-%m-%d', T2.ord_date) = '1994-09-14'

Database: simpson_episodes
Question: What is the birth name of Al Jean and his role in creating The simpson 20s: Season 20?
SQL: SELECT DISTINCT T1.birth_name, T2.role FROM Person AS T1 INNER JOIN Credit AS T2 ON T1.name = T2.person WHERE T1.name = 'Al Jean';

Database: retail_complains
Question: From 2012 to 2015, how many complaints were submitted via email from female clients?
Evidence: from 2012 to 2015 refers to Date received BETWEEN 2012 AND 2015; submitted via email refers to Submitted via = 'Email'; female refers to sex = 'Female'
SQL: SELECT COUNT(T1.client_id) FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE strftime('%Y', T2.`Date received`) BETWEEN '2012' AND '2015' AND T2.`Submitted via` = 'Email' AND T1.sex = 'Male'

Database: simpson_episodes
Question: Who from The simpson 20s: Season 20 cast and crew was born in October 29, 1957 in Chicago, Illinois?
Evidence: born in October 29, 1957 refers to birthdate = '1957-10-29'; in Chicago refers to birth_place = 'Chicago'; Illinois refers to birth_region = 'Illinois'
SQL: SELECT name FROM Person WHERE birthdate = '1957-10-29' AND birth_place = 'Chicago' AND birth_region = 'Illinois';

Database: legislator
Question: What is the ratio between famous current legislators and famous historical legislators?
Evidence: ratio = DIVIDE(COUNT(current.bioguide_id WHERE current.wikipedia_id is not null), COUNT(historical.bioguide_id WHERE historical.wikipedia_id is not null)); famous current legislators refers to current.wikipedia_id is not null; famous historical legislators refers to historical.wikipedia_id is not null;
SQL: SELECT CAST(COUNT(CASE WHEN wikipedia_id IS NOT NULL THEN bioguide_id ELSE 0 END) AS REAL) * 100 / ( SELECT COUNT(CASE WHEN wikipedia_id IS NOT NULL THEN bioguide_id ELSE 0 END) FROM historical ) FROM current

Database: beer_factory
Question: How many brands of bottle root beer were purchased between 4/3/2015 and 10/26/2015?
Evidence: bottle root beer refers to ContainerType = 'Bottle'; purchased between 4/3/2015 and 10/26/2015 refers to PurchaseDate BETWEEN '2015-04-23' AND '2015-10-26';
SQL: SELECT COUNT(BrandID) FROM rootbeer WHERE ContainerType = 'Bottle' AND PurchaseDate BETWEEN '2015-04-03' AND '2015-10-26'

Database: professional_basketball
Question: In 2000, which team did the player who played the least minutes without missing a single game play in? Give the full name of the team.
Evidence: in 2000 refers to year = 2000; played the least minutes refers to min(minutes); without missing a single game refers to GP = 82; full name of the team refers to teams.name
SQL: SELECT T1.tmID FROM teams AS T1 INNER JOIN players_teams AS T2 ON T1.tmID = T2.tmID AND T1.year = T2.year WHERE T2.GP = 82 AND T2.year = 2000 GROUP BY T1.tmID ORDER BY SUM(T2.PostMinutes) ASC LIMIT 1

Database: public_review_platform
Question: Among the Yelp_Business in Arizona, how many of them closes at 12PM on Sundays?
Evidence: in Arizona refers to state = 'AZ'; closes at 12PM refers to closing_time = '12PM'; on Sundays refers to day_of_week = 'Sunday'
SQL: SELECT COUNT(T1.business_id) FROM Business_Hours AS T1 INNER JOIN Days AS T2 ON T1.day_id = T2.day_id INNER JOIN Business AS T3 ON T1.business_id = T3.business_id WHERE T2.day_of_week LIKE 'Sunday' AND T1.closing_time LIKE '12PM' AND T3.state LIKE 'AZ'

Database: university
Question: How many international students attended Harvard University in 2012?
Evidence: Harvard University refers to university_name = 'Harvard University'; international students refers to DIVIDE(MULTIPLY(num_students, pct_international_students), 100); in 2012 refers to year = 2012
SQL: SELECT CAST(T2.num_students * T2.pct_international_students AS REAL) / 100 FROM university AS T1 INNER JOIN university_year AS T2 ON T1.id = T2.university_id WHERE T1.university_name = 'Harvard University' AND T2.year = 2012

Database: european_football_1
Question: What's the home win ratio of the Bundesliga division in 2021?
Evidence: home win refers to FTR = 'H', where H stands for home victory; season = '2021'; Bundesliga is a name of division; DIVIDE(COUNT(Div where FTR = 'H, season = '2021' and name = 'Bundesliga'), COUNT(Div where season = '2021' and name = 'Bundesliga')) as percentage;
SQL: SELECT CAST(COUNT(CASE WHEN T1.FTR = 'H' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.FTR) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T1.season = 2021 AND T2.name = 'Bundesliga'

Database: world_development_indicators
Question: What's the agregation method for the indicator whose value is 133 in 1960 for the Arab World?
Evidence: in 1960 refers to Year = 1960; for the Arab World refers to CountryName = 'Arab World'
SQL: SELECT T2.AggregationMethod FROM Indicators AS T1 INNER JOIN Series AS T2 ON T1.IndicatorName = T2.IndicatorName INNER JOIN Country AS T3 ON T1.CountryCode = T3.CountryCode WHERE T3.ShortName = 'Arab World' AND T1.Value = 133 AND T1.Year = 1960