Database: bike_share_1
Question: For the rides that started at Market at 10th station and ended at South Van Ness at Market station in August of 2013, which day had the coldest temperature?
Evidence: started at refers to start_station_name; start_station_name = 'Market at 10th'; ended at refers to end_station_name; end_station_name = 'South Van Ness at Market'; in August of 2013 refers to start_date BETWEEN '8/1/2013 0:00' AND '8/31/2013 12:59'; day that had the coldest temperature refers to MIN(min_temperature_f);
SQL: SELECT T1.start_date FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code AND T2.date = SUBSTR(CAST(T1.start_date AS TEXT), 1, INSTR(T1.start_date, ' ') - 1) WHERE T2.date LIKE '8/%/2013' AND T1.start_station_name = 'Market at 10th' AND T1.end_station_name = 'South Van Ness at Market' AND T2.min_temperature_f = ( SELECT MIN(T2.min_temperature_f) FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code AND T2.date = SUBSTR(CAST(T1.start_date AS TEXT), 1, INSTR(T1.start_date, ' ') - 1) WHERE T2.date LIKE '8/%/2013' AND T1.start_station_name = 'Market at 10th' AND T1.end_station_name = 'South Van Ness at Market' )

Database: food_inspection_2
Question: How many inspections were done in January 2011?
Evidence: in January 2011 refers to inspection_date like '2011-01%'
SQL: SELECT COUNT(inspection_id) FROM inspection WHERE strftime('%Y-%m', inspection_date) = '2011-01'

Database: public_review_platform
Question: How long does Yelp_Business no.1 open on Tuesdays?
Evidence: "How long" and "how much time" are synonyms; how much time does this business open refers to subtract(closing_time, opening_time); Yelp_Business no.1 refers to business_id = 1; Tuesdays refers to day_of_week = 'Tuesday'
SQL: SELECT T1.closing_time - T1.opening_time AS "opening hours" FROM Business_Hours AS T1 INNER JOIN Days AS T2 ON T1.day_id = T2.day_id WHERE T2.day_of_week LIKE 'Tuesday' AND T1.business_id = 1

Database: soccer_2016
Question: Among the players who were born in 1977, provide names and birthdates of the players from England.
Evidence: born in 1977 refers to DOB LIKE '1977%'; name refers to Player_Name; birthdate refers to DOB; England refers to Country_Name = 'England'
SQL: SELECT T2.Player_Name, T2.DOB FROM Country AS T1 INNER JOIN Player AS T2 ON T2.Country_Name = T1.Country_Id WHERE T2.DOB LIKE '1977%' AND T1.Country_Name = 'England'

Database: sales_in_weather
Question: Between the stores under weather station 12, what is the percentage of item 5 sold in store 10 in 2014?
Evidence: weather station 12 refers to station_nbr = 12; item 5 refers to item_nbr = 5; 10 store refers to store_nbr = 10; in 2014 refers to SUBSTR(date, 1, 4) = '2014'; percentage = Divide (Sum(units where store_nbr = 10), Sum(units)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T2.store_nbr = 10 THEN units * 1 ELSE 0 END) AS REAL) * 100 / SUM(units) FROM relation AS T1 INNER JOIN sales_in_weather AS T2 ON T1.store_nbr = T2.store_nbr WHERE station_nbr = 12 AND item_nbr = 5 AND T2.`date` LIKE '%2014%'

Database: retail_world
Question: How many employees have obtained a doctorate?
Evidence: doctorate refers to TitleOfCourtesy = 'Dr.;
SQL: SELECT COUNT(EmployeeID) FROM Employees WHERE TitleOfCourtesy = 'Dr.'

Database: retail_world
Question: What are the territory descriptions of territories in the Eastern region?
Evidence: in the Eastern region refers to RegionDescription = 'Eastern'
SQL: SELECT DISTINCT T1.TerritoryDescription FROM Territories AS T1 INNER JOIN Region AS T2 ON T1.RegionID = T2.RegionID WHERE T2.RegionDescription = 'Eastern' ORDER BY T1.TerritoryDescription

Database: craftbeer
Question: Of all the beer styles produced by Stevens Point Brewery, how many percent do they allot for American Adjunct Lager?
Evidence: Percent allotted = count(American Adjunct Lager beer styles) / count(styles) * 100%
SQL: SELECT CAST(SUM(IIF(T1.style = 'American Adjunct Lager', 1, 0)) AS REAL) * 100 / COUNT(T1.brewery_id) FROM beers AS T1 INNER JOIN breweries AS T2 ON T1.brewery_id = T2.id WHERE T2.name = 'Stevens Point Brewery'

Database: menu
Question: Please describe the menu sponsored by Noviomagus physically.
Evidence: describe the menu physically refers to physical_description; sponsored by Noviomagus refers to sponsor = 'Noviomagus';
SQL: SELECT physical_description FROM Menu WHERE sponsor = 'Noviomagus'

Database: retails
Question: How many suppliers have their accounts in debt?
Evidence: account in debt refers to s_acctbal < 0
SQL: SELECT COUNT(s_suppkey) FROM supplier WHERE s_acctbal < 0

Database: citeseer
Question: Among all the citation, what is the percentage of paper ID under the Agents classification?
Evidence: classification refers to class_label; class_label = 'Agents'; percentage = (divide(count(paper_id where class_label = 'Agents')), (count(paper_id)))*100;
SQL: SELECT CAST(COUNT(CASE WHEN class_label = 'Agents' THEN paper_id ELSE NULL END) AS REAL) * 100 / COUNT(paper_id) FROM paper

Database: regional_sales
Question: How many CDP stores are there in California?
Evidence: California is a state; CDP stores refer to StoreID where Type = 'CDP';
SQL: SELECT SUM(CASE WHEN State = 'California' AND Type = 'CDP' THEN 1 ELSE 0 END) FROM `Store Locations`

Database: sales
Question: How many chainring bolts were sold under sales ID 551971?
Evidence: Chainring Bolts' is name of product;
SQL: SELECT T1.Quantity FROM Sales AS T1 INNER JOIN Products AS T2 ON T1.ProductID = T2.ProductID WHERE T2.Name = 'Chainring Bolts' AND T1.SalesID = 551971

Database: movie_3
Question: Indicate the title of all the films that are in the Classics category.
Evidence: 'classics' is the name of category
SQL: SELECT T2.title FROM film_category AS T1 INNER JOIN film AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T1.category_id = T3.category_id WHERE T3.name = 'Classics'

Database: law_episode
Question: Please list all the keywords for the episodes with a rating of over 8.
Evidence: a rating of over 8 refers to rating > 8
SQL: SELECT T2.keyword FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id WHERE T1.rating > 8

Database: car_retails
Question: What was the total price of the products shipped to Rovelli Gifts Distributors Ltd. between 1/1/2003 and 12/31/2003?
Evidence: Mini Gifts Distributors Ltd. Is the customer name; shippedDate between '2003-01-01' and '2003-12-31'; total price = MULTIPLY(quantityOrdered, priceEach);
SQL: SELECT T3.priceEach * T3.quantityOrdered FROM customers AS T1 INNER JOIN orders AS T2 ON T1.customerNumber = T2.customerNumber INNER JOIN orderdetails AS T3 ON T2.orderNumber = T3.orderNumber WHERE T1.customerName = 'Rovelli Gifts' AND T2.status = 'Shipped' AND STRFTIME('%Y', T2.shippedDate) = '2003'

Database: book_publishing_company
Question: Which employee has the lowest job level. State the first name, last name and when he /she was hired.
Evidence: lowest job level refers to MIN(job_lvl)
SQL: SELECT fname, lname, hire_date FROM employee ORDER BY job_lvl LIMIT 1

Database: restaurant
Question: In restaurants with a review of 2, how many restaurants have a street number below 500?
Evidence: review of 2 refers to review = 2; street number below 500 refers to street_num < 500
SQL: SELECT COUNT(T1.id_restaurant) FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T2.review = 2 AND T1.street_num < 500

Database: cars
Question: List the price of Ford cars from model 1970 to 1980.
Evidence: Ford cars refers to car_name LIKE 'ford%'; from model 1970 to 1980 refers to model_year BETWEEN 1970 AND 1980
SQL: SELECT DISTINCT T3.price FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN price AS T3 ON T3.ID = T2.ID WHERE T1.car_name LIKE 'ford%' AND T2.model_year BETWEEN 1970 AND 1980