Database: olympics
Question: In which Olympic Games has Morten Aleksander Djupvik participated?
Evidence: In which Olympic Games refer to games_year;
SQL: SELECT T1.games_name FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T3.full_name = 'Morten Aleksander Djupvik'

Database: world_development_indicators
Question: Please list annual indicator names which have values of more than 100 in 1965.
Evidence: Annual refers to Periodicity; values of more than 100 implies Value>100; Year = '1965';
SQL: SELECT DISTINCT T2.IndicatorName FROM Indicators AS T1 INNER JOIN Series AS T2 ON T1.IndicatorName = T2.IndicatorName WHERE T1.Year = 1965 AND T1.Value > 100 AND T2.Periodicity = 'Annual'

Database: software_company
Question: In customers with marital status of never married, what is the percentage of customers with income of 2500 and above?
Evidence: DIVIDE(COUNT(INCOME_K ≥ 2500 where MARITAL_STATUS = 'Never-married'), COUNT(INCOME_K where MARITAL_STATUS = 'Never-married')) as percentage;
SQL: SELECT CAST(SUM(CASE WHEN T2.INCOME_K > 2500 THEN 1.0 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID WHERE T1.MARITAL_STATUS = 'Never-married'

Database: beer_factory
Question: What is the precise location of Sac State Union?
Evidence: precise location = Latitude, Longitude; Sac State Union refers to LocationName = 'Sac State Union';
SQL: SELECT T2.Latitude, T2.Longitude FROM location AS T1 INNER JOIN geolocation AS T2 ON T1.LocationID = T2.LocationID WHERE T1.LocationName = 'Sac State Union'

Database: retails
Question: Among the orders shipped in November, 1998 by air, how many orders were urgent?
Evidence: orders shipped in November, 1998 refer to o_orderkey where l_shipdate LIKE '1998-11-%'; by air refers to l_shipmode = 'AIR'; the order is urgent if o_orderpriority = '1-URGENT' ;
SQL: SELECT COUNT(T1.o_orderkey) FROM orders AS T1 INNER JOIN lineitem AS T2 ON T1.o_orderkey = T2.l_orderkey WHERE T2.l_shipmode = 'AIR' AND T1.o_orderpriority = '1-URGENT' AND SUBSTR(T2.l_shipdate, 1, 7) = '1998-11'

Database: car_retails
Question: Of all the orders placed and shipped throughout the year 2005, what percentage of those orders corresponds to customer number 186?
Evidence: shipped orders refers to status = 'shipped'; year(shippedDate) = 2005; percentage = DIVIDE(SUM(customerNumber = 186)), COUNT(orderNumber)) as percentage;
SQL: SELECT CAST(SUM(CASE WHEN customerNumber = 186 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(orderNumber) FROM orders WHERE status = 'Shipped' AND shippedDate BETWEEN '2005-01-01' AND '2005-12-31'

Database: retail_world
Question: Who is the customer who purchased the highest number of products in a single order?
Evidence: highest number of products refers to MAX(COUNT(ProductID))
SQL: SELECT T1.CompanyName FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN `Order Details` AS T3 ON T2.OrderID = T3.OrderID GROUP BY T1.CompanyName ORDER BY COUNT(T3.ProductID) DESC LIMIT 1

Database: movie_3
Question: How many movies have a length longer than 100?
Evidence: length longer than 100 refers to length > 100
SQL: SELECT COUNT(film_id) FROM film WHERE length > 100

Database: retail_world
Question: How many products were supplied by Pavlova, Ltd.?
Evidence: Pavlova, Ltd. refers to CompanyName = 'Pavlova, Ltd.'
SQL: SELECT COUNT(T1.ProductName) FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Pavlova, Ltd.'

Database: music_platform_2
Question: List all the names of podcasts under the 'true crime' category.
Evidence: name of the podcast refers to title of the podcast
SQL: SELECT T2.title FROM categories AS T1 INNER JOIN podcasts AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.category = 'true-crime'

Database: world_development_indicators
Question: In 2005, which series codes use the International Monetary Fund, Balance of Payments Statistics Yearbook and data files source?
Evidence: Year contains '2005'; series codes contain 'International Monetary Fund'
SQL: SELECT T1.Seriescode, T2.Source FROM Footnotes AS T1 INNER JOIN Series AS T2 ON T1.Seriescode = T2.SeriesCode WHERE T1.Year LIKE '%2005%' AND T2.Source LIKE 'International Monetary Fund%'

Database: university
Question: Calculate the average number of criterias among "Times Higher Education World University Ranking","Shanghai Ranking" and "Center for World University Rankings".
Evidence: average number of criterias refers to DIVIDE(SUM(id), 3); "Times Higher Education World University Ranking", "Shanghai Ranking" and "Center for World University Rankings" refers to system_name IN ('Times Higher Education World University Ranking', 'Shanghai Ranking', 'Center for World University Rankings');
SQL: SELECT (SUM(CASE WHEN T1.system_name = 'Center for World University Rankings' THEN 1 ELSE 0 END) + SUM(CASE WHEN T1.system_name = 'Shanghai Ranking' THEN 1 ELSE 0 END) + SUM(CASE WHEN T1.system_name = 'Times Higher Education World University Ranking' THEN 1 ELSE 0 END)) / 3 FROM ranking_system AS T1 INNER JOIN ranking_criteria AS T2 ON T1.id = T2.ranking_system_id

Database: law_episode
Question: What is the date of birth of the actor who played the role of a "writer"?
Evidence: date of birth refers to birthdate
SQL: SELECT T2.birthdate FROM Award AS T1 INNER JOIN Person AS T2 ON T1.person_id = T2.person_id WHERE T1.role = 'writer'

Database: sales
Question: Tally the product name and quantity of the first ten sales.
Evidence: first ten sales refers to SalesID BETWEEN 1 AND 10;
SQL: SELECT T3.Name, T2.Quantity FROM Customers AS T1 INNER JOIN Sales AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN Products AS T3 ON T2.ProductID = T3.ProductID WHERE T2.SalesID BETWEEN 1 AND 10

Database: world
Question: Among the countries that have GNP greater than 1500, what is the percentage of the countries have English as its language?
Evidence: GNP greater than 1500 refers to GNP > 1500 ; percentage = MULTIPLY(DIVIDE(SUM(Code WHERE GNP > 1500 AND Language = 'English'), COUNT(Code WHERE GNP > 1500)) 1.0); English as its language refers to Language = 'English';
SQL: SELECT CAST(SUM(IIF(T2.Language = 'English', 1, 0)) AS REAL) * 100 / COUNT(T1.Code) FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.GNP > 1500

Database: simpson_episodes
Question: List the episode ID and title of episode where casting was credited to Bonita Pietila.
Evidence: was credited refers to credited = 'true'; to Bonita Pietila refers to person = 'Bonita Pietila'
SQL: SELECT T1.episode_id, T1.title FROM Episode AS T1 INNER JOIN Credit AS T2 ON T1.episode_id = T2.episode_id WHERE T2.credited = 'true' AND T2.person = 'Bonita Pietila' AND T2.role = 'casting';

Database: student_loan
Question: How many students have absent from school?
Evidence: have absent from school refers to month > 1;
SQL: SELECT COUNT(name) FROM longest_absense_from_school WHERE month > 1

Database: donor
Question: Which project have the highest total price including optional support? Indicate the project id.
Evidence: highest total price including optional support refers to max(total_price_including_optional_support)
SQL: SELECT projectid FROM projects ORDER BY total_price_including_optional_support DESC LIMIT 1

Database: menu
Question: How many dishes have appeared on the menu in less than 5 years?
Evidence: appeared on the menu in less than 5 years = SUBTRACT(last_appeared, first_appeared) < 5;
SQL: SELECT COUNT(*) FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id WHERE T1.last_appeared - T1.first_appeared < 5