Database: retail_world
Question: How many territories are there in the region with the highest number of territories?
Evidence: highest number of territories refers to max(TerritoryID)
SQL: SELECT COUNT(T2.RegionDescription), T1.TerritoryDescription, COUNT(*) AS num FROM Territories AS T1 INNER JOIN Region AS T2 ON T1.RegionID = T2.RegionID GROUP BY T1.TerritoryDescription ORDER BY num DESC LIMIT 1

Database: student_loan
Question: Which female students had never been absent?
Evidence: had never been absent refers to month = 0
SQL: SELECT T2.name FROM male AS T1 INNER JOIN longest_absense_from_school AS T2 ON T1.name <> T2.name WHERE T2.month = 0

Database: talkingdata
Question: Identify by their id all the apps that belong to the game-stress reliever category.
Evidence: id refers to device_id;
SQL: SELECT T2.app_id FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T1.label_id = T2.label_id WHERE T1.category = 'game-stress reliever'

Database: synthea
Question: State the average period of Ms. Angelena Kertzmann's several normal pregnancies.
Evidence: DIVIDE(SUBTRACT(stop time - start time), COUNT(DESCRIPTION = 'Normal pregnancy')));
SQL: SELECT CAST(SUM(strftime('%J', T2.STOP) - strftime('%J', T2.START)) AS REAL) / COUNT(T2.PATIENT) FROM patients AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT WHERE T1.prefix = 'Ms.' AND T1.first = 'Angelena' AND T1.last = 'Kertzmann' AND T2.description = 'Normal pregnancy'

Database: video_games
Question: Among games sold in Europe, list the platform ID of games with sales lesser than 30% of the average number of sales.
Evidence: Europe refers to region_name = 'Europe'; sales lesser than 30% of the average number of sales refers to SUM(num_sales) < MULTIPLY(AVG(num_sales), 0.3);
SQL: SELECT DISTINCT T3.platform_id FROM region AS T1 INNER JOIN region_sales AS T2 ON T1.id = T2.region_id INNER JOIN game_platform AS T3 ON T2.game_platform_id = T3.id WHERE T1.region_name = 'Europe' AND T2.num_sales * 100 * 100000 < ( SELECT AVG(T2.num_sales * 100000) * 30 FROM region AS T1 INNER JOIN region_sales AS T2 ON T1.id = T2.region_id WHERE T1.region_name = 'Europe' )

Database: public_review_platform
Question: List out city name of businesses which have medium length of review.
Evidence: medium length of review refers to review_length = 'Medium'
SQL: SELECT DISTINCT T1.city FROM Business AS T1 INNER JOIN Reviews AS T2 ON T1.business_id = T2.business_id WHERE T2.review_length = 'Medium'

Database: donor
Question: Which school district was Future Einsteins Of America project located at?
Evidence: Future Einsteins of America refer to title
SQL: SELECT T1.school_district FROM projects AS T1 INNER JOIN essays AS T2 ON T1.projectid = T2.projectid WHERE T2.title LIKE 'Future Einsteins Of America'

Database: books
Question: On what dates were books ordered at a price of 16.54?
Evidence: price of 16.54 refers to price = 16.54; dates the book ordered refers to order_date
SQL: SELECT T1.order_date FROM cust_order AS T1 INNER JOIN order_line AS T2 ON T1.order_id = T2.order_id WHERE T2.price = 16.54

Database: retail_world
Question: For the order from "HILAA" on 1997/12/25, what was the total quantity of the products in that order?
Evidence: HILLA refers to CustomerID = 'HILAA'; on 1997/12/25 refers to OrderDate = '1997/12/25';
SQL: SELECT SUM(T2.Quantity) FROM Orders AS T1 INNER JOIN `Order Details` AS T2 ON T1.OrderID = T2.OrderID WHERE T1.CustomerID = 'HILAA' AND T1.OrderDate LIKE '1997-12-25%'

Database: authors
Question: How many journals do not have a website?
Evidence: do not have a website refers to HomePage = ''
SQL: SELECT COUNT(HomePage) FROM Journal WHERE HomePage = ''

