Database: superstore
Question: What percentage do items under the category of 'Furniture' make up the total number of items ordered that are shipped as standard in the West region?
Evidence: shipped as standard refers to "Ship Mode" = 'Standard Class'; Region = 'West'; percentage refers to DIVIDE(SUM(Quantity where Category = 'Furniture'), SUM(Quantity)) * 1.0
SQL: SELECT CAST(SUM(CASE  WHEN T2.Category = 'Furniture' THEN 1 ELSE 0 END) AS REAL) * 100 / SUM(T1.Quantity) FROM west_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.Region = 'West' AND T1.`Ship Mode` = 'Standard Class'

Database: address
Question: State the male population for all zip code which were under the Berlin, NH CBSA.
Evidence: "Berlin, NH" is the CBSA_name
SQL: SELECT T2.male_population FROM CBSA AS T1 INNER JOIN zip_data AS T2 ON T1.CBSA = T2.CBSA WHERE T1.CBSA_name = 'Berlin, NH' GROUP BY T2.male_population

Database: student_loan
Question: Which school is student829 enrolled in?
SQL: SELECT school FROM enrolled WHERE name = 'student829'

Database: professional_basketball
Question: List the year, team and coach that with winning rate of above 75%.
Evidence: team refers to teams.name; coach refers to coachID; winning rate of above 75% refers to divide(won, add(won, lost)) > 0.75
SQL: SELECT DISTINCT T1.year, T2.name, T1.coachID FROM coaches AS T1 INNER JOIN teams AS T2 ON T1.tmID = T2.tmID WHERE CAST(T1.won AS REAL) / CAST((T1.won + T1.lost) AS REAL) > 0.75

Database: books
Question: Which language was book id 1405 written in?
Evidence: language written in refers to language_name;
SQL: SELECT T2.language_name FROM book AS T1 INNER JOIN book_language AS T2 ON T1.language_id = T2.language_id WHERE T1.book_id = 1405

Database: college_completion
Question: Between the Ivy League Schools, which school's state have the lowest sate appropriations to higher education in fiscal year 2011 per resident?
Evidence: Ivy League Schools refers to chronname = 'Brown University' or chronname = 'Columbia University' or chronname = 'Cornell University' or chronname = 'Dartmouth College' or chronname = 'Harvard University' or chronname = 'Princeton University' or chronname = 'University of Pennsylvania' or chronname = 'Yale University'; lowest state appropriations to higher education in fiscal year 2011 per resident refers to MIN(state_appr_value);
SQL: SELECT T1.state FROM institution_details AS T1 INNER JOIN state_sector_details AS T2 ON T2.state = T1.state WHERE T1.chronname IN ( 'Brown University', 'Columbia University', 'Cornell University', 'Dartmouth College', 'Harvard University', 'Princeton University', 'University of Pennsylvania', 'Yale University' ) GROUP BY T1.state ORDER BY SUM(T2.state_appr_value) ASC LIMIT 1

Database: olympics
Question: Please list the names of the Olympic games that were held in London.
Evidence: held in London refers to city_name = 'London';
SQL: SELECT T3.games_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 T2.city_name = 'London'

Database: language_corpus
Question: Calculate the average number of different words that appear on all pages whose title begins with A.
Evidence: DIVIDE(SUM(words WHERE title = 'A%'), COUNT(words WHERE title = 'A%')) as percentage; A is a letter;
SQL: SELECT AVG(words) FROM pages WHERE title LIKE 'A%'

Database: donor
Question: Name the vendors that sell the item Classroom Keepers Management Center.
Evidence: vendor refer to vendor_name; Classroom Keepers Management Center refer to item_name
SQL: SELECT DISTINCT vendor_name FROM resources WHERE item_name = 'Classroom Keepers Management Center'

Database: restaurant
Question: What counties are not in the Bay Area Region?
Evidence: not in the Bay Area region refers to region ! = 'bay area'
SQL: SELECT DISTINCT county FROM geographic WHERE region != 'bay area'

