Database: regional_sales
Question: Please indicate total order quantity of product Candles and calculate the percentage of such product among all the orders.
Evidence: total order quantity refers to Sum (Order Quantity); 'Candles' is the Products Name; percentage = Divide (Sum(Order Quantity where Product Name = 'Candles'), Sum(Order Quantity)) * 100
SQL: SELECT SUM(CASE WHEN T1.`Product Name` = 'Candles' THEN T2.`Order Quantity` ELSE 0 END), CAST(SUM(CASE WHEN T1.`Product Name` = 'Candles' THEN T2.`Order Quantity` ELSE 0 END) AS REAL) * 100 / SUM(T2.`Order Quantity`) FROM Products AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._ProductID = T1.ProductID INNER JOIN `Store Locations` AS T3 ON T3.StoreID = T2._StoreID

Database: bike_share_1
Question: How long did it take for bike id 426 to reach 2nd at South Park from Market at 4th on 8/29/2013? Indicate the duration in minutes.
Evidence: duration in minutes refers to DIVIDE(duration, 60 seconds); 2nd at South Park refers to end_station_name; Market at 4th refers to start_station_name; start_date = '8/29/2013'; end_date = '8/29/2013';
SQL: SELECT CAST(duration AS REAL) / 60  FROM trip WHERE bike_id = 426 AND end_station_name = '2nd at South Park' AND start_station_name = 'Market at 4th' AND start_date LIKE '8/29/2013%' AND end_date LIKE '8/29/2013%'

Database: video_games
Question: What platform is the game 3Xtreme available on?
Evidence: what platform refers to platform_name; 3Xtreme refers to game_name = '3Xtreme';
SQL: SELECT T2.platform_name FROM game_platform AS T1 INNER JOIN platform AS T2 ON T1.platform_id = T2.id INNER JOIN game_publisher AS T3 ON T1.game_publisher_id = T3.id INNER JOIN game AS T4 ON T3.game_id = T4.id WHERE T4.game_name = '3Xtreme'

Database: authors
Question: Calculate the total average number of papers published from 2002 to 2010 under the conference "Information and Knowledge Engineering".
Evidence: average number of papers refers to DIVIDE(count(id), 9); published from 2002 to 2010 refers to Year BETWEEN 2002 AND 2010; 'Information and Knowledge Engineering' is the FullName of conference;
SQL: SELECT CAST(COUNT(T1.Id) AS REAL) / COUNT(DISTINCT T1.Year) FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T2.FullName = 'Information and Knowledge Engineering' AND T1.Year >= 2002 AND T1.Year <= 2010

Database: legislator
Question: What is the ratio of males and females among historical legislators?
Evidence: male refers to gender_bio = 'M'; female refers to gender_bio = 'F'; calculation = DIVIDE(COUNT(gender_bio = 'M' THEN bioguide_id), COUNT(gender_bio = 'F' THEN bioguide_id))
SQL: SELECT CAST(SUM(CASE WHEN gender_bio = 'M' THEN 1 ELSE 0 END) AS REAL) / SUM(CASE WHEN gender_bio = 'F' THEN 1 ELSE 0 END) FROM historical

Database: student_loan
Question: How many students are enlisted in the Army organization?
Evidence: enlisted in the army refers to organ = 'army';
SQL: SELECT COUNT(name) FROM enlist WHERE organ = 'army'

Database: professional_basketball
Question: For the player who was drafted in the 1st round, 6th position in 1976, which team did he play in that year?
Evidence: drafted in the 1st round refers to draftRound = 1; 6th position refers to draftSelection = 6; in 1976 refers to year = 1976; team refers to tmID
SQL: SELECT T2.tmID FROM draft AS T1 INNER JOIN teams AS T2 ON T1.tmID = T2.tmID AND T1.draftYear = T2.year WHERE T1.draftRound = 1 AND T1.draftSelection = 6 AND T1.draftYear = 1976

Database: ice_hockey_draft
Question: What is the highest point highest point of Per Mars in the draft year?
Evidence: highest point in the draft year refers to MAX(P);
SQL: SELECT T1.P FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.PlayerName = 'Per Mars' ORDER BY T1.P DESC LIMIT 1

