Database: beer_factory
Question: What is the average star rating given by female customers to brand ID 10018 from 1/25/2015 to 3/10/2015?
Evidence: average star rating = AVG(StarRating); female customers refers to Gender = 'F; from 1/25/2015 to 3/10/2015 refers to ReviewDate BETWEEN '2015-01-25' AND '2015-03-10';
SQL: SELECT AVG(T2.StarRating) FROM customers AS T1 INNER JOIN rootbeerreview AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.BrandID = 10018 AND T1.Gender = 'F' AND T2.ReviewDate BETWEEN '2013-01-25' AND '2015-03-10'

Database: authors
Question: How many journals have a word "computing" in its full name?
Evidence: word computing refers to FullName LIKE '%computing%'
SQL: SELECT COUNT(Id) FROM Journal WHERE FullName LIKE '%computing%'

Database: authors
Question: Who is the author of the paper titled "Open Sourcing Social Solutions (Building Communities of Change)"?
Evidence: 'Open Sourcing Social Solutions (Building Communities of Change)' is a title of the paper; author refers to PaperAuthor.Name
SQL: SELECT T2.Name FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T1.Title = 'Open Sourcing Social Solutions (Building Communities of Change)'

Database: world
Question: How many countries have a life expectancy of 75.1?
SQL: SELECT COUNT(*) FROM Country WHERE LifeExpectancy = 75.1

Database: movie_3
Question: List the inventory ID of the film titled "African Egg".
Evidence: 'African Egg' is a title of a film
SQL: SELECT T2.inventory_id FROM film AS T1 INNER JOIN inventory AS T2 ON T1.film_id = T2.film_id WHERE T1.title = 'African Egg'

Database: food_inspection
Question: Give the description of the moderate risk violation which "Chez Fayala, Inc." had on 2016/7/1.
Evidence: "Chez Fayala, Inc." is the name of the business; moderate risk violation refers to risk_category = 'Moderate Risk'; date = '2016-07-01';
SQL: SELECT T1.description FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T2.name = 'Chez Fayala, Inc.' AND T1.`date` = '2016-07-01' AND T1.risk_category = 'Moderate Risk'

Database: soccer_2016
Question: List down the name of venues in season 2.
Evidence: name of venues refers to Venue_Name; season 2 refers to Season_Id = 2
SQL: SELECT T2.Venue_Name FROM Match AS T1 INNER JOIN Venue AS T2 ON T2.Venue_Id = T1.Venue_Id WHERE T1.Season_Id = 2 GROUP BY T2.Venue_Name

Database: synthea
Question: List the full name of all patients with 'otitis media'.
Evidence: full name = first, last; otitis media refers to conditions.DESCRIPTION = 'Otitis media';
SQL: SELECT DISTINCT T1.first, T1.last FROM patients AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Otitis media'

Database: superstore
Question: What are the order date and product name of the order ID CA-2011-137274 from the Central region?
SQL: SELECT T1.`Order Date`, T2.`Product Name` FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T1.`Order ID` = 'CA-2011-137274' AND T2.Region = 'Central'

Database: disney
Question: Who voiced the villain in "The Rescuers"?
Evidence: The Rescuers refers to movie_title = 'The Rescuers'; who voiced refers to voice-actor;
SQL: SELECT T1.`voice-actor` FROM `voice-actors` AS T1 INNER JOIN characters AS T2 ON T2.movie_title = T1.movie WHERE T2.movie_title = 'The Rescuers' AND T1.character = T2.villian

Database: olympics
Question: What is the name of the game in which the oldest Olympian has ever participated?
Evidence: the oldest Olympian refers to id where MAX(age); name of the game refers to games_name;
SQL: SELECT T1.games_name FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id ORDER BY T2.age LIMIT 1

Database: soccer_2016
Question: Among the matches held in 2015, who is the winning team in the match ID 829768?
Evidence: in 2015 refers to Match_Date LIKE '2015%'; the winning team refers to Team_Id = Match_Winner; match ID 829768 refers to Match_Id = 829768
SQL: SELECT T2.Team_Name FROM Match AS T1 INNER JOIN Team AS T2 ON T2.Team_Id = T1.Match_Winner WHERE T1.Match_Date LIKE '2015%' AND T1.Match_Id = 829768

Database: public_review_platform
Question: For the only Yelp business in "Yuma" city, how many "medium" reviews did it get?
Evidence: medium reviews refers to review_length = 'Medium';
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 LIKE 'Yuma' AND T2.review_length LIKE 'Medium'

Database: video_games
Question: Sum the total game sales in every region for platform ID 9658.
Evidence: total game sales refers to multiply(sum(num_sales), 100000); platform ID 9658 refers to game_platform_id = 9658
SQL: SELECT SUM(T.num_sales) * 100000 FROM region_sales AS T WHERE T.game_platform_id = 9658

Database: shipping
Question: What is the name of the customer of ship ID 1147?
Evidence: name of customer refers to cust_name
SQL: SELECT T2.cust_name FROM shipment AS T1 INNER JOIN customer AS T2 ON T1.cust_id = T2.cust_id WHERE T1.ship_id = '1147'

Database: citeseer
Question: Under what classification do the papers that cited word1163 belong?
SQL: SELECT DISTINCT T1.class_label FROM paper AS T1 INNER JOIN content AS T2 ON T1.paper_id = T2.paper_id WHERE T2.word_cited_id = 'word1163'

Database: movielens
Question: Which actor has acted in at least 2 French films? Please list their IDs.
Evidence: France is a country
SQL: SELECT T2.actorid FROM movies AS T1 INNER JOIN movies2actors AS T2 ON T1.movieid = T2.movieid WHERE T1.country = 'France' GROUP BY T2.actorid HAVING COUNT(T1.movieid) > 2

Database: books
Question: Among the books published by publisher "Thomas Nelson", how many of them have over 300 pages?
Evidence: "Thomas Nelson" is the publisher_name; books with over 300 pages refers to num_pages > 300
SQL: SELECT COUNT(*) FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id WHERE T2.publisher_name = 'Thomas Nelson' AND T1.num_pages > 300

Database: movie_3
Question: Which country does Mary Smith live in?
SQL: SELECT T3.country FROM address AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id INNER JOIN country AS T3 ON T2.country_id = T3.country_id INNER JOIN customer AS T4 ON T1.address_id = T4.address_id WHERE T4.first_name = 'MARY' AND T4.last_name = 'SMITH'

Database: european_football_1
Question: What is the name of the home team in division P1 with the highest final time goal in all seasons?
Evidence: the highest final time goal refers to MAX(FTHG); P1 = Div;
SQL: SELECT HomeTeam FROM matchs WHERE Div = 'P1' AND season = 2021 ORDER BY FTHG DESC LIMIT 1

Database: synthea
Question: Calculate the number of female patients who accepted "HPV quadrivalent" immunization.
Evidence: female refers to gender = 'F'; "HPV quadrivalent" immunization refers to immunizations where DESCRIPTION = 'HPV quadrivalent';
SQL: SELECT COUNT(DISTINCT T1.patient) FROM patients AS T1 INNER JOIN immunizations AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'HPV  quadrivalent' AND T1.gender = 'F'

Database: bike_share_1
Question: Are all stations with zip code 94107 located in San Francisco city?
Evidence: station refers to name;
SQL: SELECT DISTINCT T2.city FROM trip AS T1 INNER JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T1.zip_code = 94107

Database: public_review_platform
Question: Give the number of users who joined Yelp since "2004".
Evidence: joined yelp since 2004 refers to user_yelping_since_year = 2004;
SQL: SELECT COUNT(user_id) FROM Users WHERE user_yelping_since_year = 2004