Database: retail_complains
Question: List the product reviewed with 1 star on March 14, 2016 from Newton, Massachusetts.
Evidence: 1 star refers to Stars = 1; on March 14, 2016 refers to Date = '2016-03-14'; Newton refers to city = 'Newton'; Massachusetts refers to state_abbrev = 'MA'
SQL: SELECT T2.Product FROM district AS T1 INNER JOIN reviews AS T2 ON T1.district_id = T2.district_id WHERE T1.city = 'Newton' AND T1.state_abbrev = 'MA' AND T2.Date = '2016-03-14' AND T2.Stars = 1

Database: donor
Question: What are the coordinates of the school with the project "Wiping Away Bad Grades"?
Evidence: project "Wiping Away Bad Grades" title = 'Wiping Away Bad Grades'; coordinates refers to school_longitude, school_latitude
SQL: SELECT T1.school_longitude, T1.school_latitude FROM projects AS T1 INNER JOIN essays AS T2 ON T1.projectid = T2.projectid WHERE T2.title LIKE 'Wiping Away Bad Grades'

Database: coinmarketcap
Question: List the names and symbols of the coins that were added on June 14, 2013.
Evidence: added on June 14, 2013 refers to date_added like '2013-06-14%'
SQL: SELECT name, symbol FROM coins WHERE date_added LIKE '2013-06-14%'

Database: chicago_crime
Question: Provide the responsible person and his/her email address of Chicago Lawn.
Evidence: responsible person refers to commander; email address refers to email; Chicago Lawn refers to district_name = 'Chicago Lawn'
SQL: SELECT commander, email FROM District WHERE district_name = 'Chicago Lawn'

Database: european_football_1
Question: How many times did the team Werder Bremen win as the away team in matches of the Bundesliga division?
Evidence: Bundesliga is the name of division; win as the away team refers to FTR = 'A', where 'A' stands for away victory;
SQL: SELECT COUNT(T1.Div) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.name = 'Bundesliga' AND T1.AwayTeam = 'Werder Bremen' AND T1.FTR = 'A'

Database: food_inspection_2
Question: For the sanitarian who lives on 5000 N Wolcott Ave, how many establishments did he/she inspect in the May of 2011?
Evidence: sanitarian refers to title = 'Sanitarian'; 5000 N Wolcott Ave refers to address = '5000 N Wolcott Ave'; in May 2011 refers to inspection_date between '2011-04-30' and '2011-06-01'
SQL: SELECT COUNT(T1.inspection_id) FROM inspection AS T1 INNER JOIN employee AS T2 ON T1.employee_id = T2.employee_id WHERE T2.address = '5000 N Wolcott Ave' AND T2.title = 'Sanitarian' AND strftime('%Y-%m', T1.inspection_date) = '2011-05'

Database: chicago_crime
Question: Where is the coordinate (41.66236555, -87.63470194) located? Give the name of the district.
Evidence: coordinate (41.66236555, -87.63470194) refers to latitude = '41.66236555' AND longitude = '-87.63470194'; name of the district refers to district_name
SQL: SELECT T2.district_name FROM Crime AS T1 INNER JOIN District AS T2 ON T1.district_no = T2.district_no WHERE T1.longitude = '-87.63470194' AND T1.latitude = '41.66236555'

Database: soccer_2016
Question: Which city hosted the least number of no-result matches?
Evidence: city refers to City_Name; no-result matches refers to Win_type = 'NoResult'; least number refers to min(count(Win_type = 'NoResult'))
SQL: SELECT T4.City_Name FROM `Match` AS T1 INNER JOIN Win_By AS T2 ON T1.Win_Type = T2.Win_Id INNER JOIN Venue AS T3 ON T1.Venue_Id = T3.Venue_Id INNER JOIN City AS T4 ON T3.City_Id = T4.City_Id WHERE T2.Win_Type = 'NO Result' GROUP BY T4.City_Id ORDER BY COUNT(T2.Win_Type) ASC LIMIT 1

