Database: public_review_platform
Question: What is the opening time of the active businesses in Glendale that have a medium review count.
Evidence: active business ID refers to active = 'true'; Glendale is a city; medium review count refers to review_count = 'Medium'
SQL: SELECT DISTINCT T2.opening_time FROM Business AS T1 INNER JOIN Business_Hours AS T2 ON T1.business_id = T2.business_id INNER JOIN Days AS T3 ON T2.day_id = T3.day_id WHERE T1.city = 'Glendale' AND T1.review_count = 'Medium' AND T1.active = 'true'

Database: retails
Question: What is the biggest discount among all orders for the part "burnished seashell gainsboro navajo chocolate"?
Evidence: the biggest discount refers to max(l_discount); part "burnished seashell gainsboro navajo chocolate" refers to p_name = 'burnished seashell gainsboro navajo chocolate'
SQL: SELECT MAX(T1.l_discount) FROM lineitem AS T1 INNER JOIN part AS T2 ON T1.l_partkey = T2.p_partkey WHERE T2.p_name = 'burnished seashell gainsboro navajo chocolate'

Database: olympics
Question: How many 20 years old athletes were there in the 1984 Summer Olympic Games?
Evidence: 20 years old athletes refer to person_id where age = 20; 1984 Summer Olympic Games refer to games_name = '1984 Summer';
SQL: SELECT COUNT(T2.person_id) FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id WHERE T1.games_name = '1984 Summer' AND T2.age = 20

Database: retail_world
Question: How many products have been discountinued by New Orleans Cajun Delights?
Evidence: "New Orleans Cajun Delights" is the CompanyName; discontinued refers to Discontinued = 1
SQL: SELECT COUNT(T1.Discontinued) FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'New Orleans Cajun Delights'

Database: regional_sales
Question: What are the top 10 products with the highest net profit?
Evidence: products refers to Product Name; highest net profit = Max(Subtract(Unit Price, Unit Cost))
SQL: SELECT T2.`Product Name` FROM `Sales Orders` AS T1 INNER JOIN Products AS T2 ON T2.ProductID = T1._ProductID GROUP BY T1._ProductID ORDER BY SUM(REPLACE(T1.`Unit Price`, ',', '') - REPLACE(T1.`Unit Cost`, ',', '')) DESC LIMIT 10

Database: retail_world
Question: Calculate the total salary for employees from UK.
Evidence: "UK" is the Country; total salary refers to Sum(Salary)
SQL: SELECT SUM(Salary) FROM Employees WHERE Country = 'UK'

Database: law_episode
Question: Which role have won at least two awards for the entire season and list out the name?
Evidence: at least two awards refers to count(role) >1
SQL: SELECT T1.name FROM Person AS T1 INNER JOIN Award AS T2 ON T1.person_id = T2.person_id GROUP BY T2.role HAVING COUNT(T2.award_id) > 1

Database: app_store
Question: What is the name and category of the app with the highest amount of -1 sentiment polarity score?
Evidence: highest amount of -1 sentiment polarity score refers to MAX(Count(Sentiment_Polarity = 1.0))
SQL: SELECT DISTINCT T1.App, T1.Category FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Polarity = '-1.0'

Database: donor
Question: What is the sum of the total donated amounts paid through Amazon?
Evidence: paid through Amazon refers to payment_method = 'Amazon'; sum of the total donated amounts refers to SUM(donation_to_project,donation_optional_support)
SQL: SELECT SUM(donation_to_project) + SUM(donation_optional_support) FROM donations WHERE payment_method = 'amazon'

Database: movie_3
Question: Please list the full names of all the customers who live in Italy.
Evidence: full name refers to first_name, last_name; Italy refers to country = 'Italy'
SQL: SELECT T4.first_name, T4.last_name 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 T3.country = 'Italy'

Database: authors
Question: Indicate the year and a full name of the journal in which the publication named 'Area Effects in Cepaea' was published.
Evidence: 'Area Effects in Cepaea' is the title of paper
SQL: SELECT T1.Year, T2.FullName FROM Paper AS T1 INNER JOIN Journal AS T2 ON T1.JournalId = T2.Id WHERE T1.Title = 'Area Effects in Cepaea'

