Database: soccer_2016
Question: Between match nos. 335989 and 337000, how many times did a batsman score more than 3 runs during over no. 1, ball no. 1, and inning no. 1 of the matches?
Evidence: Between match no. 335989 and 337000 refers to 335989 < Match_Id < 337000; batsman score more than 3 runs during over no. 1, ball no. 1, and inning no. 1 of the matches refers to Runs_Scored > 3 and  Over_Id = 1 and Ball_Id = 1 and Innings_No = 1
SQL: SELECT SUM(CASE WHEN Runs_Scored > 3 THEN 1 ELSE 0 END) FROM Batsman_Scored WHERE 335989 < Match_Id < 337000 AND Innings_No = 1 AND Over_Id = 1 AND Ball_Id = 1

Database: olympics
Question: In which city the 2004 Summer was held?
Evidence: in which city refers to city_name; the 2004 Summer refers to games_name = '2004 Summer';
SQL: SELECT T2.city_name FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id INNER JOIN games AS T3 ON T1.games_id = T3.id WHERE T3.games_name = '2004 Summer'

Database: image_and_language
Question: Please list the classes of all the object samples in image no.1.
Evidence: classes of all the object samples refers to OBJ_CLASS; image no.1 refers to IMG_ID = 1
SQL: SELECT T1.OBJ_CLASS FROM OBJ_CLASSES AS T1 INNER JOIN IMG_OBJ AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.IMG_ID = 1 GROUP BY T1.OBJ_CLASS

Database: sales
Question: Write down the name of products whose sale quantity is more than 950.
Evidence: quantity is more than 950 refers to Quantity > 950;
SQL: SELECT DISTINCT T1.Name FROM Products AS T1 INNER JOIN Sales AS T2 ON T1.ProductID = T2.ProductID WHERE T2.Quantity > 950

Database: cs_semester
Question: List the courses' IDs and students' IDs who failed to pass the course.
Evidence: If grade is null or empty, it means that this student fails to pass the course;
SQL: SELECT course_id, student_id FROM registration WHERE grade IS NULL OR grade = ''

Database: cs_semester
Question: Find the full name and popularity of the professor who advises the most number of students.
Evidence: full name of the professor = first_name, last_name; most number of students refers to MAX(COUNT(student_id));
SQL: SELECT T1.first_name, T1.last_name, T1.popularity FROM prof AS T1 INNER JOIN RA AS T2 ON T1.prof_id = T2.prof_id GROUP BY T1.prof_id ORDER BY COUNT(T2.student_id) DESC LIMIT 1

Database: menu
Question: Which dish has the highest price on the menu "Zentral Theater Terrace"? Please give its name.
Evidence: highest price refers to MAX(Price); Zentral Theater Terrace is a name of menu;
SQL: SELECT T4.name FROM MenuItem AS T1 INNER JOIN MenuPage AS T2 ON T1.menu_page_id = T2.id INNER JOIN Menu AS T3 ON T2.menu_id = T3.id INNER JOIN Dish AS T4 ON T1.dish_id = T4.id WHERE T3.name = 'Zentral Theater Terrace' ORDER BY T1.price DESC LIMIT 1

Database: beer_factory
Question: Find the brand Id of the root beer which has the most number of customers who gave 1-star ratings.
Evidence: most number of customers who gave 1-star ratings refers to MAX(COUNT(StarRating = 1)); 1-star ratings refers to StarRating = 1;
SQL: SELECT BrandID FROM rootbeerreview WHERE StarRating = 1 GROUP BY BrandID ORDER BY COUNT(BrandID) DESC LIMIT 1

Database: authors
Question: Calculate the differences of the paper number with the journal name of IWC in 2000 and 2010.
Evidence: "IWC" is the ShortName of journal;  '2000' and '2010' are Year;  Difference = Subtract(Count(Paper.Id(Year = 2000)), Count(Paper.Id(Year = 2010)))
SQL: SELECT SUM(CASE WHEN T2.Year = 2000 THEN 1 ELSE 0 END) - SUM(CASE WHEN T2.Year = 2010 THEN 1 ELSE 0 END) AS DIFF FROM Journal AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.JournalId WHERE T1.ShortName = 'IWC'

Database: food_inspection
Question: How many routine inspections did Tiramisu Kitchen have?
Evidence: Tiramisu Kitchen is the name of the business; routine inspections refer to type = 'Routine - Unscheduled';
SQL: SELECT COUNT(T1.business_id) FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.type = 'Routine - Unscheduled' AND T2.name = 'Tiramisu Kitchen'

Database: retail_world
Question: What is the largest total price for an order?
Evidence: the largest total price for an order can be calculated as MAX(MULTIPLY(UnitPrice, Quantity, SUBTRACT(1-Discount)));
SQL: SELECT SUM(UnitPrice) FROM `Order Details` GROUP BY OrderID ORDER BY SUM(UnitPrice) DESC LIMIT 1

Database: chicago_crime
Question: What is the alderman's full name of the most crowded ward?
Evidence: alderman's full name refers to alderman_name_suffix, alderman_first_name, alderman_last_name; the most crowded refers to max(population)
SQL: SELECT alderman_name_suffix, alderman_first_name, alderman_last_name FROM Ward ORDER BY population DESC LIMIT 1

Database: ice_hockey_draft
Question: List out the seasons that Niklas Eckerblom played.
Evidence: FALSE;
SQL: SELECT DISTINCT T1.SEASON FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.PlayerName = 'Niklas Eckerblom'

Database: chicago_crime
Question: Please list the names of all the neighborhoods in Central Chicago.
Evidence: name of neighborhood refers to neighborhood_name; Central Chicago refers to side = 'Central'
SQL: SELECT T2.neighborhood_name FROM Community_Area AS T1 INNER JOIN Neighborhood AS T2 ON T1.community_area_no = T2.community_area_no WHERE T1.side = 'Central'

Database: world_development_indicators
Question: How many countries have reached their Adjusted net national income per capita (constant 2005 US$) indicator value to more than 1,000 but have not finished their external debt reporting?
Evidence: Adjusted net national income per capita (constant 2005 US$) is the IndicatorName; have not finished their external debt reporting means ExternalDebtReportingStatus = 'Preliminary'
SQL: SELECT COUNT(T1.CountryCode) FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.IndicatorName = 'Adjusted net national income per capita (constant 2005 US$)' AND T1.ExternalDebtReportingStatus = 'Preliminary' AND T2.Value > 1000

Database: university
Question: Provide the ranking system ID of the Center for World University Rankings.
Evidence: the 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: professional_basketball
Question: What is the average height of an East conference All-star player?
Evidence: average height refers to avg(height)
SQL: SELECT AVG(DISTINCT height) FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE conference = 'East'

Database: movie_platform
Question: Who is the director of the most popular movie of all time and when was it released? Indicate the average rating score of the users who were on a trialist when they rated the movie.
Evidence: most popular movie of all time refers to MAX(movie_popularity); a trialist refers to user_trialist = 1; average rating score = AVG(rating_score)
SQL: SELECT T1.director_name, T1.movie_release_year , SUM(T2.rating_score) / COUNT(T2.user_id) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.user_trialist = 1 ORDER BY T1.movie_popularity DESC LIMIT 1

Database: food_inspection_2
Question: How many inspections did All Style Buffet Restaurant have?
Evidence: All Style Buffet refers to dba_name = 'All Style Buffet'; Restaurant refers to facility_type = 'Restaurant'
SQL: SELECT COUNT(T2.inspection_id) FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T1.facility_type = 'Restaurant' AND T1.dba_name = 'All Style Buffet'