Database: app_store
Question: Which of the app is the best selling app and what is the sentiments polarity of it?
Evidence: best selling app = MAX(MULTIPLY(Price, Installs));
SQL: SELECT T1.App, T2.Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App ORDER BY T1.Price * CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 1

Database: cars
Question: Which year did Europe produce the most cars?
Evidence: year refers to model_year; Europe refers to country = 'Europe'; the most cars refers to max(model_year)
SQL: SELECT T1.model_year FROM production AS T1 INNER JOIN country AS T2 ON T1.country = T2.origin WHERE T2.country = 'Europe' GROUP BY T1.model_year ORDER BY COUNT(T1.model_year) DESC LIMIT 1

Database: retail_world
Question: Calculate the total payment of orders for Vegie-spread product.
Evidence: Vegie-spread product refers to ProductName = 'Vegie-spread'；total payment = MULTIPLY(UnitPrice, Quantity, (1-Discount))
SQL: SELECT SUM(T2.UnitPrice * T2.Quantity * (1 - T2.Discount)) AS sum FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T1.ProductName = 'Vegie-spread'

Database: shipping
Question: List the driver's name of the shipment shipped on February 22, 2016.
Evidence: on February 22, 2016 refers to ship_date = '2016-02-22'; driver's name refers to first_name, last_name
SQL: SELECT T2.first_name, T2.last_name FROM shipment AS T1 INNER JOIN driver AS T2 ON T1.driver_id = T2.driver_id WHERE T1.ship_date = '2016-02-22'

Database: superstore
Question: How many furniture products had been shipped by standard class in the East superstore?
Evidence: furniture products refers to Category = 'Furniture'; shipped by standard class refers to "Ship Mode" = 'Standard Class'
SQL: SELECT COUNT(T2.Category) FROM east_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T1.`Ship Mode` = 'Standard Class'

Database: cs_semester
Question: How many courses have the highest difficulty?
Evidence: diff refers to difficulty; diff is higher means the course is more difficult in which highest difficulty is expessed as diff = 5;
SQL: SELECT COUNT(course_id) FROM course WHERE diff = 5

Database: authors
Question: How many papers were published by the "Virtual Reality, IEEE Annual International Symposium" conference in 2012?
Evidence: 'Virtual Reality, IEEE Annual International Symposium' is the FullName of conference; in 2012 refers to Year = 2012;
SQL: SELECT COUNT(T2.Id) FROM Conference AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.ConferenceId WHERE T1.FullName = 'Virtual Reality, IEEE Annual International Symposium' AND T2.Year = 2012

Database: university
Question: List the university ID of the university that scored 100 in 2011.
Evidence: in 2011 refers to year = 2011; score = 100
SQL: SELECT university_id FROM university_ranking_year WHERE score = 100 AND year = 2011

Database: professional_basketball
Question: Which are the teams coached by 'adelmri01' from year 1990-1995. List the team name, year and offense point.
Evidence: year 1990-1995 refers to year between 1990 and 1995; 'adelmri01' is the coachID; offense point refers to o_fgm
SQL: SELECT T2.name, T1.year, T2.o_pts FROM coaches AS T1 INNER JOIN teams AS T2 ON T1.tmID = T2.tmID AND T1.year = T2.year WHERE T1.year BETWEEN 1990 AND 1995 AND T1.coachID = 'adelmri01'

Database: retail_world
Question: How many orders were from Hanna Moos company in 1999?
Evidence: "Hanna Moos" is the CompanyName; in 1999 refer to YEAR (OrderDate) = 1999
SQL: SELECT COUNT(T2.OrderID) FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID WHERE STRFTIME('%Y', T2.OrderDate) = '1999' AND T1.CompanyName = 'Hanna Moos'

