Database: synthea
Question: State the prevalence rate of condition no. 368581000119106.
Evidence: condition no. 368581000119106 refers to conditions where CODE = '368581000119106';
SQL: SELECT DISTINCT T1."PREVALENCE RATE" FROM all_prevalences AS T1 INNER JOIN conditions AS T2 ON lower(T1.ITEM) = lower(T2.DESCRIPTION) WHERE T2.code = '368581000119106'

Database: chicago_crime
Question: List down the report number of crimes associated with the district commander named Jill M. Stevens.
Evidence: report number refers report_no; 'Jill M. Stevens" is the commander
SQL: SELECT SUM(CASE WHEN T1.commander = 'Jill M. Stevens' THEN 1 ELSE 0 END) FROM District AS T1 INNER JOIN Crime AS T2 ON T1.district_no = T2.district_no

Database: video_games
Question: On which platform was Panzer Tactics released in 2007?
Evidence: platform refers to platform_name; Panzer Tactics refers to game_name = 'Panzer Tactics'; released in 2007 refers to release_year = 2007
SQL: SELECT T5.platform_name FROM game_publisher AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id INNER JOIN game AS T3 ON T1.game_id = T3.id INNER JOIN game_platform AS T4 ON T1.id = T4.game_publisher_id INNER JOIN platform AS T5 ON T4.platform_id = T5.id WHERE T3.game_name = 'Panzer Tactics' AND T4.release_year = 2007

Database: menu
Question: What is the highest price of the dish "Chicken gumbo" on a menu page?
Evidence: highest price refers to MAX(price); Chicken gumbo is a name of dish;
SQL: SELECT T2.price FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id WHERE T1.name = 'Chicken gumbo' ORDER BY T2.price DESC LIMIT 1

Database: retails
Question: Give customer No.106936's region name.
Evidence: "Customer#000000055" is the name of the customer which refers to c_name; region name refers to r_name;
SQL: SELECT T3.r_name FROM nation AS T1 INNER JOIN customer AS T2 ON T1.n_nationkey = T2.c_nationkey INNER JOIN region AS T3 ON T1.n_regionkey = T3.r_regionkey WHERE T2.c_custkey = 106936

Database: codebase_comments
Question: Please provide the path of solution of method whose full comment is Feeds data into the parser.
Evidence: path of solution refers to Path; method refers to name; full comment = 'Feeds data into the parser';
SQL: SELECT T1.Path FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.FullComment = 'Feeds data into the parser'

Database: soccer_2016
Question: Where was the ID 336005 match held? Please give me the venue and the city.
Evidence: ID 336005 match refers to Match_Id = '336005'; venue refers to Venue_Name; city refers to City_Name
SQL: SELECT T2.Venue_Name, T3.City_Name FROM `Match` AS T1 INNER JOIN Venue AS T2 ON T1.Venue_Id = T2.Venue_Id INNER JOIN City AS T3 ON T2.City_Id = T3.City_Id WHERE T1.Match_Id = '336005'

Database: superstore
Question: How many furniture products were ordered at central superstore?
Evidence: furniture products refers to Category = 'Furniture'
SQL: SELECT COUNT(*) FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.Category = 'Furniture'

Database: authors
Question: Describe the paper title, published year, conference's short name and included author names in the paper ID of 15.
Evidence: paper ID of 15 refers to PaperId = 15
SQL: SELECT DISTINCT T1.Title, T1.Year, T3.ShortName, T2.Name FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId INNER JOIN Conference AS T3 ON T1.ConferenceId = T3.Id WHERE T1.Id = 15

Database: airline
Question: For the flight with the tail number 'N702SK', which air carrier does it belong to?
Evidence: tail number refers to TAIL_NUM; TAIL_NUM = 'N702SK';
SQL: SELECT T2.Description FROM Airlines AS T1 INNER JOIN `Air Carriers` AS T2 ON T1.OP_CARRIER_AIRLINE_ID = T2.Code WHERE T1.TAIL_NUM = 'N702SK' GROUP BY T2.Description

Database: retail_world
Question: Write down the notes of employee with the highest salary.
Evidence: highest salary refers to Max(Salary)
SQL: SELECT Notes FROM Employees WHERE Salary = ( SELECT MAX(Salary) FROM Employees )

Database: university
Question: List down all universities that scored below 50.
Evidence: scored below 50 refers to score < 50; all universities refers to university_name;
SQL: SELECT DISTINCT T2.university_name FROM university_ranking_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T1.score < 50

Database: legislator
Question: Among the current legislators who have served for more than 6 terms, how many of them were born after 1960?
Evidence: served for more than 6 terms refers to COUNT(bioguide > 6); born after 1960 refers to birthday_bio > = '1960-01-01'
SQL: SELECT COUNT(CID) FROM ( SELECT T1.bioguide_id AS CID FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.birthday_bio >= '1960-01-01' GROUP BY T2.bioguide HAVING COUNT(T2.bioguide) > 6 )

Database: movies_4
Question: Find out the language ID of the movie with the highest popularity.
Evidence: highest popularity refers to max(popularity)
SQL: SELECT T2.language_id FROM movie AS T1 INNER JOIN movie_languages AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.popularity DESC LIMIT 1

Database: books
Question: How many books were ordered by customer Kandy Adamec?
SQL: SELECT COUNT(*) FROM order_line AS T1 INNER JOIN cust_order AS T2 ON T2.order_id = T1.order_id INNER JOIN customer AS T3 ON T3.customer_id = T2.customer_id WHERE T3.first_name = 'Kandy' AND T3.last_name = 'Adamec'

Database: music_tracker
Question: What is the release title of the single that was released by Ron Hunt in 1979 that was downloaded 239 times?
Evidence: release title refers to groupName; Ron Hunt is an artist; groupYear = 1979; releaseType = 'single'; downloaded 239 times refer to totalSnatched = 239;
SQL: SELECT groupName FROM torrents WHERE artist LIKE 'ron hunt & ronnie g & the sm crew' AND groupYear = 1979 AND releaseType LIKE 'single' AND totalSnatched = 239

Database: bike_share_1
Question: How many docks were available at the starting station of trip ID 912900?
SQL: SELECT SUM(T2.docks_available) FROM trip AS T1 INNER JOIN status AS T2 ON T2.station_id = T1.start_station_id WHERE T1.zip_code = 912900

Database: retail_world
Question: List the phone number of company named Around the Horn.
Evidence: phone number refers to Phone; 'Around the Horn' is a CompanyName
SQL: SELECT Phone FROM Customers WHERE CompanyName = 'Around the Horn'

Database: professional_basketball
Question: Which team(s) had 90% games won. List the coach ID for the team and year played.
Evidence: team with 90% games won refers to Divide (won, games) > 0.9
SQL: SELECT DISTINCT T2.name, T1.year, T1.coachID FROM coaches AS T1 INNER JOIN teams AS T2 ON T1.tmID = T2.tmID WHERE CAST(T2.won AS REAL) * 100 / T2.games > 90

Database: world_development_indicators
Question: How many low income countries are there in South Asia?
Evidence: South Asia is the name of the region; IncomeGroup = 'Low income';
SQL: SELECT COUNT(CountryCode) FROM Country WHERE Region = 'South Asia' AND IncomeGroup = 'Low income'

Database: disney
Question: In which segment did the Walt Disney Company earned a bigger revenue in 1998, Studio Entertainment or Disney Media Networks?
Evidence: Studio Entertainment[NI 1]' > 'Disney Media Networks' where Year = 1998;
SQL: SELECT CASE WHEN 'Studio Entertainment[NI 1]' > 'Disney Media Networks' THEN 'Studio Entertainment[NI 1]' ELSE 'Disney Media Networks' END FROM revenue WHERE `Year` = 1998

Database: retails
Question: What is the average price of the orders made by a customer in Germany?
Evidence: DIVIDE(SUM(o_totalprice), COUNT(o_orderkey)) where n_name = 'GERMANY';
SQL: SELECT AVG(T3.o_totalprice) FROM nation AS T1 INNER JOIN customer AS T2 ON T1.n_nationkey = T2.c_nationkey INNER JOIN orders AS T3 ON T2.c_custkey = T3.o_custkey WHERE T1.n_name = 'GERMANY'