Database: app_store
Question: What genre does Honkai Impact 3rd belong to?
Evidence: Honkai Impact 3rd is the App;
SQL: SELECT DISTINCT Genres FROM playstore WHERE App = 'Honkai Impact 3rd'

Database: music_platform_2
Question: List all content reviewed for podcast with the best rating under the 'fiction' category. State the podcast title.
Evidence: 'fiction' is the category name; best rating refers to rating = 5; content reviewed refers to content
SQL: SELECT DISTINCT T2.title FROM categories AS T1 INNER JOIN podcasts AS T2 ON T2.podcast_id = T1.podcast_id INNER JOIN reviews AS T3 ON T3.podcast_id = T2.podcast_id WHERE T3.rating = 5 AND T1.category = 'fiction'

Database: retails
Question: What are the countries that belong to Africa?
Evidence: country is nation name which refers to n_name; Africa is region name refers to r_name = 'Africa'
SQL: SELECT T2.n_name FROM region AS T1 INNER JOIN nation AS T2 ON T1.r_regionkey = T2.n_regionkey WHERE T1.r_name = 'Africa'

Database: regional_sales
Question: Sate the order number and calculate the net profit for each order under Joshua Bennett.
Evidence: net profit can be computed as SUBTRACT(Unit Price, Unit Cost); Joshua Bennett is the name of Sales Team;
SQL: SELECT T1.OrderNumber , REPLACE(T1.`Unit Price`, ',', '') - REPLACE(T1.`Unit Cost`, ',', '')  FROM `Sales Orders` AS T1 INNER JOIN `Sales Team` AS T2 ON T2.SalesTeamID = T1._SalesTeamID WHERE T2.`Sales Team` = 'Joshua Bennett'

Database: address
Question: What is the area code of the city with the female median age over 32 years old?
SQL: SELECT T1.area_code FROM area_code AS T1 INNER JOIN ZIP_Data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.female_median_age > 32 GROUP BY T1.area_code

Database: simpson_episodes
Question: Calculate the percentage of the nominees who were born in USA.
Evidence: nominees refers to result = 'Nominee'; born in USA refers to birth_country = 'USA'; percentage = divide(sum(result = 'Nominee' and birth_country = 'USA'), count(Person.name)) * 100%
SQL: SELECT CAST(SUM(CASE WHEN T1.birth_country = 'USA' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM Person AS T1 INNER JOIN Award AS T2 ON T1.name = T2.person WHERE T2.result = 'Nominee';

Database: retails
Question: Calculate the total profit made by chocolate floral blue coral cyan.
Evidence: SUBTRACT(MULTIPLY(l_extendedprice, (SUBTRACT(1, l_discount)), MULTIPLY(ps_supplycost, l_quantity))) where p_name = 'chocolate floral blue coral cyan';
SQL: SELECT SUM(T3.l_extendedprice * (1 - T3.l_discount) - T2.ps_supplycost * T3.l_quantity) FROM part AS T1 INNER JOIN partsupp AS T2 ON T1.p_partkey = T2.ps_partkey INNER JOIN lineitem AS T3 ON T2.ps_partkey = T3.l_partkey AND T2.ps_suppkey = T3.l_suppkey WHERE T1.p_name = 'chocolate floral blue coral cyan'

Database: synthea
Question: Among the patients with hypertension, what is the average of their diastolic blood pressure?
Evidence: hypertension refers to conditions where DESCRIPTION = 'Hypertension'; average diastolic blood pressure refers to AVG(VALUE) where DESCRIPTION = 'Diastolic Blood Pressure' from observations;
SQL: SELECT AVG(T1.VALUE) FROM observations AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient INNER JOIN conditions AS T3 ON T2.patient = T3.PATIENT WHERE T3.DESCRIPTION = 'Hypertension' AND T1.DESCRIPTION = 'Diastolic Blood Pressure'

Database: law_episode
Question: How many episodes have not won any Law & Order series awards?
Evidence: have not won any award refers to Result = 'Nominee'
SQL: SELECT COUNT(award_id) FROM Award WHERE Result = 'Nominee'