Database: video_games
Question: Provide the name of games released in 2015.
Evidence: names of games refers to game_name; released in 2015 refers to release_year = 2015;
SQL: SELECT T3.game_name FROM game_platform AS T1 INNER JOIN game_publisher AS T2 ON T1.game_publisher_id = T2.id INNER JOIN game AS T3 ON T2.game_id = T3.id WHERE T1.release_year = 2015

Database: video_games
Question: Give the name of the publisher of the game ID 75.
Evidence: name of publisher refers to publisher_name; the game ID 75 refers to game_id = 75
SQL: SELECT T2.publisher_name FROM game_publisher AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id WHERE T1.game_id = 75

Database: ice_hockey_draft
Question: List the name of players who have a height over 5'9.
Evidence: names of players refers to PlayerName; height over 5'9 refers to height_in_inch > '5''9"';
SQL: SELECT T1.PlayerName FROM PlayerInfo AS T1 INNER JOIN height_info AS T2 ON T1.height = T2.height_id WHERE T2.height_in_inch > '5''9"'

Database: restaurant
Question: Which county in northern California has the highest number of cities?
Evidence: northern California refers to region = 'northern california'; the highest number of cities refers to max(count(city))
SQL: SELECT county FROM geographic WHERE region = 'northern california' GROUP BY county ORDER BY COUNT(city) DESC LIMIT 1

Database: books
Question: Among the books published by Birlinn in 2008, how many books have pages around 600 to 700?
Evidence: "Birlinn" is the publisher_name; books have pages around 600 to 700 refers to num_pages BETWEEN 600 AND 700; in 2008 refers to SUBSTR(publication_date, 1, 4) = '2008'
SQL: SELECT COUNT(*) FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id WHERE T2.publisher_name = 'Birlinn' AND STRFTIME('%Y', T1.publication_date) = '2008' AND T1.num_pages BETWEEN 600 AND 700

Database: legislator
Question: What is the numeric ID of Chris Van Hollen on GovTrack.us?
Evidence: Chris Van Hollen is an official_full_name; numeric ID on GovTrack.us refers to govtrack
SQL: SELECT T2.govtrack FROM current AS T1 INNER JOIN `social-media` AS T2 ON T2.bioguide = T1.bioguide_id WHERE T1.official_full_name = 'Chris Van Hollen'

Database: public_review_platform
Question: Is the Yelp business No. 14033 good for supper?
Evidence: business no. 14033 refers to business_id = 14033; good for supper refers to attribute_name = 'good_for_dinner'
SQL: SELECT T1.attribute_value FROM Business_Attributes AS T1 INNER JOIN Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T2.attribute_name = 'good_for_dinner' AND T1.business_id = 14033

Database: professional_basketball
Question: What are the basketball players' BMI ranges?
Evidence: BMI = Multiply(Divide(weight, Multiply(height, height)), 703)
SQL: SELECT MIN(CAST(weight AS REAL) / (height * height)) , MAX(CAST(weight AS REAL) / (height * height)) FROM players

Database: superstore
Question: Who is the customer from the West region that received the highest discount?
Evidence: received the highest discount refers to MAX(discount); customer refers to "Customer Name"
SQL: SELECT T2.`Customer Name` FROM west_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T1.Region = 'West' ORDER BY T1.Discount DESC LIMIT 1

Database: food_inspection
Question: List the business' name and risk category of businesses with a score greater than the 80% of average score of all businesses.
Evidence: score greater than the 80% of average score of all businesses refers to score > MULTIPLY(0.8, avg(score) from inspections);
SQL: SELECT DISTINCT T1.name, T3.risk_category FROM businesses AS T1 INNER JOIN inspections AS T2 ON T1.business_id = T2.business_id INNER JOIN violations AS T3 ON T1.business_id = T3.business_id WHERE T2.score > 0.8 * ( SELECT AVG(score) FROM inspections )