Database: language_corpus
Question: How many biword pairs contain the word "base" as the second word?
Evidence: base refers to word = 'base'; SUM(w2nd) where w2nd = wid for word = 'base'
SQL: SELECT COUNT(w1st) FROM biwords WHERE w2nd = ( SELECT wid FROM words WHERE word = 'base' )

Database: retails
Question: Find and list the part key of the parts which has an above-average retail price.
Evidence: part key of the parts which has an above-average retail price refer to p_partkey where p_retailprice > AVG(p_retailprice);
SQL: SELECT p_partkey FROM part WHERE p_retailprice > ( SELECT AVG(p_retailprice) FROM part )

Database: simpson_episodes
Question: In which country was the winner of the Outstanding Voice-Over Performance award of 2009 born?
Evidence: "Outstanding Voice-Over Performance" is the award; 2009 refers to year = 2009; 'Winner' is the result; country refers to birth_country
SQL: SELECT T1.birth_country FROM Person AS T1 INNER JOIN Award AS T2 ON T1.name = T2.person WHERE T2.award = 'Outstanding Voice-Over Performance' AND T2.year = 2009 AND T2.result = 'Winner';

Database: university
Question: What is the ranking criteria ID of Brown University in 2014?
Evidence: Brown University refers to university_name = 'Brown University'; in 2014 refers to year = 2014
SQL: SELECT T1.ranking_criteria_id FROM university_ranking_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T2.university_name = 'Brown University' AND T1.year = 2014

Database: chicago_crime
Question: How many incidents have the general description of "ASSAULT" in the IUCR classification?
Evidence: general description refers to primary_description; 'ASSAULT' is the primary_description; incidents refers to iucr_no
SQL: SELECT COUNT(*) FROM IUCR WHERE primary_description = 'ASSAULT'

Database: retail_world
Question: What is the most expensive product?
Evidence: product refers to ProductName; most expensive refers to max(UnitPrice)
SQL: SELECT ProductName FROM Products WHERE UnitPrice = ( SELECT MAX(UnitPrice) FROM Products )

Database: coinmarketcap
Question: Name the coin that has the highest market capitalization for all transactions in 2018.
Evidence: highest market capitalization refers to max(market_cap); in 2018 refers to year(date) = 2018
SQL: SELECT T1.name FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T2.date LIKE '2018%' AND T2.market_cap = ( SELECT MAX(market_cap) FROM historical WHERE STRFTIME('%Y', date) = '2018' )

Database: airline
Question: Provide the date and tail number of flight with air carrier "Ross Aviation Inc.: GWE".
Evidence: date of flight refers to FL_DATE; tail number of flight refers to TAIL_NUM; Ross Aviation Inc.: GWE refers to Description = 'Ross Aviation Inc.: GWE';
SQL: SELECT T1.FL_DATE, T1.TAIL_NUM FROM Airlines AS T1 INNER JOIN `Air Carriers` AS T2 ON T1.OP_CARRIER_AIRLINE_ID = T2.Code WHERE T2.Description = 'Ross Aviation Inc.: GWE'

Database: food_inspection
Question: Please list the names of the restaurants that had a low risk violation in inspections in 2014.
Evidence: inspection in 2014 refers to year(date) = 2014; low risk violations refer to risk_category = 'Low Risk';
SQL: SELECT DISTINCT T2.name FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE STRFTIME('%Y', T1.`date`) = '2014' AND T1.risk_category = 'Low Risk'

Database: superstore
Question: What was the total cost of Xerox 1952 ordered by Aimee Bixby on 2014/9/10?
Evidence: Xerox 1952 is a "Product Name"; ordered by Aimee Bixby refers to "Customer Name" = 'Aimee Bixby'; on 2014/9/10 refers to "Order Date" = date('2014-09-10'); total cost refers to SUTRACT(MULTIPLY(DIVIDE(Sales, SUTRACT(1, discount)), Quantity), Profit)
SQL: SELECT DISTINCT (T2.Sales / (1 - T2.discount)) * T2.Quantity - Profit FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T2.`Product ID` WHERE T1.`Customer Name` = 'Aimee Bixby' AND T3.`Product Name` = 'Xerox 1952' AND T2.`Order Date` = '2014-09-10'

Database: movie_3
Question: List the actors' IDs who have "KILMER" as last name.
SQL: SELECT actor_id FROM actor WHERE last_name = 'KILMER'