Database: cars
Question: How much is the Volkswagen Dasher with 14.1 mph acceleration?
Evidence: cost refers to price; Volkswagen Dasher refers to car_name = 'volkswagen dasher'; 14.1 mph acceleration refers to acceleration = 14.1
SQL: SELECT T2.price FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T1.car_name = 'volkswagen dasher' AND T1.acceleration = '14.1'

Database: movie_3
Question: List down all of the customers' first name who were attended by staff with ID 1.
SQL: SELECT DISTINCT T1.first_name, T1.last_name FROM customer AS T1 INNER JOIN rental AS T2 ON T1.customer_id = T2.customer_id WHERE T2.staff_id = 1

Database: donor
Question: What is the donation message for donation ID a84dace1ff716f6f0c7af8ef9090a5d5?
SQL: SELECT donation_message FROM donations WHERE donationid = 'a84dace1ff716f6f0c7af8ef9090a5d5'

Database: food_inspection
Question: Provide eateries' IDs, names and addresses which were inspected on 30th July, 2016.
Evidence: eateries' IDs inspected on 30th July, 2016 refer to business_id where business_id is not null and date = '2016-07-30';
SQL: SELECT DISTINCT T2.business_id, T2.name, T2.address FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.date = '2016-07-30'

Database: donor
Question: Where is the school that needs a "Viewscreen LCD from Texas Instruments, TI-84 Plus"? Provide the latitude and longitude of that school.
Evidence: needs a "Viewscreen LCD from Texas Instruments, TI-84 Plus" refers to item_name = 'Viewscreen LCD from Texas Instruments, TI-84 Plus'; where is the school refers to school_city; latitude refers to school_latitude; longtitude refers to school_longitude
SQL: SELECT T2.school_city, T2.school_latitude, T2.school_longitude FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.item_name = 'Viewscreen LCD FROM Texas Instruments, TI-84 Plus'

Database: address
Question: In California, how many delivery receptacles are there in the community post office that has the highest number of delivery receptacles?
Evidence: in California refers to name = 'California' and state = 'CA'; 'Community Post Office' is the Type
SQL: SELECT COUNT(*) FROM state AS T1 INNER JOIN zip_data AS T2 ON T1.abbreviation = T2.state WHERE T1.abbreviation = 'CA' AND T2.type LIKE '%Community Post Office%' AND T1.name = 'California' AND T2.state = 'CA'

Database: public_review_platform
Question: How many businesses that are registered in the database can be attributed to 'Good for Kids'?
Evidence: can be attributed to 'Good for Kids' refers to attribute_name = 'Good for Kids' and attribute_value = 'true'
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 = 'Good for Kids' AND T2.attribute_value = 'true'

Database: synthea
Question: What condition forced Mrs. Joye Homenick to seek medical attention in 2017?
Evidence: condition refers to conditions.DESCRIPTION; in 2017 refers to substr(conditions.START, 1, 4) = '2017';
SQL: SELECT T2.DESCRIPTION FROM patients AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Joye' AND T1.last = 'Homenick' AND strftime('%Y', T2.START) = '2017'

Database: olympics
Question: What is the name of the event where competitors received the most gold medals?
Evidence: received the most gold medals refers to MAX(COUNT(medal_name = 'Gold'));
SQL: SELECT T2.event_name FROM competitor_event AS T1 INNER JOIN event AS T2 ON T1.event_id = T2.id INNER JOIN medal AS T3 ON T1.medal_id = T3.id WHERE T3.medal_name = 'Gold' GROUP BY T2.id ORDER BY COUNT(T1.event_id) DESC LIMIT 1

Database: public_review_platform
Question: For the Yelp business in "Tempe" city which got "3.5" stars and review count as "Uber", how many "long" reviews did it get?
Evidence: "Tempe" is the name of city; long review refers to review_length = 'Long'
SQL: SELECT COUNT(T2.review_length) FROM Business AS T1 INNER JOIN Reviews AS T2 ON T1.business_id = T2.business_id WHERE T1.city = 'Tempe' AND T1.stars = '3.5' AND T1.review_count = 'Uber' AND T2.review_length = 'Long'

Database: regional_sales
Question: Name the sales team and the region of order number 'SO - 000137'.
SQL: SELECT T2.`Sales Team`, T2.Region FROM `Sales Orders` AS T1 INNER JOIN `Sales Team` AS T2 ON T2.SalesTeamID = T1._SalesTeamID WHERE T1.OrderNumber = 'SO - 000137'

Database: talkingdata
Question: What is the model of the oldest user's device?
Evidence: model of the device refers to device_model; oldest user refers to MAX(age);
SQL: SELECT T1.device_model FROM phone_brand_device_model2 AS T1 INNER JOIN gender_age AS T2 ON T2.device_id = T1.device_id ORDER BY T2.age DESC LIMIT 1

Database: language_corpus
Question: List the titles for all Catalan language wikipedia page from revision page id 106600 to 106700.
Evidence: from revision page id 106600 to 106700 refers to revision BETWEEN 106600 AND 106700
SQL: SELECT title FROM pages WHERE revision BETWEEN 106600 AND 106700

Database: synthea
Question: Which conditions the patient has when receiving the IPV immunization?
Evidence: IPV immunization refers to immunizations.DESCRIPTION = 'IPV';
SQL: SELECT DISTINCT T2.DESCRIPTION FROM patients AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT INNER JOIN immunizations AS T3 ON T1.patient = T3.PATIENT WHERE T3.DESCRIPTION = 'IPV'

Database: movie_platform
Question: What is Jeannot Szwarc's most popular movie and what is its average rating score?
Evidence: Jeannot Szwarc's refers to director_name = 'Jeannot Szwarc'; most popular movie refers to MAX(movie_popularity); average rating score refers to avg(rating_score)
SQL: SELECT T2.movie_title, AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.director_name = 'Jeannot Szwarc' ORDER BY T2.movie_popularity DESC LIMIT 1

Database: public_review_platform
Question: Among the long reviews made by user ID 3, how many of them have received a medium number of useful votes?
Evidence: long reviews refers to review_length = 'Long'; medium number of useful votes refers to review_votes_useful = 'medium';
SQL: SELECT COUNT(review_length) FROM Reviews WHERE user_id = 3 AND review_length LIKE 'Long' AND review_votes_useful LIKE 'Medium'

Database: retail_world
Question: What are the ID and description of the condiments category?
Evidence: condiments category refers to CategoryName = 'Condiments'; the ID refers to CategoryID
SQL: SELECT CategoryID, Description FROM Categories WHERE CategoryName = 'Condiments'

Database: retail_world
Question: Under the in-charge of inside sales coordinator, provide the product lists which were shipped to Mexico in 1996.
Evidence: shipped to Mexico refers to ShipCountry = 'Mexico'; in 1996 refers to year(ShippedDate) = 1996; charge of inside sales coordinator refers to Title = 'Inside Sales Coordinator'
SQL: SELECT T4.ProductName FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID INNER JOIN `Order Details` AS T3 ON T2.OrderID = T3.OrderID INNER JOIN Products AS T4 ON T3.ProductID = T4.ProductID WHERE T1.Title = 'Inside Sales Coordinator' AND T2.ShippedDate LIKE '1996%' AND T2.ShipCountry = 'Mexico'

Database: world_development_indicators
Question: Please list the indicator names belonging to Education: Inputs topic in 2000.
Evidence: Year = 'YR2000';
SQL: SELECT DISTINCT T2.IndicatorName FROM Footnotes AS T1 INNER JOIN Series AS T2 ON T1.Seriescode = T2.SeriesCode WHERE T1.Year = 'YR2000' AND T2.Topic = 'Education: Inputs'

Database: movie_3
Question: Provide the cast for the film "Jason trap".
Evidence: 'Jason trap' is a title of a film; cast means actor; actor refers to first_name, last_name
SQL: SELECT T1.first_name, T1.last_name FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T3.title = 'JASON TRAP'