Database: sales
Question: How much is the total amount of sales handled by Heather McBadden?
Evidence: total amount of sales = SUM(MULTIPLY(Quantity, Price));
SQL: SELECT SUM(T2.Quantity * T3.Price) FROM Employees AS T1 INNER JOIN Sales AS T2 ON T1.EmployeeID = T2.SalesPersonID INNER JOIN Products AS T3 ON T2.ProductID = T3.ProductID WHERE T1.FirstName = 'Heather' AND T1.LastName = 'McBadden'

Database: public_review_platform
Question: What are the opening hours of business number 53 on Friday?
Evidence: opening hours refers to opening_time; business number refers to business_id; Friday refers to day_of_week = 'Friday';
SQL: SELECT T1.closing_time - T1.opening_time AS "opening hours" FROM Business_Hours AS T1 INNER JOIN Days AS T2 ON T1.day_id = T2.day_id WHERE T2.day_of_week LIKE 'Friday' AND T1.business_id = 53

Database: student_loan
Question: What is the longest time for a student from the navy department to be absent from school?
Evidence: navy department refers to organ = 'navy'; longest time to be absent from school refers to MAX(month)
SQL: SELECT T1.month FROM longest_absense_from_school AS T1 INNER JOIN enlist AS T2 ON T1.`name` = T2.`name` WHERE T2.organ = 'navy' ORDER BY T1.`month` DESC LIMIT 1

Database: app_store
Question: Among the role playing game genre, how many are targeted to teens and what is their average sentiment polarity score?
Evidence: targeted to teen refers to Content Rating = 'Teen'; average = AVG(Sentiment_Polarity);
SQL: SELECT COUNT(T1.App), AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1."Content Rating" = 'Teen' AND T1.Genres = 'Role Playing'

Database: chicago_crime
Question: How many different types of crimes, according to the primary description, have occurred in the Hermosa neighborhood?
Evidence: "Hermosa" is the neighborhood_name
SQL: SELECT SUM(CASE WHEN T4.neighborhood_name = 'Hermosa' THEN 1 ELSE 0 END) FROM IUCR AS T1 INNER JOIN Crime AS T2 ON T2.iucr_no = T1.iucr_no INNER JOIN Community_Area AS T3 ON T3.community_area_no = T2.community_area_no INNER JOIN Neighborhood AS T4 ON T4.community_area_no = T3.community_area_no

Database: movielens
Question: What is the ID of actors that acted in the movies most viewed by audience with occupation 5?
Evidence: The audience and users are the same meaning
SQL: SELECT T3.actorid FROM users AS T1 INNER JOIN u2base AS T2 ON T1.userid = T2.userid INNER JOIN movies2actors AS T3 ON T2.movieid = T3.movieid WHERE T1.occupation = 5 GROUP BY T2.movieid ORDER BY COUNT(T1.userid) DESC LIMIT 1

Database: language_corpus
Question: In which Wikipedia page does the word ID No. 174 have the most appearances? Give the title.
Evidence: word ID No. 174 refers to wid = 174; appearances refers to pages_words_sampling.occurrences
SQL: SELECT title FROM pages WHERE pid = ( SELECT pid FROM pages_words WHERE wid = 174 ORDER BY occurrences DESC LIMIT 1 )

Database: food_inspection_2
Question: Where does the employee named "Standard Murray" live?
Evidence: address refers to address, city, state
SQL: SELECT address, city, state FROM employee WHERE first_name = 'Standard' AND last_name = 'Murray'

Database: cars
Question: Which car consumes fuel the most and has the highest price?
Evidence: consumes fuel the most refers to min(mpg); has the highest price refers to max(price)
SQL: SELECT T1.car_name FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID ORDER BY T1.mpg DESC, T2.price DESC LIMIT 1

Database: software_company
Question: Among the customers from a place with more than 20,000 and less than 30,000 inhabitants, how many of them are Machine-op-inspcts?
Evidence: place with more than 20,000 and less than 30,000 inhabitants refers to GEOID where INHABITANTS_K BETWEEN 20 AND 30; OCCUPATION = 'Machine-op-inspct';
SQL: SELECT COUNT(T1.GEOID) FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID WHERE T1.OCCUPATION = 'Machine-op-inspct' AND T2.INHABITANTS_K > 20 AND T2.INHABITANTS_K < 30