Database: menu
Question: For how many times had the dish "Chicken gumbo" appeared on a menu page?
Evidence: Chicken gumbo is a name of dish;
SQL: SELECT SUM(CASE WHEN T1.name = 'Chicken gumbo' THEN 1 ELSE 0 END) FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id

Database: genes
Question: For the non-essential genes whose functions are transcription, how many of them are not located in the cytoplasm?
SQL: SELECT COUNT(T1.GeneID) FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 WHERE T1.Localization != 'cytoplasm' AND T1.Function = 'TRANSCRIPTION' AND T1.Essential = 'NON-Essential'

Database: world_development_indicators
Question: What are the footnote description of Finland in year 2000?
Evidence: Finland is the short name of the country; year 2000 refers to Year = 'YR2000';
SQL: SELECT DISTINCT T2.Description FROM Country AS T1 INNER JOIN FootNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T1.TableName = 'Finland' AND T2.Year = 'YR2000'

Database: movie_3
Question: Among the films starred by Reese West, what is the difference between the films that have store ID of 1 and store ID of 2?
Evidence: result = subtract(count(film_id where store_id = 1), count(film_id where store_id = 2))
SQL: SELECT SUM(IIF(T4.film_id = 1, 1, 0)) - SUM(IIF(T4.film_id = 2, 1, 0)) AS diff FROM film_actor AS T1 INNER JOIN actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T1.film_id = T3.film_id INNER JOIN inventory AS T4 ON T3.film_id = T4.film_id WHERE T2.first_name = 'Reese' AND T2.last_name = 'West'

Database: chicago_crime
Question: List the IUCR numbers and index status of homicide incidents.
Evidence: index status refers to index_code; homicide incident refers to primary_description = 'HOMICIDE'
SQL: SELECT index_code FROM IUCR WHERE primary_description = 'HOMICIDE'

Database: airline
Question: Give the air carrier description of the flights that have an earlier arrival and departure.
Evidence: earlier arrival and departure refers to ARR_DELAY < 0 AND DEP_DELAY < 0;
SQL: SELECT T1.Description FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID WHERE T2.ARR_DELAY < 0 AND T2.DEP_DELAY < 0 GROUP BY T1.Description

Database: software_company
Question: What is the marital status of the customer ages 62 with an level of education of 7?
Evidence: customer ages 62 with an level of education of 7 refer age = 62 where EDUCATIONNUM = 7;
SQL: SELECT DISTINCT MARITAL_STATUS FROM Customers WHERE EDUCATIONNUM = 7 AND age = 62

Database: bike_share_1
Question: List the name of stations that were installed from 8/5/2013 to 12/31/2013. Indicate their installation date and city name.
Evidence: from 8/5/2013 to 12/31/2013 refers to installation_date between '8/5/2013' and '12/31/2013';
SQL: SELECT name, installation_date, city FROM station WHERE (SUBSTR(CAST(installation_date AS TEXT), 1, INSTR(installation_date, '/') - 1) = '5' AND SUBSTR(CAST(installation_date AS TEXT), INSTR(installation_date, '/') + 1, -6) >= '8' AND SUBSTR(CAST(installation_date AS TEXT), -4) = '2013') OR (SUBSTR(CAST(installation_date AS TEXT), 1, INSTR(installation_date, '/') - 1) IN ( '6', '7', '8', '9', '10', '11', '12' ) AND SUBSTR(CAST(installation_date AS TEXT), -4) = '2013')

Database: chicago_crime
Question: What are the communities that are grouped together on the central side?
Evidence: central side refers to side = 'Central'; community refers to community_area_name
SQL: SELECT community_area_name FROM Community_Area WHERE side = 'Central'

Database: retail_complains
Question: What is the medium through which most complaints are registered in Florida?
Evidence: medium refers to "Submitted via"; most complaints refers to MAX(Complaint ID); Florida refers to state = 'florida';
SQL: SELECT T3.`Submitted via` FROM callcenterlogs AS T1 INNER JOIN client AS T2 ON T1.`rand client` = T2.client_id INNER JOIN events AS T3 ON T1.`Complaint ID` = T3.`Complaint ID` WHERE T2.state = 'FL' GROUP BY T1.`Complaint ID` ORDER BY COUNT(T1.`Complaint ID`) DESC LIMIT 1