Database: mental_health_survey
Question: Which country have the least number of users being surveyed? Indicate the name of the country. If there are multiple countries having the same number of users, indicate all of their names.
Evidence: Country with least number of users being surveyed refers to MIN(COUNT(AnswerText)) where questionid = 3
SQL: SELECT T1.AnswerText FROM Answer AS T1 INNER JOIN Question AS T2 ON T1.QuestionID = T2.questionid WHERE T2.questionid = 3 GROUP BY T1.AnswerText ORDER BY COUNT(T1.UserID) DESC LIMIT 1

Database: chicago_crime
Question: What is the percentage of severe cases that are related to sexual assault?
Evidence: related to sexual assault refers to primary_description = 'CRIME SEXUAL ASSAULT'; severe case refers to index_code = 'I'; percentage = Divide (Count (iucr_no where primary_description = 'CRIME SEXUAL ASSAULT'), Count (iucr_no)) * 100
SQL: SELECT CAST(SUM(CASE WHEN primary_description = 'CRIM SEXUAL ASSAULT' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM IUCR WHERE index_code = 'I'

Database: language_corpus
Question: What is the locale of the language of the page titled "Anys 90"?
Evidence: page titled "Anys 90" refers to title = 'Anys 90';
SQL: SELECT T1.locale FROM langs AS T1 INNER JOIN pages AS T2 ON T1.lid = T2.lid WHERE T2.title = 'Anys 90'

Database: books
Question: Please list the titles of all the books that Lucas Wyldbore has ordered.
SQL: SELECT T1.title FROM book AS T1 INNER JOIN order_line AS T2 ON T1.book_id = T2.book_id INNER JOIN cust_order AS T3 ON T3.order_id = T2.order_id INNER JOIN customer AS T4 ON T4.customer_id = T3.customer_id WHERE T4.first_name = 'Lucas' AND T4.last_name = 'Wyldbore'

Database: social_media
Question: Users in which country has posted more numbers of positive tweets, Argentina or Australia?
Evidence: "Argentina" and "Australia" are both Country; positive tweets refers to Sentiment > 0; Country posted more number of tweets refers to Country where Max(Count(TweetID))
SQL: SELECT T2.Country FROM twitter AS T1 INNER JOIN location AS T2 ON T2.LocationID = T1.LocationID WHERE T2.Country IN ('Argentina', 'Australia') AND T1.Sentiment > 0 GROUP BY T2.Country ORDER BY COUNT(T1.TweetID) DESC LIMIT 1

Database: retails
Question: How many customers are there in India?
Evidence: customers refer to c_custkey; India is the name of the nation which refers to n_name = 'INDIA';
SQL: SELECT COUNT(T1.c_custkey) FROM customer AS T1 INNER JOIN nation AS T2 ON T1.c_nationkey = T2.n_nationkey WHERE T2.n_name = 'INDIA'

Database: simpson_episodes
Question: Please list two people who are the nominees for the "Outstanding Voice-Over Performance" award for season 20.
Evidence: season 20 refers to episode_id LIKE 'S20%'
SQL: SELECT person FROM Award WHERE result = 'Nominee' AND award = 'Outstanding Voice-Over Performance' AND episode_id LIKE 'S20%' LIMIT 2;

Database: soccer_2016
Question: From 2011 to 2012, how many Australian players became the "Man of the Match"?
Evidence: From 2011 to 2012 refers to Match_Date between '2011%' and '2012%'; Australian players refers to Country_Name = 'Australia'
SQL: SELECT SUM(CASE WHEN T1.Match_Date BETWEEN '2011%' AND '2012%' THEN 1 ELSE 0 END) FROM `Match` AS T1 INNER JOIN Player AS T2 ON T2.Player_Id = T1.Man_of_the_Match INNER JOIN Country AS T3 ON T3.Country_Id = T2.Country_Name WHERE T3.Country_Name = 'Australia'