Database: synthea
Question: When did Mrs. Joye Homenick receive her most recent influenza seasonal vaccine?
Evidence: when a patient received her most recent vaccine refers to MAX(immunications.DATE); influenza seasonal vaccine refers to immunizations.DESCRIPTION = 'Influenza seasonal injectable preservative free';
SQL: SELECT T2.DATE FROM patients AS T1 INNER JOIN immunizations AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Influenza  seasonal  injectable  preservative free' AND T1.first = 'Joye' AND T1.last = 'Homenick' ORDER BY T2.DATE DESC LIMIT 1

Database: sales_in_weather
Question: How many no.9 items from store no.11 were sold on 2012/12/7?
Evidence: no. 9 item refers to item_nbr = 9; store no.11 refers to store_nbr = 11; sold on 2012/12/7 refers to date = '2012-12-07'
SQL: SELECT units FROM sales_in_weather WHERE `date` = '2012-12-07' AND store_nbr = 11 AND item_nbr = 9

Database: public_review_platform
Question: How much time do businesses in El Mirage City, AZ State operate in average daily?
Evidence: how much time does this business open refers to SUBTRACT(closing_time, opening_time); DIVIDE(SUM(SUBTRACT(closing_time, opening_time)), SUM(Business.business_id))
SQL: SELECT SUM(T2.closing_time - T2.opening_time) FROM Business AS T1 INNER JOIN Business_Hours AS T2 ON T1.business_id = T2.business_id WHERE T1.city = 'El Mirage' AND T1.state = 'AZ'

Database: public_review_platform
Question: In how many businesses with the ambience_trendy attribute?
Evidence: ambience_trendy attribute refers to attribute_name = 'ambience_trendy' AND attribute_value = 'false'
SQL: SELECT COUNT(T2.business_id) FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T1.attribute_name = 'ambience_trendy' AND T2.attribute_value IN ('none', 'no', 'false')

Database: food_inspection
Question: Provide the name of the business which had the most number of inspections because of complaint.
Evidence: the most number of inspections because of complaint refers to type = 'Complaint' where MAX(business_id);
SQL: SELECT T2.name FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.type = 'Complaint' GROUP BY T2.name ORDER BY COUNT(T1.business_id) DESC LIMIT 1

Database: ice_hockey_draft
Question: Name the player who has the most NHL points in draft year.
Evidence: name of the player refers to PlayerName; most NHL points in draft year refers to MAX(P);
SQL: SELECT T2.PlayerName FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.P = ( SELECT MAX(P) FROM SeasonStatus )

Database: movies_4
Question: List all the actors who have played characters with "captain" in their names.
Evidence: List all the actors refers to person_name; characters with "captain" in their names refers to character_name LIKE '%captain%';
SQL: SELECT DISTINCT T1.person_name FROM person AS T1 INNER JOIN movie_cast AS T2 ON T1.person_id = T2.person_id WHERE T2.character_name LIKE '%captain%'

Database: olympics
Question: Provide the name of competitors from Greece.
Evidence: name refers to full_name; Greece refers to region_name = 'Greece';
SQL: SELECT T3.full_name FROM noc_region AS T1 INNER JOIN person_region AS T2 ON T1.id = T2.region_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T1.region_name = 'Greece'

Database: cars
Question: Please list the names of the top 3 most expensive cars.
Evidence: name of the car refers to car_name; the most expensive refers to max(price)
SQL: SELECT T1.car_name FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID ORDER BY T2.price DESC LIMIT 3

Database: codebase_comments
Question: For the repository with '8094' watchers , how many solutions does it contain?
Evidence: repository refers to Repo.Id and RepoId; solutions a repository contains refers to Solution.Id;
SQL: SELECT COUNT(T2.RepoId) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Watchers = 8094

Database: regional_sales
Question: How many furniture cushions orders which have date of order in 2018?
Evidence: furniture cushions orders refer to OrderNumber where Product Name = 'Furniture Cushions'; date of order in 2018 refers to SUBSTR(OrderDate, -2) = '18'
SQL: SELECT SUM(CASE WHEN T1.OrderDate LIKE '%/%/18' AND T2.`Product Name` = 'Furniture Cushions' THEN 1 ELSE 0 END) FROM `Sales Orders` AS T1 INNER JOIN Products AS T2 ON T2.ProductID = T1._ProductID

Database: soccer_2016
Question: How many players were born after the year 1985?
Evidence: born after the year 1985 refers to SUBSTR(DOB, 1, 4) > 1985
SQL: SELECT COUNT(Player_Id) FROM Player WHERE SUBSTR(DOB, 1, 4) > 1985

Database: movie_platform
Question: How many users gave "Pavee Lackeen: The Traveller Girl" movie a rating score of 4?
Evidence: FALSE;
SQL: SELECT COUNT(T2.user_id) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Pavee Lackeen: The Traveller Girl' AND T2.rating_score = 4

Database: movies_4
Question: Please list the titles of all the movie produced by production company "Universal Pictures".
Evidence: "Universal Pictures" refers to company_name = 'Universal Pictures'
SQL: SELECT T3.title FROM production_company AS T1 INNER JOIN movie_company AS T2 ON T1.company_id = T2.company_id INNER JOIN movie AS T3 ON T2.movie_id = T3.movie_id WHERE T1.company_name = 'Universal Pictures'

Database: language_corpus
Question: What number of words are there on revision page 27457362?
Evidence: This is not;
SQL: SELECT words FROM pages WHERE revision = 27457362

Database: restaurant
Question: Which county is El Cerrito from?
Evidence: El Cerrito refers to city = 'el cerrito'
SQL: SELECT county FROM geographic WHERE city = 'el cerrito'

Database: synthea
Question: How many immunizations did the patient with the most prevalent condition that started recently get?
Evidence: patient with the most prevalent condition refers to patient where MAX(PREVALENCE RATE); started recently refers to MAX(START);
SQL: SELECT COUNT(T2.patient) FROM all_prevalences AS T1 INNER JOIN conditions AS T2 ON lower(T1.ITEM) = lower(T2.DESCRIPTION) INNER JOIN immunizations AS T3 ON T2.PATIENT = T3.PATIENT GROUP BY T2.PATIENT ORDER BY T2.START DESC, T1."PREVALENCE RATE" DESC LIMIT 1

Database: student_loan
Question: Among the students from the navy department, how many of them have payment due?
Evidence: from the navy department refers to organ = 'navy'; have payment due refers to bool = 'pos';
SQL: SELECT COUNT(T1.name) FROM enlist AS T1 INNER JOIN no_payment_due AS T2 ON T1.`name` = T2.`name` WHERE T1.organ = 'navy' AND T2.bool = 'pos'

Database: professional_basketball
Question: Name the teams along with the coaches that went to 'Quarter Final' round in 1946.
Evidence: team name refers to teams.name; coach refers to coachID; 'Quarter Final' round refers to round = 'QF'; in 1946 refers to year = 1946
SQL: SELECT DISTINCT T1.coachID, T3.name FROM coaches AS T1 JOIN series_post AS T2 ON T1.tmID = T2.tmIDWinner JOIN teams AS T3 ON T3.tmID = T1.tmID WHERE T2.round = 'QF' AND T2.year = 1946

Database: language_corpus
Question: What are the word pairs that occured only twice?
Evidence: word pair refers to w1st.word w2nd.word; occured only twice refers to occurrences = 2
SQL: SELECT T1.word, T3.word FROM words AS T1 INNER JOIN biwords AS T2 ON T1.wid = T2.w1st INNER JOIN words AS T3 ON T3.wid = T2.w2nd WHERE T2.occurrences = 2