Database: synthea
Question: Why did Mrs. Annabelle Pouros take leucovorin 100 mg injection on 1970/12/19? State the reason.
Evidence: reason why take leucovorin 100 mg injection refers to REASONDESCRIPTION where DESCRIPTION = 'Leucovorin 100 MG Injection'; on 1970/12/19 refers to START = '1970-12-19';
SQL: SELECT T2.reasondescription FROM patients AS T1 INNER JOIN medications AS T2 ON T1.patient = T2.PATIENT WHERE T1.prefix = 'Mrs.' AND T1.first = 'Annabelle' AND T1.last = 'Pouros' AND T2.start = '1970-12-19' AND T2.description = 'Leucovorin 100 MG Injection'

Database: restaurant
Question: What is the name of the restaurant that is located in El Dorado County, Lake Tahoe region?
Evidence: restaurant name refers to label
SQL: SELECT T2.label FROM geographic AS T1 INNER JOIN generalinfo AS T2 ON T1.city = T2.city WHERE T1.region = 'lake tahoe' AND T1.county = 'el dorado county'

Database: computer_student
Question: Which professor taught the most courses and what is the position of this person in the university?
Evidence: professor refers to taughtBy.p_id; most courses refers to max(taughtBy.p_id); position refers to hasPosition
SQL: SELECT T1.p_id, T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.p_id ORDER BY COUNT(T2.course_id) DESC LIMIT 1

Database: app_store
Question: What is the total installs of apps with content rating of adults only 18+ and what are the translated reviews of it?
Evidence: total installs = SUM(Installs);
SQL: SELECT SUM(T1.Installs), T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1."Content Rating" = 'Adults only 18+'

Database: soccer_2016
Question: List the first team's name in the match with the highest winning margin.
Evidence: team's name refers to Team_Name; first team refers to Team_Id = Team_1; the highest winning margin refers to max(Win_Margin)
SQL: SELECT T2.Team_Name FROM Match AS T1 INNER JOIN Team AS T2 ON T2.Team_Id = T1.Team_1 ORDER BY T1.Win_Margin DESC LIMIT 1

Database: ice_hockey_draft
Question: Which country do most players of team Plymouth Whalers come from?
Evidence: country and nation are synonyms; country where most players come from refers to MAX(COUNT(nation WHERE TEAM = 'Plymouth Whalers')); players refers to PlayerName; team Plymouth Whalers refers to TEAM = 'Plymouth Whalers';
SQL: SELECT T.nation FROM ( SELECT T1.nation, COUNT(T1.ELITEID) FROM PlayerInfo AS T1 INNER JOIN SeasonStatus AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.TEAM = 'Plymouth Whalers' GROUP BY T1.nation ORDER BY COUNT(T1.ELITEID) DESC LIMIT 1 ) AS T

Database: shipping
Question: How many shipments does each driver deliver per month on average?
Evidence: shipment data was for 24 months in 2016 and 2017 respectively; deliver per month on average refers to Divide(Count(ship_id), Multiply (24, Count(driver_id)))
SQL: SELECT CAST(COUNT(*) AS REAL) / (12 * COUNT(T2.driver_id)) FROM shipment AS T1 INNER JOIN driver AS T2 ON T1.driver_id = T2.driver_id

Database: retail_world
Question: What are the names of the products that were ordered that have a unit price of no more than 5?
Evidence: unit price of no more than 5 refers to UnitPrice < 5; name of products refers to ProductName
SQL: SELECT DISTINCT T1.ProductName FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T2.UnitPrice < 5

Database: video_games
Question: List down the names of platform where the games released in 2016 can be played on.
Evidence: name of platform refers to platform_name; released in 2016 refers to release_year = 2016
SQL: SELECT DISTINCT T1.platform_name FROM platform AS T1 INNER JOIN game_platform AS T2 ON T1.id = T2.platform_id WHERE T2.release_year = 2016

Database: restaurant
Question: How many restaurants can we find at number 871 on its street?
Evidence: number 871 on its street refers to street_num = 871
SQL: SELECT COUNT(id_restaurant) FROM location WHERE street_num = 871

