Database: simpson_episodes
Question: How old was the awardee when he/she won the first-ever award for Outstanding Voice-Over Performance in Primetime Emmy Awards?
Evidence: "Outstanding Voice-Over Performance" is the award; 'Primetime Emmy Awards' is the organization; awardee refers to result = 'Winner'; first ever award refers to Min(year); age at the time of awarded refers to Subtract(year, SUBSTR(birthdate, 0, 5))
SQL: SELECT T2.year - CAST(SUBSTR(T1.birthdate, 1, 4) AS int) AS age FROM Person AS T1 INNER JOIN Award AS T2 ON T1.name = T2.person WHERE T2.award = 'Outstanding Voice-Over Performance' AND T2.organization = 'Primetime Emmy Awards' AND T2.result = 'Winner';

Database: chicago_crime
Question: Among the criminal sexual assaults in the district of Adnardo Gutierrez, how many cases happened in the residence?
Evidence: criminal sexual assault refers to title = 'Criminal Sexual Assault'; Adnardo Gutierrez refers to commander = 'Adnardo Gutierrez'; in the residence refers to location_description = 'RESIDENCE'
SQL: SELECT COUNT(T2.report_no) FROM District AS T1 INNER JOIN Crime AS T2 ON T2.district_no = T1.district_no INNER JOIN FBI_Code AS T3 ON T3.fbi_code_no = T2.fbi_code_no WHERE T3.title = 'Criminal Sexual Assault' AND T1.commander = 'Adnardo Gutierrez' AND T2.location_description = 'RESIDENCE'

Database: public_review_platform
Question: How many "bars" are there in the Yelp business?
Evidence: bars refers to category_name = 'Bars';
SQL: SELECT COUNT(T1.category_id) FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id WHERE T1.category_name LIKE 'Bars'

Database: public_review_platform
Question: Among the businesses in Tempe, list the attribute of the business with a medium review count.
Evidence: Tempe is a city; high review count refers to review_count = 'High'
SQL: SELECT DISTINCT T3.attribute_name FROM Business AS T1 INNER JOIN Business_Attributes AS T2 ON T1.business_id = T2.business_id INNER JOIN Attributes AS T3 ON T2.attribute_id = T3.attribute_id WHERE T1.city = 'Tempe' AND T1.review_count = 'Medium'

Database: movie_platform
Question: How many movies were added to the list with the most number of movies? Indicate whether the user was a paying subscriber or not when he created the list.
Evidence: list with the most number of movies refers to MAX(list_movie_number); user_has_payment_method = 1 means the user was a paying subscriber when he created the list; user_has_payment_method = 0 means the user was not a paying subscriber when he created the list;
SQL: SELECT T1.list_movie_number, T2.user_has_payment_method FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id ORDER BY T1.list_movie_number DESC LIMIT 1

Database: public_review_platform
Question: What are the most common compliments types received by user with uber number of fans?
Evidence: the most common compliments types refer to MAX(COUNT(compliment_id)); user_fans = 'uber';
SQL: SELECT DISTINCT T3.compliment_type FROM Users AS T1 INNER JOIN Users_Compliments AS T2 ON T1.user_id = T2.user_id INNER JOIN Compliments AS T3 ON T2.compliment_id = T3.compliment_id WHERE T1.user_fans = 'Uber'

Database: software_company
Question: List down the customer's geographic identifier who are handlers or cleaners.
Evidence: geographic identifier refers to GEOID; OCCUPATION = 'Handlers-cleaners';
SQL: SELECT GEOID FROM Customers WHERE OCCUPATION = 'Handlers-cleaners'

Database: retails
Question: List the name of the top ten items with the most quantity available in the descending order of availability.
Evidence: items with the most quantity available refer to p_name where MAX(ps_availqty);
SQL: SELECT T1.p_name FROM part AS T1 INNER JOIN partsupp AS T2 ON T1.p_partkey = T2.ps_partkey ORDER BY T2.ps_availqty DESC LIMIT 10