Database: university
Question: Calculate number of male students in Emory University in 2011.
Evidence: in 2011 refers to year 2011; number of male students refers to SUBTRACT(num_students, DIVIDE(MULTIPLY(num_students, pct_male_students), 100)); in Emory University refers to university_name = 'Emory University'
SQL: SELECT CAST((T1.num_students - (T1.num_students * T1.pct_female_students)) AS REAL) / 100 FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T2.university_name = 'Emory University' AND T1.year = 2011

Database: university
Question: Provide the ID of the university with the highest percentage of female students in 2012.
Evidence: in 2012 refers to year = 2012; highest percentage of female students  refers to MAX(pct_female_students); ID of the university refers to university_id
SQL: SELECT university_id FROM university_year WHERE year = 2012 ORDER BY pct_female_students DESC LIMIT 1

Database: simpson_episodes
Question: Please list the titles of the episodes that have over 200 voters voting a 10 in star score.
Evidence: over 200 votes refers to votes > 200; 10 in star score refers to stars = 10
SQL: SELECT T1.title FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T2.votes > 200 AND T2.stars = 10;

Database: shooting
Question: How many people were injured between 2006 and 2014 as a result of a handgun?
Evidence: injured refers to subject_statuses = 'injured'; between 2006 and 2014 refers to date between '2006-01-01' and '2013-12-31'; handgun refers to subject_weapon = 'handgun'; where the incidents took place refers to location
SQL: SELECT COUNT(location) FROM incidents WHERE subject_weapon = 'Handgun' AND subject_statuses = 'Injured' AND date BETWEEN '2006-01-01' AND '2013-12-31'

Database: synthea
Question: From 1/9/2011 to 8/29/2012, how many German patients have their outpatient encounters?
Evidence: From 1/9/2011 to 8/29/2012 refers to encounters.DATE between '2011-09-01' and '2012-08-29'; German patients refers to ethnicity = 'german'; outpatient encounters refers to encounters.DESCRIPTION = 'Outpatient Encounter';
SQL: SELECT COUNT(DISTINCT T1.patient) FROM patients AS T1 INNER JOIN encounters AS T2 ON T1.patient = T2.PATIENT WHERE T1.ethnicity = 'german' AND T2.DATE BETWEEN '2011-01-09' AND '2012-08-29' AND T2.DESCRIPTION = 'Outpatient Encounter'

Database: public_review_platform
Question: Who has got the most number of "funny" type of compliments? Give the user ID.
Evidence: type of compliments refers to compliment_type; most number of funny type of compliments refers to MAX(COUNT(number of compliments = 'high' WHERE compliment_type = 'funny'));
SQL: SELECT user_id FROM Users_Compliments WHERE compliment_id IN ( SELECT compliment_id FROM Compliments WHERE compliment_type LIKE 'funny' )

Database: olympics
Question: How many athletes over the age of 59 competed in the 2016 Summer Olympics?
Evidence: over the age of 59 refers to age > 59; the 2016 Summer Olympics refer to games_name = '2016 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 = '2016 Summer' AND T2.age > 59

Database: food_inspection_2
Question: When did Wing Hung Chop Suey Restaurant have its first inspection?
Evidence: Wing Hung Chop Suey Restaurant refers to aka_name = 'WING HUNG CHOP SUEY RESTAURANT'; first inspection refers to min(inspection_date)
SQL: SELECT MIN(T2.inspection_date) FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T1.aka_name = 'WING HUNG CHOP SUEY RESTAURANT'

Database: shipping
Question: What is the full name of the driver who transported the first shipment of the company?
Evidence: first shipment of the company refers to Min(ship_date); full name refers to first_name, last_name
SQL: SELECT T2.first_name, T2.last_name FROM shipment AS T1 INNER JOIN driver AS T2 ON T1.driver_id = T2.driver_id ORDER BY T1.ship_date ASC LIMIT 1

Database: simpson_episodes
Question: What is the summary of the episode in which Emily Blunt is featured in?
SQL: SELECT T1.summary FROM Episode AS T1 INNER JOIN Credit AS T2 ON T1.episode_id = T2.episode_id WHERE T2.person = 'Emily Blunt';