Database: authors
Question: Please list the titles of any two papers that Jundu has written.
Evidence: papers that Jundu has written refers to Name LIKE '%Jun du%'
SQL: SELECT T1.Title FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T2.Name LIKE 'Jun du%' LIMIT 2

Database: cs_semester
Question: How many research postgraduate students are there?
Evidence: research postgraduate student refers to type = 'RPG';
SQL: SELECT COUNT(student_id) FROM student WHERE type = 'RPG'

Database: ice_hockey_draft
Question: What is the height in centimeter of the tallest player born in Edmonton, Alberta, Canada?
Evidence: height in centimeter refers to height_in_cm; tallest player refers to MAX(height_in_cm); born in Edmonton, Alberta, Canada refers to birthplace = 'Edmonton, AB, CAN';
SQL: SELECT T2.height_in_cm FROM PlayerInfo AS T1 INNER JOIN height_info AS T2 ON T1.height = T2.height_id WHERE T1.birthplace = 'Edmonton, AB, CAN' ORDER BY T2.height_in_cm DESC LIMIT 1

Database: music_tracker
Question: How many tags does the release "city funk" have？
Evidence: release "city funk" refers to groupName = 'city funk';
SQL: SELECT COUNT(T2.tag) FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T1.groupName = 'city funk'

Database: movies_4
Question: What is the title of the movie with the most keywords?
Evidence: most keywords refers to max(count(keyword_id))
SQL: SELECT T1.title FROM movie AS T1 INNER JOIN movie_keywords AS T2 ON T1.movie_id = T2.movie_id GROUP BY T1.title ORDER BY COUNT(T2.keyword_id) DESC LIMIT 1

Database: menu
Question: How many menus include puree of split peas aux croutons?
Evidence: puree of split peas aux croutons is a name of dish;
SQL: SELECT SUM(CASE WHEN T1.name = 'Puree of split peas aux croutons' THEN 1 ELSE 0 END) FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id

Database: world
Question: Which country has the smallest surface area and the most crowded city?
Evidence: smallest surface area refers to MIN(smallest surface area); most crowded city refers to MAX(Population);
SQL: SELECT T2.Name FROM City AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.Code ORDER BY T1.Population DESC, T2.SurfaceArea DESC LIMIT 1

Database: restaurant
Question: What is the percentage of restaurants that serve American food in Dublin city?
Evidence: American food refers to food_type = 'american food'; percentage = divide(count(id_restaurant), count(id_restaurant where food_type = 'american food')) where city = 'dublin' * 100%
SQL: SELECT CAST(SUM(IIF(food_type = 'american food', 1, 0)) AS REAL) * 100 / COUNT(id_restaurant) FROM generalinfo WHERE city = 'dublin'

Database: video_games
Question: Name the publisher of the Chronicles of the Sword game.
Evidence: publisher refers to publisher_name; the Chronicles of the Sword game refers to game_name = 'Chronicles of the Sword'
SQL: SELECT T3.publisher_name 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 WHERE T1.game_name = 'Chronicles of the Sword'

Database: movie_3
Question: Among the films with the longest duration, list any five title with their descriptions and special features.
Evidence: longest duration of film refers to Max(length)
SQL: SELECT title, description, special_features FROM film WHERE length = ( SELECT MAX(length) FROM film ) LIMIT 5

Database: book_publishing_company
Question: Calculate the average level difference between the Marketing editors hired by the US and non-US publishers?
Evidence: Marketing manager is a job description which refers to job_desc; US publisher refers publisher in the US where country = 'USA'; non-US publishers refers publisher not in the US where country! = 'USA'; job level refers to job_lvl; average level = AVG(job_lvl)
SQL: SELECT (CAST(SUM(CASE WHEN T1.country = 'USA' THEN job_lvl ELSE 0 END) AS REAL) / SUM(CASE WHEN T1.country = 'USA' THEN 1 ELSE 0 END)) - (CAST(SUM(CASE WHEN T1.country != 'USA' THEN job_lvl ELSE 0 END) AS REAL) / SUM(CASE WHEN T1.country != 'USA' THEN 1 ELSE 0 END)) FROM publishers AS T1 INNER JOIN employee AS T2 ON T1.pub_id = T2.pub_id INNER JOIN jobs AS T3 ON T2.job_id = T3.job_id WHERE T3.job_desc = 'Managing Editor'