Database: food_inspection
Question: In businesses with a score lower than 95 and located around the postal code of 94110, what is the percentage of businesses with a risk category of low risk?
Evidence: DIVIDE(COUNT(business_id where risk_category = 'Low Risk', score < 95 and postal_code = 94110), COUNT(business_id where score < 95 and postal_code = 94110)) as percentage;
SQL: SELECT CAST(SUM(CASE WHEN T1.risk_category = 'Low Risk' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.risk_category) FROM violations AS T1 INNER JOIN inspections AS T2 ON T1.business_id = T2.business_id INNER JOIN businesses AS T3 ON T2.business_id = T3.business_id WHERE T2.score < 95 AND T3.postal_code = 94110

Database: app_store
Question: List apps whose rating is 3.9 and state the translated review of each app.
Evidence: lowest rating refers to Rating = 1;
SQL: SELECT T1.App, T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating = 3.9

Database: address
Question: List down the area code and country of the city named Savoy.
Evidence: Savoy is the city;
SQL: SELECT T1.area_code, T2.county FROM area_code AS T1 INNER JOIN country AS T2 ON T1.zip_code = T2.zip_code INNER JOIN zip_data AS T3 ON T1.zip_code = T3.zip_code WHERE T3.city = 'Savoy'

Database: sales
Question: Calculate the total quantity of products that are gifts.
Evidence: total quantity = SUM(Quantity); gifts refers to Price = 0;
SQL: SELECT SUM(T2.Quantity) FROM Products AS T1 INNER JOIN Sales AS T2 ON T1.ProductID = T2.ProductID WHERE T1.Price = 0

Database: university
Question: Which country is McMaster University located in?
Evidence: McMaster University refers to university_name = 'McMaster University'; which country refers to country_name
SQL: SELECT T2.country_name FROM university AS T1 INNER JOIN country AS T2 ON T1.country_id = T2.id WHERE T1.university_name = 'McMaster University'

Database: soccer_2016
Question: Provide the match IDs which were held on 18th April 2015.
Evidence: on 18th April 2015 refers to DATE(Match_Date) = '2015-04-18'
SQL: SELECT Match_Id FROM Match WHERE Match_Date LIKE '%2015-04-18%'

Database: synthea
Question: How long did Berry Keebler take the Acetaminophen 160 MG when he was admitted due to acute bronchitis?
Evidence: how long = SUBTRACT(medications.STOP, medications.START); Acetaminophen 160 MG refers to medications.DESCRIPTION = 'Acetaminophen 160 MG'; acute bronchitis refers to medications.REASONDESCRIPTION = 'Acute bronchitis (disorder)';
SQL: SELECT strftime('%J', T2.STOP) - strftime('%J', T2.START) AS takenDays FROM patients AS T1 INNER JOIN medications AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Berry' AND T1.last = 'Keebler' AND T2.REASONDESCRIPTION = 'Acute bronchitis (disorder)' AND T2.DESCRIPTION = 'Acetaminophen 160 MG'

Database: professional_basketball
Question: In which league did the player who weighs 40% less than the heaviest player and whose height is 80 inches play?
Evidence: weigh 40% less than the heaviest player refers to weight = Multiply(Max (weight), 0.6); league refers to lgID
SQL: SELECT T2.lgID FROM players AS T1 INNER JOIN players_teams AS T2 ON T1.playerID = T2.playerID GROUP BY T2.lgID, T1.weight HAVING T1.weight = MAX(T1.weight) - MAX(T1.weight) * 0.4

Database: public_review_platform
Question: List the closing time and day of week of active businesses in Tempe with stars greater than the 70% of average age of star rating.
Evidence: active businesses refers to active = 'true'; in Tempe refers to city = 'Tempe'; with stars greater than the 70% of average age of star rating refers to stars > DIVIDE(sum(stars), COUNT(business_id)) * 70%
SQL: SELECT T2.closing_time, T3.day_of_week 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 LIKE 'Tempe' AND T1.active LIKE 'TRUE' AND T1.stars > 0.7 * ( SELECT AVG(T1.stars) 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 LIKE 'Tempe' AND T1.active LIKE 'TRUE' )