Database: retail_world
Question: Which region does territory id 2116 belong to?
Evidence: region refers to RegionDescription
SQL: SELECT T2.RegionDescription FROM Territories AS T1 INNER JOIN Region AS T2 ON T1.RegionID = T2.RegionID WHERE T1.TerritoryID = 2116

Database: books
Question: Among the books that cost less than 1 dollar, how many were published by Berkley Trade?
Evidence: book cost less than 1 dollar refers to price < 1; 'Berkley Trade' is the publisher_name;
SQL: SELECT COUNT(*) FROM publisher AS T1 INNER JOIN book AS T2 ON T1.publisher_id = T2.publisher_id INNER JOIN order_line AS T3 ON T3.book_id = T2.book_id WHERE T1.publisher_name = 'Berkley' AND T3.price < 1

Database: simpson_episodes
Question: Which episode has the most vote for 10 stars rating?
Evidence: 10 stars rating refers to stars = 10; most vote refers to Max(votes)
SQL: SELECT T1.title FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T2.stars = 10 ORDER BY T1.votes DESC LIMIT 1;

Database: menu
Question: What is the occasion for menu with ID 12463?
Evidence: FALSE;
SQL: SELECT occasion FROM Menu WHERE id = 12463

Database: simpson_episodes
Question: Among episodes aired in 2009, which episode has received the worst response based on the rating.
Evidence: aired in 2009 refers to year(air_date) = 2009; received the worst response based on the rating refers to MIN(rating)
SQL: SELECT episode_id FROM Episode WHERE air_date LIKE '2009%' ORDER BY rating LIMIT 1;

Database: student_loan
Question: How many students enlist in the air force organization?
Evidence: organization refers to organ; organ = 'air_force';
SQL: SELECT COUNT(name) FROM enlist WHERE organ = 'air_force'

Database: language_corpus
Question: For the word "grec", what is the percentage of the appearances in the "Art" Wikipedia page have among all the appearances?
Evidence: grec refers to word = 'grec'; Art refers to title = 'Art'; percentage is DIVIDE(occurrences(grec), occurences(Art))*100
SQL: SELECT CAST(SUM(CASE WHEN T3.title = 'Art' THEN T2.occurrences ELSE 0 END) AS REAL) * 100 / SUM(T2.occurrences) FROM words AS T1 INNER JOIN pages_words AS T2 ON T1.wid = T2.wid INNER JOIN pages AS T3 ON T2.pid = T3.pid WHERE T1.word = 'grec'

Database: beer_factory
Question: How many breweries are located in North America?
Evidence: North America refers to country = 'United States'; North America is the name of continent where country = 'United States' is located;
SQL: SELECT COUNT(BrandID) FROM rootbeerbrand WHERE Country = 'United States'

Database: retails
Question: How many of the line items have been shipped by rail with a quantity less than 30?
Evidence: shipped by rail refers to l_shipmode = 'RAIL'; quantity less than 30 refers to l_quantity < 30;
SQL: SELECT COUNT(l_linenumber) FROM lineitem WHERE l_quantity < 30 AND l_shipmode = 'RAIL'

Database: student_loan
Question: Provide the name of disabled male students that are unemployed.
Evidence: disabled male students that are unemployed refers to unemployed.name = male.name = disabled.name;
SQL: SELECT T2.NAME FROM unemployed AS T1 INNER JOIN male AS T2 ON T1.name = T2.name INNER JOIN disabled AS T3 ON T3.name = T2.name

Database: cars
Question: When was the $32650.65157 car introduced to the market? State the year.
Evidence: the $32650.65157 car refers to price = 32650.65157; year refers to model
SQL: SELECT T1.model FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T2.price = '32650.65157'

Database: european_football_1
Question: Of all the teams that played as a team away against Caen in the 2010 season, which one has the highest winning percentage?
Evidence: Caen refers to HomeTeam; which one refers to AwayTeam; the highest winning percentage = MAX(DIVIDE(COUNT(FTR = 'A' where HomeTeam = 'Caen', season = '2010')), COUNT(Div where HomeTeam = 'Caen', season = '2010')) as percentage;
SQL: SELECT AwayTeam FROM matchs WHERE HomeTeam = 'Caen' AND season = 2010 AND FTR = 'A' GROUP BY AwayTeam ORDER BY COUNT(AwayTeam) DESC LIMIT 1

