Database: movie_platform
Question: What is the name of the most followed list?
Evidence: most followed list refers to MAX(list_followers);
SQL: SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1

Database: movie_platform
Question: For all list titles with at least 200 movies in the list, what is their average number of followers?
Evidence: at least 200 movies in the list refers to list_movie_number > 200; average number of followers refers to avg(list_followers)
SQL: SELECT AVG(list_followers) FROM lists WHERE list_movie_number > 200

Database: soccer_2016
Question: Among the players born in 1977, what is the percentage of the players with a role as a captain?
Evidence: born in 1977 refers to DOB LIKE '1977%'; a role as a captain refers to Role_Desc = 'Captain'; percentage = divide(count(Role_Id where Role_Desc = 'Captain'), count(Role_Id)) * 100% where DOB LIKE '1977%'
SQL: SELECT CAST(SUM(CASE WHEN T1.Role_Desc = 'Captain' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.Role_Id) FROM Rolee AS T1 INNER JOIN Player_Match AS T2 ON T2.Role_Id = T1.Role_Id INNER JOIN Player AS T3 ON T3.Player_Id = T2.Player_Id WHERE T3.DOB LIKE '1977%'

Database: human_resources
Question: List the full name and social security number of the account representative with average performance.
Evidence: full name = firstname, lastname; social security number refers to ssn; account representative is a position title; average performance refers to performance = 'Average'
SQL: SELECT T1.firstname, T1.lastname, T1.ssn FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T1.performance = 'Average'

Database: retail_world
Question: What is the total units on order from Exotic Liquids?
Evidence: "Exotic Liquids" is the CompanyName; total unit on order = Sum(UnitsOnOrder)
SQL: SELECT SUM(T1.UnitsOnOrder) FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Exotic Liquids'

Database: olympics
Question: Provide the competitors' names who joined the 2000 Summer.
Evidence: the competitors' names refer to full_name; the 2000 Summer refers to games_name = '2000 Summer';
SQL: SELECT T3.full_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 T1.games_name = '2000 Summer'

Database: chicago_crime
Question: Provide the ward number with the highest population.
Evidence: highest population refers to Max(Population); ward number refers to ward_no
SQL: SELECT ward_no FROM Ward ORDER BY Population DESC LIMIT 1

Database: human_resources
Question: Which city and address has zip code of above 90000?
Evidence: zip code of above 90000 refers to zipcode > 90000; city refers to locationcity
SQL: SELECT locationcity, address FROM location WHERE zipcode > 90000

Database: restaurant
Question: How many types of restaurants are there in the Yosemite and Mono Lake area?
SQL: SELECT COUNT(T2.food_type) FROM geographic AS T1 INNER JOIN generalinfo AS T2 ON T1.city = T2.city WHERE T1.region = 'yosemite and mono lake area'

Database: soccer_2016
Question: What is the venue name of Bandladore?
Evidence: Bandladore refers to City_Name = 'Bangalore'
SQL: SELECT T1.Venue_Name FROM Venue AS T1 INNER JOIN City AS T2 ON T1.City_ID = T2.City_ID WHERE T2.City_Name = 'Bangalore'

Database: soccer_2016
Question: Indicate the name of the most versatile players of the Delhi Daredevils.
Evidence: if a player has multiple roles in a match, it means this player is versatile; name refers to Player_Name; most versatile player refers to MAX(COUNT(Role_id)); Delhi Daredevils refers to Team_Name = 'Delhi Daredevils'
SQL: SELECT T3.Player_Name FROM Player_Match AS T1 INNER JOIN Team AS T2 ON T1.Team_Id = T2.Team_Id INNER JOIN Player AS T3 ON T1.Player_Id = T3.Player_Id WHERE T2.Team_Name = 'Delhi Daredevils' GROUP BY T3.Player_Name ORDER BY COUNT(T1.Role_Id) DESC LIMIT 1

Database: olympics
Question: In which cities beginning with the letter M have the Olympic Games been held?
Evidence: cities beginning with the letter M refer to city_name LIKE 'M%';
SQL: SELECT city_name FROM city WHERE city_name LIKE 'M%'

Database: mental_health_survey
Question: How many users lived in Canada according to 2018's survey?
Evidence: lived in Canada refers to AnswerText(QuestionID(3)) = 'Canada'
SQL: SELECT COUNT(T2.UserID) FROM Question AS T1 INNER JOIN Answer AS T2 ON T1.questionid = T2.QuestionID WHERE T2.SurveyID = 2018 AND T1.questiontext = 'What country do you live in?' AND T2.AnswerText = 'Canada'

Database: address
Question: How many states are in the central time zone? Write their full names.
Evidence: central time zone refers to time_zone = 'Central'
SQL: SELECT SUM(CASE WHEN T1.time_zone = 'Central' THEN 1 ELSE 0 END) AS count FROM zip_data AS T1 INNER JOIN state AS T2 ON T2.abbreviation = T1.state WHERE T1.time_zone = 'Central'

Database: world_development_indicators
Question: List out the country name of upper middle income group. Which country has the earliest national account base year? List out the region where this country locates.
Evidence: IncomeGroup = 'Upper middle income'; the earliest national account base year refers to MIN(NationalAccountsBaseYear); 

SQL: SELECT DISTINCT T1.CountryName FROM indicators AS T1 INNER JOIN country AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.IncomeGroup = 'Upper middle income' UNION SELECT longname FROM ( SELECT longname FROM country WHERE NationalAccountsBaseYear <> '' ORDER BY NationalAccountsBaseYear ASC LIMIT 1 )

Database: soccer_2016
Question: How many times did SC Ganguly be the man of the match?
Evidence: SC Ganguly refers to Player_Name = 'SC Ganguly'
SQL: SELECT COUNT(T2.Man_of_the_Match) FROM Player AS T1 INNER JOIN Match AS T2 ON T1.Player_Id = T2.Man_of_the_Match INNER JOIN Player_Match AS T3 ON T3.Player_Id = T1.Player_Id WHERE T1.Player_Name = 'SC Ganguly'

Database: authors
Question: How many papers were written by authors who cooperated with University of Hong Kong?
Evidence: University of Hong Kong' is an affiliation
SQL: SELECT COUNT(T2.PaperId) FROM Author AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.AuthorId WHERE T1.Affiliation = 'University of Hong Kong'

Database: codebase_comments
Question: Give the number of solutions that the repository which has 3060 Stars contains.
Evidence: solutions refers to Solution.Id; repository refers to Repository.Id;
SQL: SELECT COUNT(T2.RepoId) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Stars = 3060

Database: car_retails
Question: Name the product from the 'Classic Cars' production line that has the greatest expected profit.
Evidence: The greatest expected profit refers to MAX(SUBTRACT(MSRP, buyPrice);
SQL: SELECT t.productName, t.MSRP - t.buyPrice FROM products AS t WHERE t.productLine = 'Classic Cars' ORDER BY t.MSRP - t.buyPrice DESC LIMIT 1

Database: legislator
Question: Which current legislator has served for more terms, Sherrod Brown or Maria Cantwell?
Evidence: if sum(official_full_name = 'Maria Cantwell') > sum(official_full_name = 'Sherrod Brown') then Maria Cantwell has served for more term than Sherrod Brown; if sum(official_full_name = 'Sherrod Brown') > sum(official_full_name = 'Maria Cantwell'), then Sherrod Brown has served for more terms than Maria Cantwell;
SQL: SELECT CASE WHEN SUM(CASE WHEN T1.official_full_name = 'Maria Cantwell' THEN 1 ELSE 0 END) > SUM(CASE WHEN T1.official_full_name = 'Sherrod Brown' THEN 1 ELSE 0 END) THEN 'Maria Cantwell' ELSE 'Sherrod Brown' END FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide