Database: beer_factory
Question: Please name any three root beer brands that have the highest market evaluation and acceptance.
Evidence: root beer brands refers to BrandName; highest market evaluation and acceptance refers to MAX(COUNT(StarRating = 5));
SQL: SELECT DISTINCT T1.BrandName FROM rootbeerbrand AS T1 INNER JOIN rootbeerreview AS T2 ON T1.BrandID = T2.BrandID WHERE T2.StarRating = 5 LIMIT 3

Database: public_review_platform
Question: Among the businesses without attribute, how many businesses located in Gilbert?
Evidence: without attribute refers to attribute_value = 'None'; in Gilbert refers to city = 'Gilbert'
SQL: SELECT COUNT(T2.business_id) FROM Business_Attributes AS T1 INNER JOIN Business AS T2 ON T1.business_id = T2.business_id WHERE T2.city = 'Gilbert' AND T1.attribute_value IN ('None', 'no', 'false')

Database: address
Question: Name 10 cities with their states that are under the Lexington-Fayette, KY office of the Canada Border Services Agency.
Evidence: "Lexington-Fayette, KY" is the CBSA_name
SQL: SELECT DISTINCT T2.city, T2.state FROM CBSA AS T1 INNER JOIN zip_data AS T2 ON T1.CBSA = T2.CBSA WHERE T1.CBSA_name = 'Lexington-Fayette, KY' LIMIT 10

Database: video_games
Question: Calculate the total sales in all regions with game platform ID 66.
Evidence: total sales in all regions = MULTIPLY(SUM(num_sales), 100000);
SQL: SELECT SUM(T.num_sales) * 100000 FROM region_sales AS T WHERE T.game_platform_id = 66

Database: shipping
Question: Calculate the population density of the city as the destination of shipment no.1369.
Evidence: shipment no. 1369 refers to ship_id = 1369; population density refers to Divide (area, population)
SQL: SELECT T2.area / T2.population FROM shipment AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id WHERE T1.ship_id = '1369'

Database: retail_world
Question: What is the full address of Rattlesnake Canyon Grocery?
Evidence: full address refers to ShipAddress, ShipCity, ShipRegion,ShipPostalCode, ShipCountry; 'Rattlesnake Canyon Grocery' is a ShipName;
SQL: SELECT DISTINCT ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry FROM Orders WHERE ShipName = 'Rattlesnake Canyon Grocery'

Database: simpson_episodes
Question: Which episode did the composer win for Outstanding Music Composition for a Series (Original Dramatic Score) with more than 200 votes?
Evidence: more than 200 votes refer to votes > 200; composer refers to role = 'composer'; Outstanding Music Composition for a Series (Original Dramatic Score) refers to award = 'Outstanding Music Composition for a Series (Original Dramatic Score)'
SQL: SELECT DISTINCT T1.episode_id FROM Award AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T1.role = 'composer' AND T1.award = 'Outstanding Music Composition for a Series (Original Dramatic Score)' AND T2.votes > 200;

Database: student_loan
Question: List all students in the air force and which school they were enrolled at.
Evidence: in the air force refers to organ = 'air_force';
SQL: SELECT T1.name, T1.school FROM enrolled AS T1 INNER JOIN enlist AS T2 ON T1.`name` = T2.`name` WHERE T2.organ = 'air_force'

Database: regional_sales
Question: List all the order numbers along with its product name for each order under the sales team of 'Douglas Tucker'.
SQL: SELECT DISTINCT T1.ProductID, T1.`Product Name` FROM Products AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._ProductID = T1.ProductID INNER JOIN `Sales Team` AS T3 ON T3.SalesTeamID = T2._SalesTeamID WHERE T3.`Sales Team` = 'Douglas Tucker'

Database: retails
Question: How many part supplies are close to being out of stock?
Evidence: close to being out of stock refers to ps_availqty < 10
SQL: SELECT COUNT(ps_suppkey) FROM partsupp WHERE ps_availqty < 10

Database: synthea
Question: List the full names of patients with nut allergy.
Evidence: full names = first, last; nut allergy refers to allergies.DESCRIPTION = 'Allergy to nut';
SQL: SELECT DISTINCT T1.first, T1.last FROM patients AS T1 INNER JOIN allergies AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Allergy to nut'

