Database: language_corpus
Question: For the biwords pair that appears "116430" times, what is the second word of the pair?
Evidence: the biwords pair that appears "116430" times refers to occurrences = 116430; second word of the pair refers to w2nd
SQL: SELECT T1.word FROM words AS T1 INNER JOIN biwords AS T2 ON T1.wid = T2.w2nd WHERE T2.occurrences = 116430

Database: synthea
Question: Among the immunizations in 2017, calculate the percentage of patients who received the Influenza seasonal injectable preservative free. Among them, how many patients are English?
Evidence: DIVIDE(COUNT(PATIENT when DESCRIPTION = 'Influenza seasonal injectable preservative free'), COUNT(PATIENT)) as percentage where strftime('%Y', 2017); English refers ethnicity = 'english';
SQL: SELECT CAST(SUM(CASE WHEN T2.DESCRIPTION = 'Influenza seasonal injectable preservative free' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.patient), SUM(CASE WHEN T1.ethnicity = 'english' THEN 1 ELSE 0 END) FROM patients AS T1 INNER JOIN immunizations AS T2 ON T1.patient = T2.PATIENT WHERE strftime('%Y', T2.DATE) = '2017'

Database: retail_world
Question: Provide the territory IDs under employee ID of 7.
SQL: SELECT TerritoryID FROM EmployeeTerritories WHERE EmployeeID = 7

Database: retails
Question: Please list all the modes of shipping for the part "burnished seashell gainsboro navajo chocolate".
Evidence: mode of shipping refers to l_shipmode; part "burnished seashell gainsboro navajo chocolate" refers to p_name = 'burnished seashell gainsboro navajo chocolate'
SQL: SELECT DISTINCT T1.l_shipmode FROM lineitem AS T1 INNER JOIN part AS T2 ON T1.l_partkey = T2.p_partkey WHERE T2.p_name = 'burnished seashell gainsboro navajo chocolate'

Database: donor
Question: Which state have the highest number of PayPal donations for an honoree whose portion of a donation included corporate sponsored giftcard?
Evidence: which state refers to donor_state; highest number refers to max(count(donor_state)); PayPal donations refers to payment_method = 'paypal'; for an honoree refers to for_honoree = 't'; included corporate sponsored giftcard refers to payment_included_campaign_gift_card = 't'
SQL: SELECT DISTINCT donor_state FROM donations WHERE for_honoree = 't' AND payment_included_campaign_gift_card = 't' AND payment_method = 'paypal' AND donor_state = ( SELECT donor_state FROM donations GROUP BY donor_state ORDER BY SUM(donation_total) DESC LIMIT 1 )

Database: codebase_comments
Question: What is the github address of the "nofear_Mara\Mara.sln" solution path?
Evidence: github address of repository refers to Url;
SQL: SELECT Url FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE Path = 'nofear_MaraMara.sln'

Database: movie_3
Question: How many films did actor Daryl Wahlberg appear in?
SQL: SELECT COUNT(T1.film_id) FROM film_actor AS T1 INNER JOIN actor AS T2 ON T1.actor_id = T2.actor_id WHERE T2.first_name = 'DARYL' AND T2.last_name = 'WAHLBERG'

Database: cs_semester
Question: Among the most popular professors, how many are females?
Evidence: the most popular professors refers to prof_id where MAX(popularity); female refers to gender;
SQL: SELECT COUNT(prof_id) FROM prof WHERE gender = 'Female' AND popularity = ( SELECT MAX(popularity) FROM prof )

Database: app_store
Question: Which apps have not been updated since year 2015 and what kind of sentiment users hold on it?
Evidence: since year 2015 refers to "Last Updated"<'January 1, 2015';
SQL: SELECT DISTINCT App, Sentiment FROM user_reviews WHERE App IN ( SELECT App FROM playstore WHERE CAST(SUBSTR('Last Updated', -4, 4) AS INTEGER) < 2015 )

Database: shakespeare
Question: What is the description of chapter 18706 in "All's Well That Ends Well"?
Evidence: chapter 18706 refers to chapters.id; "All's Well That Ends Well" refers to Title = 'All's Well That Ends Well'
SQL: SELECT T2.Description FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T2.id = 18706 AND T1.Title = 'All''s Well That Ends Well'

Database: restaurant
Question: What does the one and only 24-hour diner's name?
Evidence: 24-hour diner refers to food_type = '24 hour diner'; diner name refers to label
SQL: SELECT label FROM generalinfo WHERE food_type = '24 hour diner'

Database: restaurant
Question: Which region has the highest number of restaurants?
Evidence: the highest number refers to max(count(id_restaurant))
SQL: SELECT T1.region FROM geographic AS T1 INNER JOIN location AS T2 ON T1.city = T2.city GROUP BY T1.region ORDER BY COUNT(T2.id_restaurant) DESC LIMIT 1

Database: food_inspection
Question: Among the businesses with score that ranges from 70 to 80, list their violation type ID and risk category.
Evidence: businesses with score that ranges from 70 to 80 refer to business_id where score between 80 and 90;
SQL: SELECT DISTINCT T1.violation_type_id, T1.risk_category FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id INNER JOIN inspections AS T3 ON T2.business_id = T3.business_id WHERE T3.score BETWEEN 70 AND 80

Database: sales
Question: What is the name of the sales person who handled the highest number of sales?
Evidence: name of the sales person = FirstName, MiddleInitial, LastName; highest number of sales refers to MAX(COUNT(SalesID));
SQL: SELECT T1.FirstName, T1.MiddleInitial, T1.LastName FROM Employees AS T1 INNER JOIN Sales AS T2 ON T2.SalesPersonID = T1.EmployeeID GROUP BY T2.SalesPersonID, T1.FirstName, T1.MiddleInitial, T1.LastName ORDER BY COUNT(T2.SalesID) DESC LIMIT 1

Database: olympics
Question: How many people who are below 30 and participated in the summer season?
Evidence: people who are below 30 refer to person_id where age < 30; the summer season refers to season = 'Summer';
SQL: SELECT COUNT(T2.person_id) FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id WHERE T1.season = 'Summer' AND T2.age < 30

Database: codebase_comments
Question: Which solution contains files within a more popular repository, the solution ID18 or solution ID19?
Evidence: more watchers mean that this repository is more popular;
SQL: SELECT CASE WHEN SUM(CASE WHEN T2.Id = 18 THEN T1.Watchers ELSE 0 END) > SUM(CASE WHEN T2.Id = 19 THEN T1.Watchers ELSE 0 END) THEN 'SolutionID18' WHEN SUM(CASE WHEN T2.Id = 18 THEN T1.Watchers ELSE 0 END) < SUM(CASE WHEN T2.Id = 19 THEN T1.Watchers ELSE 0 END) THEN 'SolutionID19' END isMorePopular FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId

Database: video_games
Question: Which game has the longest name?
Evidence: game refers to game_name; the longest name refers to max(length(game_name))
SQL: SELECT T.game_name FROM game AS T ORDER BY LENGTH(T.game_name) DESC LIMIT 1

Database: sales
Question: Calculate the total sales ids that were sales of Flat Washer 8.
Evidence: Flat Washer 8' is name of product;
SQL: SELECT COUNT(T1.SalesID) FROM Sales AS T1 INNER JOIN Products AS T2 ON T1.ProductID = T2.ProductID WHERE T2.Name = 'Flat Washer 8'

Database: retails
Question: How many orders in total have the customers in the household segment made?
Evidence: orders in household segment refer to o_orderkey where c_mktsegment = 'HOUSEHOLD';
SQL: SELECT COUNT(T1.o_orderkey) FROM orders AS T1 INNER JOIN customer AS T2 ON T1.o_custkey = T2.c_custkey WHERE T2.c_mktsegment = 'HOUSEHOLD'

Database: retails
Question: What is the comment of the product "burlywood plum powder puff mint"?
Evidence: comment refers to p_comment; product "burlywood plum powder puff mint" refers to p_name = 'burlywood plum powder puff mint'
SQL: SELECT p_comment FROM part WHERE p_name = 'burlywood plum powder puff mint'