Database: authors
Question: What is the short name for "Software - Concepts and Tools / Structured Programming"?
Evidence: 'Software - Concepts and Tools / Structured Programming' is the FullName;
SQL: SELECT ShortName FROM Journal WHERE FullName = 'Software - Concepts and Tools / Structured Programming'

Database: retails
Question: Give the percentage of Japanese suppliers whose account is in debt.
Evidence: account is in debt if s_acctbal < 0; DIVIDE(COUNT(s_acctbal < 0 where n_name = 'JAPAN'), COUNT(s_name where n_name = 'JAPAN')) as percentage;
SQL: SELECT CAST(SUM(IIF(T2.n_name = 'JAPAN', 1, 0)) AS REAL) * 100 / COUNT(T1.s_name) FROM supplier AS T1 INNER JOIN nation AS T2 ON T1.s_nationkey = T2.n_nationkey WHERE T1.s_acctbal < 0

Database: movie_3
Question: How many actors played a role in the 2006 film whose rental duration is 7 days, rental rate is 4.99 and is 98 minutes duration?
Evidence: in 2006 refers to release_year = 2006; 98 min duration refers to length = 98; number of actors refers to count(actor_id)
SQL: SELECT COUNT(T1.actor_id) FROM film_actor AS T1 INNER JOIN film AS T2 ON T1.film_id = T2.film_id WHERE T2.release_year = 2006 AND T2.rental_duration = 7 AND T2.rental_duration = 4.99 AND T2.length = 98

Database: simpson_episodes
Question: Give the title of the episode won in Primetime Emmy Awards 2009.
Evidence: won refers to result = 'Winner'; in Primetime Emmy Awards refers to organization = 'Primetime Emmy Awards'; 2009 refers to year = 2009
SQL: SELECT T2.title FROM Award AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE T1.organization = 'Primetime Emmy Awards' AND T1.year = 2009 AND T1.result = 'Winner';

Database: music_platform_2
Question: What is the average rating for the podcast that is most reviewed?
Evidence: most reviewed refers to Max(Count(reviews.podcast_id)); average rating refers to AVG (rating)
SQL: SELECT AVG(T2.rating) FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id GROUP BY T1.podcast_id ORDER BY COUNT(T2.content) DESC LIMIT 1

Database: food_inspection
Question: Among the owners from Cameron Park, what is the business name of the business with a score of 100?
Evidence: Cameron Park is a name of city;
SQL: SELECT DISTINCT T2.name FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T2.owner_city = 'Cameron Park' AND T1.score = 100

Database: retails
Question: What are the top 5 nations of suppliers with the lowest account balance?
Evidence: nation refers to n_name; the lowest account balance refers to min(s_acctbal)
SQL: SELECT T2.n_name FROM supplier AS T1 INNER JOIN nation AS T2 ON T1.s_nationkey = T2.n_nationkey ORDER BY T1.s_acctbal LIMIT 1

Database: soccer_2016
Question: How many times did K Goel played as a player only?
Evidence: K Goel refers to Player_Name = 'K Goel'; played as a player only refers to Role_Id = 3
SQL: SELECT COUNT(T1.Match_Id) FROM Player_Match AS T1 INNER JOIN Player AS T2 ON T1.Player_Id = T2.Player_Id INNER JOIN Rolee AS T3 ON T1.Role_Id = T3.Role_Id WHERE T2.Player_Name = 'K Goel' AND T3.Role_Id = 3

Database: address
Question: Among the daylight savings areas in the Midwest region, how many postal points are there in Illinois?
Evidence: postal points refer to zip_code; the daylight savings areas refer to daylight_savings = 'Yes'; Illinois is the name of the state, in which name = 'Illinois';
SQL: SELECT COUNT(T2.zip_code) FROM state AS T1 INNER JOIN zip_data AS T2 ON T1.abbreviation = T2.state WHERE T1.name = 'Illinois' AND T2.daylight_savings = 'Yes' AND T2.region = 'Midwest'

Database: world
Question: List down the name of countries whereby English is their official language.
Evidence: English is the official language refers to Language = 'English' AND IsOfficial = 'T';
SQL: SELECT T1.Name FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = 'English' AND T2.IsOfficial = 'T'