Database: social_media
Question: From which city was the tweet with the most number of retweets posted?
Evidence: tweet with most number of retweet post refers to Max(RetweetCount)
SQL: SELECT T2.City FROM twitter AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID ORDER BY T1.RetweetCount DESC LIMIT 1

Database: car_retails
Question: List all the name of customers who have orders that are still processing.
Evidence: Still processing refers to status = 'In Process';
SQL: SELECT t2.customerName FROM orders AS t1 INNER JOIN customers AS t2 ON t1.customerNumber = t2.customerNumber WHERE t1.status = 'In Process'

Database: codebase_comments
Question: What is the average processed time of the solution paths inside the "https://github.com/zphingphong/DiscardCustomerApp.git"?
Evidence: average processed time = avg(Solution.ProcessedTime);
SQL: SELECT CAST(SUM(T2.ProcessedTime) AS REAL) / COUNT(T2.RepoId) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Url = 'https://github.com/zphingphong/DiscardCustomerApp.git'

Database: sales
Question: Among the sales ID ranges from 1 to 200, what is the percentage of the products with a price ranging from 200 to 300?
Evidence: sales ID ranges from 1 to 200 refers to SalesID between 1 and 200; percentage = MULTIPLY(DIVIDE(SUM(Price between 200 and 300), COUNT(Price)), 1.0);
SQL: SELECT CAST(SUM(IIF(T2.Price BETWEEN 200 AND 300, 1, 0)) AS REAL) * 100 / COUNT(T2.Price) FROM Sales AS T1 INNER JOIN Products AS T2 ON T1.ProductID = T2.ProductID WHERE T1.SalesID BETWEEN 1 AND 200

Database: regional_sales
Question: Find the net profit of the floral products which were delivered in 2021.
Evidence: floral product refers to Product Name = 'Floral'; total net profit = SUM(Subtract(Unit Price, Unit Cost)); delivered in 2021 refers to DeliveryDate LIKE '%/21'
SQL: SELECT SUM(REPLACE(T1.`Unit Price`, ',', '') - REPLACE(T1.`Unit Cost`, ',', '')) FROM `Sales Orders` AS T1 INNER JOIN Products AS T2 ON T2.ProductID = T1._ProductID WHERE T1.DeliveryDate LIKE '%/%/21' AND T2.`Product Name` = 'Floral'

Database: address
Question: What is the state for area code of 787?
SQL: SELECT DISTINCT T2.state FROM area_code AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.area_code = 787

Database: donor
Question: What were the resources that were requested by the teacher for project "d6ef27c07c30c81f0c16c32b6acfa2ff"? Indicate the quantities as well and whether or not the teacher acquired P.h.D or doctor degree.
Evidence: resources that were requested refers to item_name; project "d6ef27c07c30c81f0c16c32b6acfa2ff" refers to projectid = 'd6ef27c07c30c81f0c16c32b6acfa2ff'; quantities refers to item_quantity; teacher_prefix = 'Dr. ' refers to teacher acquired P.h.D or doctor degree
SQL: SELECT DISTINCT T1.item_name, T1.item_quantity, T2.teacher_prefix FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.projectid = 'd6ef27c07c30c81f0c16c32b6acfa2ff'

Database: retail_world
Question: What are the products by the company "Bigfoot Breweries"?
Evidence: Bigfoot Breweries is the name of the company; products refer to ProductName;
SQL: SELECT T1.ProductName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Bigfoot Breweries'

Database: food_inspection_2
Question: Provide the last name of the employee involved in the inspection ID 52256.
SQL: SELECT DISTINCT T1.last_name FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE T2.inspection_id = 52256

Database: public_review_platform
Question: Is the payment in mastercard possible for the Yelp business No."12476"?
Evidence: Yelp business No."12476" refers to business_id = '12476'; payment in mastercard refers to attribute_value = 'payment_types_mastercard'
SQL: SELECT T1.attribute_value FROM Business_Attributes AS T1 INNER JOIN Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T1.business_id = 12476 AND T2.attribute_name = 'payment_types_mastercard'