Database: codebase_comments
Question: What is the language of the method used in the solution path "opendns_diagnosticapp\windows\OpenDnsDiagnostic.sln"?
Evidence: language refers to Lang;
SQL: SELECT T2.Lang FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T1.Path = 'opendns_diagnosticappwindowsOpenDnsDiagnostic.sln'

Database: soccer_2016
Question: Who is the youngest player to have won the Purple Cap?
Evidence: Who refers to Player_Name; youngest player to have won the Purple Cap refers to min(subtract(Season_Year, DOB))
SQL: SELECT T1.Player_Name FROM Player AS T1 INNER JOIN Season AS T2 ON T1.Player_Id = T2.Purple_Cap ORDER BY T2.Season_Year - SUBSTR(T1.DOB, 1, 4) LIMIT 1

Database: shipping
Question: Among all the shipments to Florida, what is the percentage of the shipment to Jacksonville?
Evidence: "Florida" is the state; "Jacksonville" is city_name;
SQL: SELECT CAST(SUM(CASE WHEN T2.city_name = 'Jacksonville' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM shipment AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id WHERE T2.state = 'Florida'

Database: address
Question: How many representatives are there in the state with the highest monthly benefit payments for retired workers?
Evidence: state with highest monthly benefits payment for retired workers refers to Max(monthly_benefits_retired_workers)
SQL: SELECT COUNT(T3.cognress_rep_id) FROM zip_data AS T1 INNER JOIN state AS T2 ON T1.state = T2.abbreviation INNER JOIN congress AS T3 ON T2.abbreviation = T3.abbreviation ORDER BY T1.monthly_benefits_retired_workers DESC LIMIT 1

Database: address
Question: What is the elevation of the city with the alias East Longmeadow?
SQL: SELECT T2.elevation FROM alias AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.alias = 'East Longmeadow'

Database: world_development_indicators
Question: What is the agricultural land area in sq. km of Italy in 1968?
Evidence: agricultural land area in sq. km refers value where indicatorname = 'Agricultural land (sq. km)'; Italy refers to countryname = 'Italy'; in 1968 refers to year = '1968'
SQL: SELECT Value FROM Indicators WHERE IndicatorName = 'Agricultural land (sq. km)' AND Year = 1968 AND CountryName = 'Italy'

Database: olympics
Question: How many competitors were there who participated in 2000 Summer with age 31?
Evidence: in 2000 Summer refers to games_name = '2000 Summer'; age = 31
SQL: SELECT COUNT(T2.person_id) FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id WHERE T1.games_name = '2000 Summer' AND T2.age = 31

Database: chicago_crime
Question: What is the population of the district with the least population?
Evidence: the least population refers = min(sum(population))
SQL: SELECT SUM(population) FROM Community_Area GROUP BY side ORDER BY SUM(population) LIMIT 1

Database: codebase_comments
Question: What is the total processed time of all solutions from the repository with the most forks?
Evidence: total processed time = AVG(ProcessedTime where MAX(COUNT(Forks))); repository with the most forks refers to MAX(COUNT(Forks));
SQL: SELECT SUM(T2.ProcessedTime) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Forks = ( SELECT MAX(Forks) FROM Repo )

Database: ice_hockey_draft
Question: Who is the oldest player that participated in OHL league in the 1997 - 2000 season?
Evidence: oldest player refers to MIN(birthdate); OHL league refers to LEAGUE = 'OHL'; 1997-2000 season refers to SEASON = '1997-2000';
SQL: SELECT T1.PlayerName FROM PlayerInfo AS T1 INNER JOIN SeasonStatus AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.LEAGUE = 'OHL' AND T2.SEASON = '1999-2000' ORDER BY T1.birthdate LIMIT 1

Database: retail_world
Question: Which territories is the employee with a doctorate in charge of? List all of the territory descriptions.
Evidence: with a doctorate refers to TitleOfCourtesy = 'Dr.'
SQL: SELECT T3.TerritoryDescription FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID INNER JOIN Territories AS T3 ON T2.TerritoryID = T3.TerritoryID WHERE T1.TitleOfCourtesy = 'Dr.'

Database: synthea
Question: Who is the 44-year-old patient diagnosed with drug overdose?
Evidence: 44-year-old = DIVIDE(SUBTRACT(julianday(conditions.START), julianday(patients.birthdate)), 365, 0) = 44;
SQL: SELECT T2.first, T2.last FROM conditions AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T1.DESCRIPTION = 'Drug overdose' AND ROUND((strftime('%J', T2.deathdate) - strftime('%J', T2.birthdate)) / 365) = 44

Database: simpson_episodes
Question: What is the keyword for episodes with stars score of 10 at 30% and above?
Evidence: stars score of 10 at 30% and above refers to stars = 10 and percent > 29
SQL: SELECT T1.keyword FROM Keyword AS T1 INNER JOIN Vote AS T2 ON T1.episode_id = T2.episode_id WHERE T2.stars = 10 AND T2.percent > 29;

Database: books
Question: How many addresses are from the Philippines?
Evidence: "Philippines" is the country_name
SQL: SELECT COUNT(T2.country_id) FROM address AS T1 INNER JOIN country AS T2 ON T2.country_id = T1.country_id WHERE T2.country_name = 'Philippines'

Database: soccer_2016
Question: Who got the Man of the Series Award in 2010?
Evidence: player's name refers to Player_Name; got the Man of the Series Award refers to Man_of_the_Match = Player_Id; in 2010 refers to Season_Year = 2010
SQL: SELECT T1.Player_Name FROM Player AS T1 INNER JOIN Match AS T2 ON T2.Man_of_the_Match = T1.Player_Id INNER JOIN Season AS T3 ON T3.Season_Id = T2.Season_Id WHERE T3.Season_Year = 2010 GROUP BY T1.Player_Name

Database: chicago_crime
Question: District commander Robert A. Rubio was responsible for how many incidents in January, 2018?
Evidence: in January 2018 refers to Substr(date, 1, 1) = '1' AND Substr(date, 5, 4) = '2018'
SQL: SELECT SUM(CASE WHEN SUBSTR(T2.date, 5, 4) = '2018' THEN 1 ELSE 0 END) FROM District AS T1 INNER JOIN Crime AS T2 ON T1.district_no = T2.district_no WHERE T1.commander = 'Robert A. Rubio' AND SUBSTR(T2.date, 1, 1) = '1'

Database: car_retails
Question: What is the total price of the order 10100?
Evidence: SUM(MULTIPLY(quantityOrdered, priceEach)
SQL: SELECT SUM(t.priceEach * t.quantityOrdered) FROM orderdetails t WHERE t.orderNumber = '10100'

Database: retail_world
Question: Please indicate the product name of Tokyo Traders company with order quantity greater than 40.
Evidence: 'Tokyo Traders' is a CompanyName; order quantity greater than 40 refers to Quantity > 40
SQL: SELECT DISTINCT T2.ProductName FROM Suppliers AS T1 INNER JOIN Products AS T2 ON T1.SupplierID = T2.SupplierID INNER JOIN `Order Details` AS T3 ON T2.ProductID = T3.ProductID WHERE T1.CompanyName = 'Tokyo Traders' AND T3.Quantity > 40

Database: shipping
Question: How many shipments were shipped to the least populated city in California?
Evidence: "California" is the state; least populated city refers to Min(population)
SQL: SELECT COUNT(T3.city_name) FROM customer AS T1 INNER JOIN shipment AS T2 ON T1.cust_id = T2.cust_id INNER JOIN city AS T3 ON T3.city_id = T2.city_id WHERE T3.state = 'California' ORDER BY T3.population ASC LIMIT 1

Database: airline
Question: Which airport did Republic Airline fly the most from?
Evidence: Republic Airline refers to Description = 'Republic Airline: YX'; fly the most from refers to MAX(COUNT(ORIGIN));
SQL: SELECT T2.DEST FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID WHERE T1.Description = 'Republic Airline: YX' GROUP BY T2.DEST ORDER BY COUNT(T2.DEST) DESC LIMIT 1

Database: food_inspection_2
Question: What is the facility type of the establishment named "Kinetic Playground"?
Evidence: the establishment named "Kinetic Playground" refers to dba_name = 'Kinetic Playground'
SQL: SELECT facility_type FROM establishment WHERE dba_name = 'Kinetic Playground'