Database: menu
Question: List the names and menu page IDs of the dishes that first appeared in 1861.
Evidence: first appeared in 1861 refers to first_appeared = 1861;
SQL: SELECT T2.name, T1.dish_id FROM MenuItem AS T1 INNER JOIN Dish AS T2 ON T2.id = T1.dish_id WHERE T2.first_appeared = 1861

Database: food_inspection
Question: How many of the businesses are located at 1825 POST St #223, San Francisco?
Evidence: 1825 POST St #223 refers to address = '1825 POST St #223', San Francisco is the name of the city;
SQL: SELECT COUNT(business_id) FROM businesses WHERE address = '1825 POST St #223' AND city = 'SAN FRANCISCO'

Database: genes
Question: Which negatively correlated, genetically interacting genes are non-essential? What percentage do they represent with respect to those that are essential?
Evidence: If the Expression_Corr value is negative then it's negatively correlated; Percentage of Essensity = [count(negatively correlated, genetical interaction, non-essential) / count(negatively correlated, genetical interaction, non-essential+negatively correlated, genetical interaction, essential)] * 100%
SQL: SELECT CAST(COUNT(T1.GeneID) AS REAL) * 100 / ( SELECT COUNT(T1.GeneID) FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 WHERE T2.Expression_Corr < 0 ) FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 WHERE T2.Expression_Corr < 0 AND T1.Essential = 'Non-Essential'

Database: sales_in_weather
Question: On February 8, 2014, what is the minimum temperature in the station where store 29 belongs?
Evidence: On February 8, 2014 refers to date = '2014-02-08'; store 29 refers to store_nbr = 29; minimum temperature refers to tmin; station refers to station_nbr
SQL: SELECT tmin FROM relation AS T1 INNER JOIN weather AS T2 ON T1.station_nbr = T2.station_nbr WHERE T1.store_nbr = 29 AND T2.`date` = '2014-02-08'

Database: student_loan
Question: How many male students are enrolled at OCC?
Evidence: male students are mentioned in male.name; OCC refers to school = 'occ';
SQL: SELECT COUNT(T1.name) FROM enrolled AS T1 INNER JOIN male AS T2 ON T1.name = T2.name WHERE T1.school = 'occ'

Database: legislator
Question: List the last name of all current legislators who live in California.
Evidence: California refers to state = 'CA'
SQL: SELECT T1.last_name FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.state = 'CA' GROUP BY T1.last_name

Database: retail_world
Question: What are the prices on cheese products?
Evidence: prices on cheese refer to UnitPrice WHERE Description = 'Cheeses';
SQL: SELECT T2.UnitPrice FROM Categories AS T1 INNER JOIN Products AS T2 ON T1.CategoryID = T2.CategoryID WHERE T1.Description = 'Cheeses'

Database: legislator
Question: Among the male legislators born between 1955 to 1965, what is the percentage of the legislators with an independent party?
Evidence: male refers to gender_bio = 'M'; born between 1955 to 1965 refers to strftime('%Y', birthday_bio) between '1955' and '1965'; percentage = MULTIPLY(DIVIDE(SUM(party = 'Independent' WHERE gender_bio = 'M' AND strftime('%Y', birthday_bio) between '1955' and '1965'), COUNT(party WHERE gender_bio = 'M' AND strftime('%Y', birthday_bio) between '1955' and '1965')), 100.0);
SQL: SELECT CAST(SUM(CASE WHEN T2.party = 'Independent' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T2.party) FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.gender_bio = 'M' AND strftime('%Y', T1.birthday_bio) BETWEEN '1955' AND '1965'

Database: genes
Question: Of all the nonessential genes that are not of the motorprotein class and whose phenotype is cell cycle defects, how many do not have a physical type of interaction?
SQL: SELECT COUNT(T1.GeneID) FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 WHERE T2.Type != 'Physical' AND T1.Phenotype = 'Cell cycle defects' AND T1.Class != 'Motorproteins' AND T1.Essential = 'Non-Essential'