Database: college_completion
Question: Tell the abbreviation for "Delaware" state.
Evidence: abbreviation for state refers to state_abbr;
SQL: SELECT T FROM ( SELECT DISTINCT CASE WHEN state = 'Delaware' THEN state_abbr ELSE NULL END AS T FROM state_sector_grads ) WHERE T IS NOT NULL

Database: talkingdata
Question: What were the locations of the events on 8th May, 2016?
Evidence: location = longitude, latitude; on 8th May, 2016 refers to `timestamp` LIKE '2016-05-08%';
SQL: SELECT longitude, latitude FROM `events` WHERE SUBSTR(`timestamp`, 1, 10) = '2016-05-08'

Database: authors
Question: Provide the number of publications published in the journal named 'Academic Medicine' between 2005 and 2010.
Evidence: 'Academic Medicine' is the FullName of journal; between 2005 and 2010 refer to Year 2005 BETWEEN 2010
SQL: SELECT COUNT(T2.JournalId) FROM Journal AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.JournalId WHERE T1.FullName = 'Academic Medicine' AND T2.Year BETWEEN 2005 AND 2010

Database: movie_platform
Question: What's the avatar image of the user who created the movie list "250 Favourite Films"?
Evidence: 250 Favourite Films refers to list_title; avatar image refers to user_avatar_image_url;
SQL: SELECT T2.user_avatar_image_url FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id AND T1.user_id = T2.user_id WHERE T1.list_title = '250 Favourite Films'

Database: movie_platform
Question: What is the average rating score of the movie "The Crowd" and who was its director?
Evidence: director refer to director_name; The Crowd refer to movie_title; Average refer to AVG(rating_score)
SQL: SELECT AVG(T2.rating_score), T1.director_name FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'The Crowd'

Database: simpson_episodes
Question: Calculate the percentage of the winners who are higher than 1.75 meters.
Evidence: winners refers to result = 'Winner'; higher than 1.75 meters refers to height_meters > 1.75; percentage = divide(sum(result = 'Winner' and height_meters > 1.75), count(result = 'Winner' )) * 100%

SQL: SELECT CAST(SUM(CASE WHEN T1.height_meters > 1.75 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM Person AS T1 INNER JOIN Award AS T2 ON T1.name = T2.person WHERE T2.result = 'Winner';

Database: soccer_2016
Question: Who was the captain of the winning team in the match held on 1st June 2008?
Evidence: player's name refers to Player_Name; captain refers to Role_Desc = 'Captain'; the winning team refers to Match_Winner = Team_Id; on 1st June 2008 refers to Match_Date = '2008-06-01'
SQL: SELECT T3.Player_Name FROM Player_Match AS T1 INNER JOIN Match AS T2 ON T2.Match_Id = T1.Match_Id INNER JOIN Player AS T3 ON T3.Player_Id = T1.Player_Id INNER JOIN Rolee AS T4 ON T4.Role_Id = T1.Role_Id WHERE T2.Match_Date = '2008-06-01' AND T4.Role_Desc = 'Captain' AND T2.Match_Winner = T1.Team_Id

Database: music_platform_2
Question: Name all the podcast title and its category with average rating of more than 3.0.
Evidence: average rating of more than 3.0 refers to avg(rating) > 3.0
SQL: SELECT T2.title, T1.category FROM categories AS T1 INNER JOIN podcasts AS T2 ON T2.podcast_id = T1.podcast_id INNER JOIN reviews AS T3 ON T3.podcast_id = T2.podcast_id GROUP BY T3.podcast_id HAVING AVG(T3.rating) > 3