Database: software_company
Question: Describe the average income per month and yearly income of the geographic ID in which customer of ID "209556" and "290135".
Evidence: the average income per month refers to INCOME_K; yearly income of geographic ID refers to GEOID where MULTIPLY(INHABITANTS_K, INCOME_K, 12);
SQL: SELECT T2.INCOME_K, T2.INHABITANTS_K * T2.INCOME_K * 12 FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID WHERE T1.ID = 209556 OR T1.ID = 290135

Database: retails
Question: Among the providers in Argentina, which supplier has an account that is in debt?
Evidence: Argentina refers to n_name = 'ARGENTINA'; supplier refers to s_name; an account in debt refers to s_acctbal < 0
SQL: SELECT T1.s_name FROM supplier AS T1 INNER JOIN nation AS T2 ON T1.s_nationkey = T2.n_nationkey WHERE T1.s_acctbal < 0 AND T2.n_name = 'ARGENTINA'

Database: cars
Question: State the origin country of the fastest car in the database.
Evidence: origin country refers to country; the fastest refers to max(horsepower)
SQL: SELECT T3.country FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country ORDER BY T1.horsepower DESC LIMIT 1

Database: shipping
Question: Calculate the average number of shipments that Zachery Hicks shipped in year 2017.
Evidence: in year 2017 refers to CAST(ship_date AS DATE) = 2017; percentage = Divide (Count(ship_id where first_name = 'Zachery' AND last_name = 'Hicks'), Count(ship_id)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T2.first_name = 'Zachery' AND T2.last_name = 'Hicks' THEN T1.ship_id ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM shipment AS T1 INNER JOIN driver AS T2 ON T1.driver_id = T2.driver_id WHERE STRFTIME('%Y', T1.ship_date) = '2017'

Database: books
Question: Indicate the ISBN13 of all the books that have less than 140 pages and more than 135.
Evidence: ISBN13 refers to isbn13; less than 140 pages and more than 135 refers to num_pages > 135 AND num_pages < 140;
SQL: SELECT isbn13 FROM book WHERE num_pages < 140 AND num_pages > 135

Database: disney
Question: What is the genre of the movie whose villain is Commander Rourke?
Evidence: FALSE;
SQL: SELECT T2.genre FROM characters AS T1 INNER JOIN movies_total_gross AS T2 ON T2.movie_title = T1.movie_title WHERE T1.villian = 'Commander Rourke'

Database: world_development_indicators
Question: What are the subjects of series that have a restricted type of license?
Evidence: subjects refers to topic; a restricted type of license refers to  licenseType = 'Restricted'
SQL: SELECT DISTINCT Topic FROM Series WHERE LicenseType = 'Restricted'

Database: movie_platform
Question: What is the average score of the movie "The Fall of Berlin" in 2019?
Evidence: The Fall of Berlin' is movie_title; in 2019 refers to rating_timestamp_utc = 2019; Average score refers to Avg(rating_score);
SQL: SELECT SUM(T1.rating_score) / COUNT(T1.rating_id) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_timestamp_utc LIKE '2019%' AND T2.movie_title LIKE 'The Fall of Berlin'

Database: cookbook
Question: What ingredients does the longest cooking time recipe have?
Evidence: the longest cooking time refers to MAX(cook_min)
SQL: SELECT T3.name FROM Recipe AS T1 INNER JOIN Quantity AS T2 ON T1.recipe_id = T2.recipe_id INNER JOIN Ingredient AS T3 ON T3.ingredient_id = T2.ingredient_id ORDER BY T1.cook_min DESC LIMIT 1

Database: retail_world
Question: What are the companies that have the same phone area code as 171?
Evidence: phone area code as 171 refers to Phone LIKE '(171)%'; companies refer to CompanyName;
SQL: SELECT CompanyName FROM Customers WHERE Phone LIKE '(171)%'

Database: cs_semester
Question: Give the number of research postgraduate students.
Evidence: RPG is an abbreviated name of research postgraduate student in which type = 'RPG';
SQL: SELECT COUNT(student_id) FROM student WHERE type = 'RPG'