Database: world
Question: List down the cities that belong to the country with a life expectancy of 66.4.
SQL: SELECT T2.Name FROM Country AS T1 INNER JOIN City AS T2 ON T1.Code = T2.CountryCode WHERE T1.LifeExpectancy = 66.4

Database: soccer_2016
Question: How many players are from Australia?
Evidence: Australia refers to Country_Name = 'Australia'
SQL: SELECT COUNT(CASE WHEN T2.Country_Name = 'Australia' THEN T1.Player_Id ELSE NULL END) FROM Player AS T1 INNER JOIN Country AS T2 ON T1.Country_Name = T2.Country_Id

Database: world_development_indicators
Question: What proportion of Sub-Saharan Africa's countries have lower middle incomes?
Evidence: proportion = divide(count(countrycode where incomegroup = 'Low income'), count(countrycode))*100%; Sub-Saharan Africa's countries refers to region = 'Sub-Saharan Africa'; have lower middle incomes refers to incomegroup = 'Low income'
SQL: SELECT SUM(CASE WHEN IncomeGroup = 'Lower middle income' THEN 1 ELSE 0 END) * 100.0 / COUNT(CountryCode) persentage FROM Country WHERE Region = 'Sub-Saharan Africa'

Database: disney
Question: How much is the total gross of the movie with a song titled "Little Wonders"?
Evidence: song = 'Little Wonders'
SQL: SELECT T1.total_gross FROM movies_total_gross AS T1 INNER JOIN characters AS T2 ON T2.movie_title = T1.movie_title WHERE T2.song = 'Little Wonders'

Database: authors
Question: Give the Title and author's name of the books that were preprint in 1997.
Evidence: in 1997 refers to Year = 1997; books that were preprint refers to ConferenceId = 0 AND JournalId = 0
SQL: SELECT DISTINCT T2.Name, T1.Title FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T1.ConferenceId = 0 AND T1.JournalId = 0 AND T1.Year = 1997 AND T1.Title <> ''

Database: movie_platform
Question: Please list the names of the movies that user 94978 scored as 5.
Evidence: user 94978 refers to user_id = 94978; scored as 5 refers to rating_score = 5;
SQL: SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5 AND T1.user_id = 94978

Database: food_inspection_2
Question: Provide the fine paid and the complete address of the establishment with inspection ID 48216.
Evidence: complete address refers to state, city, address
SQL: SELECT DISTINCT T3.fine, T1.state, T1.city, T1.address FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no INNER JOIN violation AS T3 ON T2.inspection_id = T3.inspection_id WHERE T2.inspection_id = 48216

Database: public_review_platform
Question: What are the opening and closing time of business id 1 for day id 2?
Evidence: false
SQL: SELECT opening_time, closing_time FROM Business_Hours WHERE business_id = 1 AND day_id = 2

Database: legislator
Question: How many years had Jr. John Conyers served in total?
Evidence: Jr. John Conyers is an official_full_name; years served refers to SUM(SUBTRACT(END, start))
SQL: SELECT SUM(CAST(T2.END - T2.start AS DATE)) AS sum FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.official_full_name = 'John Conyers, Jr.'

Database: image_and_language
Question: How many pairs of object samples in image no.1 have the relation of "parked on"?
Evidence: pairs of object samples refers to OBJ1_SAMPLE_ID and OBJ2_SAMPLE_ID; image no.1 refers to IMG_ID = 1; relation of "parked on" refers to PRED_CLASS = 'parked on'
SQL: SELECT SUM(CASE WHEN T1.PRED_CLASS = 'parked on' THEN 1 ELSE 0 END) FROM PRED_CLASSES AS T1 INNER JOIN IMG_REL AS T2 ON T1.PRED_CLASS_ID = T2.PRED_CLASS_ID WHERE T2.IMG_ID = 1 AND T2.OBJ1_SAMPLE_ID != OBJ2_SAMPLE_ID

Database: movielens
Question: Please give the ids of the oldest films that got the most ratings.
Evidence: Films and movies share the same meaning; oldest film refers to the movie with year = 1
SQL: SELECT DISTINCT T1.movieid FROM u2base AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid WHERE T1.rating = 5 AND T2.year = 1