Database: social_media
Question: What is the gender of the user whose tweet got 535 retweets?
Evidence: tweet got 535 retweets refers to RetweetCount = 535
SQL: SELECT T2.Gender FROM twitter AS T1 INNER JOIN user AS T2 ON T1.UserID = T2.UserID WHERE T1.RetweetCount = 535

Database: cs_semester
Question: What is the male and female ratio among the professors?
Evidence: DIVIDE(COUNT(prof_id where gender = 'Male'), COUNT(prof_id where gender = 'Female'));
SQL: SELECT CAST(SUM(CASE WHEN gender = 'Male' THEN 1 ELSE 0 END) AS REAL) / SUM(CASE WHEN gender = 'Female' THEN 1 ELSE 0 END) FROM prof

Database: codebase_comments
Question: What is the solution's path of method "HtmlSharp.HtmlParser.Feed"?
Evidence: solution's path refers to Path; method refers to Name; Name = 'HtmlSharp.HtmlParser.Feed';
SQL: SELECT T1.Path FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.Name = 'HtmlSharp.HtmlParser.Feed'

Database: video_games
Question: List the name of all games published in Japan.
Evidence: name of games refers to game_name; Japan refers to region_name = 'Japan';
SQL: SELECT T1.game_name FROM game AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.game_id INNER JOIN game_platform AS T3 ON T2.id = T3.game_publisher_id INNER JOIN region_sales AS T4 ON T3.id = T4.game_platform_id INNER JOIN region AS T5 ON T4.region_id = T5.id WHERE T5.region_name = 'Japan'

Database: cookbook
Question: Please list the titles of all the recipes that are salt/sodium-free.
Evidence: salt/sodium-free refers to sodium < 5
SQL: SELECT T1.title FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id WHERE T2.sodium < 5

Database: genes
Question: What kind of expression correlation occurs in physical type interacting gene pairs and what percentage of these are negatively correlated?
Evidence: If the Expression_Corr value is negative then it's negatively correlated. Percentage of Negative Correlation = count(negative Expression_Corr physical type) / count(Expression_Corr physical type) * 100%
SQL: SELECT Expression_Corr FROM Interactions WHERE Type = 'Physical' UNION ALL SELECT CAST(SUM(Expression_Corr < 0) AS REAL) * 100 / COUNT(*) FROM Interactions WHERE Type = 'Physical'

Database: food_inspection_2
Question: How many restaurants were inspected on 2015/5/8?
Evidence: restaurant refers to facility_type = 'Restaurant'; on 2015/5/8 refers to inspection_date = '2015-05-08'
SQL: SELECT COUNT(T2.license_no) FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T2.inspection_date = '2015-05-08' AND T1.facility_type = 'Restaurant'

Database: book_publishing_company
Question: Which date has the most ordered quantity? What is the total order quantity on that day?
Evidence: total quantity refers to qty; most ordered quantity refers to order with the highest quantity where MAX(sum(qty))
SQL: SELECT ord_date, SUM(qty) FROM sales GROUP BY ord_date ORDER BY SUM(qty) DESC LIMIT 1

Database: public_review_platform
Question: How many Yelp_Businesses in Arizona have a Elitestar rating of over 4?
Evidence: Arizona refers to state = 'AZ'; Elitestar rating of over 4 refers to stars > 4;
SQL: SELECT COUNT(business_id) FROM Business WHERE state LIKE 'AZ' AND stars > 4

Database: college_completion
Question: Among the black students in 2011, list the institution site and name of those who has 20 t0 30 degree-seeking students in the cohort.
Evidence: black refers to race = 'B'; in 2011 refers to year = '2011'; institution name refers to chronname; 20 to 30 degree-seeking students in the cohort refers to grad_cohort BWEEN 20 AND 30;
SQL: SELECT DISTINCT T1.site, T1.chronname FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T2.year = 2011 AND T2.race = 'B' AND T2.grad_cohort BETWEEN 20 AND 30