Database: university
Question: Provide the universities which got the highest scores.
Evidence: got the highest scores refers to MAX(SUM(score))
SQL: SELECT T1.university_name FROM university AS T1 INNER JOIN university_ranking_year AS T2 ON T1.id = T2.university_id GROUP BY T1.university_name ORDER BY SUM(T2.score) DESC LIMIT 1

Database: authors
Question: Among the authors affiliated with Soongsil University, list the authors' names and papers published during the year 2000.
Evidence: authors affiliated with Soongsil University refers to Affiliation = 'Soongsil University'
SQL: SELECT T2.Title, T1.Name FROM PaperAuthor AS T1 INNER JOIN Paper AS T2 ON T1.PaperId = T2.Id WHERE T1.Affiliation = 'Soongsil University' AND T2.Year = 2000

Database: movielens
Question: Which actor has appeared in the most films?
SQL: SELECT actorid FROM movies2actors GROUP BY actorid ORDER BY COUNT(movieid) DESC LIMIT 1

Database: citeseer
Question: On average, how many papers are under the ML class?
Evidence: class refers to class_label; average = divide(count(paper_id where class_label = 'M')), (count(paper_id)));
SQL: SELECT CAST(COUNT(CASE WHEN class_label = 'ML' THEN paper_id ELSE NULL END) AS REAL) / COUNT(paper_id) FROM paper

Database: food_inspection
Question: Among the violations in 2016, how many of them have unscheduled inspections?
Evidence: unscheduled inspections refer to type = 'Routine - Unschedule'; year(date) = 2016;
SQL: SELECT COUNT(T2.business_id) FROM violations AS T1 INNER JOIN inspections AS T2 ON T1.business_id = T2.business_id WHERE STRFTIME('%Y', T1.`date`) = '2016' AND T2.type = 'Routine - Unscheduled'

Database: movie_platform
Question: How many followers did the user who posted the list "Non-American Films about World War II" have?
Evidence: the list "Non-American Films about World War II" refers to list_title = 'Non-American Films about World War II'
SQL: SELECT SUM(T2.list_followers) FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.list_id = T2.list_id WHERE T2.list_title LIKE 'Non-American Films about World War II'

Database: regional_sales
Question: List all the cities where Shawn Torres sells Audio products.
Evidence: "Shawn Torres" is the name of Sales Team; Audio product refers to Product Name = 'Audio'
SQL: SELECT T FROM ( SELECT DISTINCT CASE  WHEN T4.`Product Name` = 'Audio' AND T3.`Sales Team` = 'Shawn Torres' THEN T1.`City Name` ELSE NULL END AS T FROM `Store Locations` T1 INNER JOIN `Sales Orders` T2 ON T2._StoreID = T1.StoreID INNER JOIN `Sales Team` T3 ON T3.SalesTeamID = T2._SalesTeamID INNER JOIN Products T4 ON T4.ProductID = T2._ProductID ) WHERE T IS NOT NULL

Database: professional_basketball
Question: Please list the last names and first names of all-star players who are higher than 75 inch.
Evidence: higher than 75 inch refers to height > 75
SQL: SELECT DISTINCT T1.lastName, T1.firstName FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE T1.height > 75

Database: movielens
Question: Please list different IDs of movies that are the newest and have gotten the lowest rating.
Evidence: Year contains relative value, higer year value refers to newer date; Year = 4 refers to newest date, Year = 1 refer to oldest date; Lowest rating = 1
SQL: SELECT DISTINCT T1.movieid FROM u2base AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid WHERE T2.year = 4 AND T1.rating = 1

Database: video_games
Question: In which year was Panzer Tactics released on DS?
Evidence: year refers to release_year; Panzer Tactics refers to game_name = 'Panzer Tactics'; on DS refers to platform_name = 'DS'
SQL: SELECT T4.release_year FROM game_publisher AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id INNER JOIN game AS T3 ON T1.game_id = T3.id INNER JOIN game_platform AS T4 ON T1.id = T4.game_publisher_id INNER JOIN platform AS T5 ON T4.platform_id = T5.id WHERE T3.game_name = 'Panzer Tactics' AND T5.platform_name = 'DS'

Database: video_games
Question: How many publishers have published more than 3 puzzle games?
Evidence: puzzle refers to genre_name = 'Puzzle'; more than 3 puzzle games refers to count(game_id where genre_name = 'Puzzle') > 3
SQL: SELECT COUNT(T.publisher_name) FROM ( SELECT T3.publisher_name, COUNT(DISTINCT T1.id) FROM game AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.game_id INNER JOIN publisher AS T3 ON T2.publisher_id = T3.id INNER JOIN genre AS T4 ON T1.genre_id = T4.id WHERE T4.genre_name = 'Puzzle' GROUP BY T3.publisher_name HAVING COUNT(DISTINCT T1.id) > 3 ) t

Database: world_development_indicators
Question: Which country have data classified as official aid?
Evidence: which country refers to ShortName; have data classified as official aid refers to description = 'Data are classified as official aid.'
SQL: SELECT DISTINCT T1.CountryCode FROM Country AS T1 INNER JOIN FootNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T2.Description = 'Data are classified as official aid.'

Database: beer_factory
Question: What brands of beer has Peg Winchester consumed?
Evidence: brands of beer refers to BrandName;
SQL: SELECT T3.BrandName FROM customers AS T1 INNER JOIN rootbeerreview AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN rootbeerbrand AS T3 ON T2.BrandID = T3.BrandID WHERE T1.First = 'Peg' AND T1.Last = 'Winchester'

Database: food_inspection
Question: How many high risk violations do the restaurants in San Francisco have in total?
Evidence: restaurants in San Francisco refer to business_id where city in ('San Francisco', 'SF', 'S.F.', 'SAN FRANCISCO'); high risk violations refer to risk_category = 'High Risk';
SQL: SELECT COUNT(T2.business_id) FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T2.city IN ('San Francisco', 'SF', 'S.F.', 'SAN FRANCISCO') AND T1.risk_category = 'High Risk'

Database: olympics
Question: Please list the names of all the Olympic competitors from Finland.
Evidence: names of competitors refer to full_name; from Finland refers to region_name = 'Finland';
SQL: SELECT T3.full_name FROM noc_region AS T1 INNER JOIN person_region AS T2 ON T1.id = T2.region_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T1.region_name = 'Finland'

Database: retails
Question: What is the name of the customer number 93697 with the total order price of 191918.92?
Evidence: customer name refers to c_name; number 93697 refers to o_custkey = 93697; total order price of 191918.92 refers to o_totalprice = 191918.92
SQL: SELECT T2.c_name FROM orders AS T1 INNER JOIN customer AS T2 ON T1.o_custkey = T2.c_custkey WHERE T1.o_totalprice = 191918.92 AND T1.o_custkey = 93697

Database: movie_3
Question: Please name three cities that belong to Algeria.
Evidence: Algeria is a country
SQL: SELECT T2.city FROM country AS T1 INNER JOIN city AS T2 ON T1.country_id = T2.country_id WHERE T1.country = 'Algeria'

Database: music_tracker
Question: How many albums and Single-Tables were released by the artist named '50 cent' between 2010 and 2015?
Evidence: albums refer to releaseType = 'album'; releaseType = 'single'; between 2010 and 2015 refers to groupYear between 2010 and 2015;
SQL: SELECT COUNT(id), ( SELECT COUNT(id) FROM torrents WHERE groupYear BETWEEN 2010 AND 2015 AND artist LIKE '50 cent' AND releaseType LIKE 'album' ) FROM torrents WHERE groupYear BETWEEN 2010 AND 2015 AND artist LIKE '50 cent' AND releaseType LIKE 'Single'

Database: movie_3
Question: What is the category of film titled "BLADE POLISH"?
SQL: SELECT T3.name FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T3.category_id = T2.category_id WHERE T1.title = 'BLADE POLISH'