Database: cars
Question: What is the miles per square hour of the cheapest car produced by the USA?
Evidence: miles per square hour refers to acceleration; the cheapest refers to min(price); produced by the USA refers to country = 'USA'
SQL: SELECT T4.acceleration FROM price AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country INNER JOIN data AS T4 ON T4.ID = T1.ID WHERE T3.country = 'USA' ORDER BY T1.price ASC LIMIT 1

Database: cs_semester
Question: Name the students of the Advanced Database Systems course with the highest satisfaction.
Evidence: full the students = f_name, l_name; course refers to name; satisfaction refers to sat; highest satisfaction refers to MAX(sat);
SQL: SELECT T1.f_name, T1.l_name FROM student AS T1 INNER JOIN registration AS T2 ON T1.student_id = T2.student_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.name = 'Advanced Database Systems' ORDER BY T2.sat DESC LIMIT 1

Database: olympics
Question: What was the medal that Coleen Dufresne got?
Evidence: What medal refers to medal_name;
SQL: SELECT T4.medal_name FROM person AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.person_id INNER JOIN competitor_event AS T3 ON T2.id = T3.competitor_id INNER JOIN medal AS T4 ON T3.medal_id = T4.id WHERE T1.full_name = 'Coleen Dufresne (-Stewner)'

Database: movie_3
Question: Who is the customer that is active and lives at 1795 Santiago de Compostela Way, Texas?
Evidence: active refers to active = 1; '1795 Santiago de Compostela Way' is an address; Texas is a district; who refers to first_name, last_name
SQL: SELECT T1.first_name, T1.last_name FROM customer AS T1 INNER JOIN address AS T2 ON T1.address_id = T2.address_id WHERE T2.address = '1795 Santiago de Compostela Way' AND T1.active = 1

Database: disney
Question: Who is the most productive director?
Evidence: Most productive director refers to director where MAX(COUNT(name));
SQL: SELECT director FROM director GROUP BY director ORDER BY COUNT(name) DESC LIMIT 1

Database: app_store
Question: List all the comments on the lowest rated Mature 17+ app.
Evidence: comments refers to Translated_Review; lowest rated refers to Rating = 1; Mature 17+ refers to Content Rating = 'Mature 17+ ';
SQL: SELECT T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1."Content Rating" = 'Mature 17+' ORDER BY T1.Rating LIMIT 1

Database: chicago_crime
Question: How many crimes were handled by Brendan Reilly on 7th October 2018?
Evidence: 7th October 2018 refers to date like '10/7/2018%'
SQL: SELECT SUM(CASE WHEN T2.alderman_last_name = 'Reilly' THEN 1 ELSE 0 END) FROM Crime AS T1 INNER JOIN Ward AS T2 ON T1.ward_no = T2.ward_no WHERE T2.alderman_name_suffix IS NULL AND T2.alderman_first_name = 'Brendan' AND date LIKE '10/7/2018%'

Database: movies_4
Question: How many crew members worked as producer in the movie "Pirates of the Caribbean: At World's End"?
Evidence: worked as producer refers to job = 'Producer'; "Pirates of the Caribbean: At World's End" refers to title = 'Pirates of the Caribbean: At World''s End'
SQL: SELECT COUNT(T3.person_id) FROM movie AS T1 INNER JOIN movie_crew AS T2 ON T1.movie_id = T2.movie_id INNER JOIN person AS T3 ON T2.person_id = T3.person_id WHERE T1.title LIKE 'Pirates of the Caribbean: At World%s End' AND T2.job = 'Producer'

Database: olympics
Question: What were the cities in which John Aalberg competed?
Evidence: cities refer to city_name;
SQL: SELECT T4.city_name FROM person AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.person_id INNER JOIN games_city AS T3 ON T2.games_id = T3.games_id INNER JOIN city AS T4 ON T3.city_id = T4.id WHERE T1.full_name = 'John Aalberg'

Database: movie_3
Question: Please give the full name of the customer that have rented the most films.
Evidence: full name refers to first_name, last_name; customer who rented the most film refers to Max(count(rental_id))
SQL: SELECT T.first_name, T.last_name FROM ( SELECT T1.first_name, T1.last_name, COUNT(T2.rental_id) AS num FROM customer AS T1 INNER JOIN rental AS T2 ON T1.customer_id = T2.customer_id GROUP BY T1.first_name, T1.last_name ) AS T ORDER BY T.num DESC LIMIT 1

Database: chicago_crime
Question: What is the percentage of under $500 thefts among all cases that happened in West Englewood?
Evidence: under $500 refers to secondary_description = '$500 AND UNDER'; theft refers to primary_description = 'THEFT'; West Englewood refers to community_area_name = 'West Englewood'; percentage = divide(count(case_number where secondary_description = '$500 AND UNDER'), count(case_number)) where primary_description = 'THEFT' and community_area_name = 'West Englewood' * 100%
SQL: SELECT CAST(SUM(CASE WHEN T2.secondary_description = '$500 AND UNDER' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.case_number) FROM Crime AS T1 INNER JOIN IUCR AS T2 ON T1.iucr_no = T2.iucr_no INNER JOIN Community_Area AS T3 ON T1.community_area_no = T3.community_area_no WHERE T2.primary_description = 'THEFT' AND T3.community_area_name = 'West Englewood'

Database: student_loan
Question: List out all bankrupt students that are able to make payment before due?
Evidence: make payment before due refers to bool = 'neg';
SQL: SELECT T1.name FROM filed_for_bankrupcy AS T1 INNER JOIN no_payment_due AS T2 ON T1.name = T2.name WHERE T2.bool = 'neg'

Database: app_store
Question: List out the top 3 genre for application with a sentiment review greater than 0.5.
Evidence: sentiment review refers to Sentiment_Polarity; Sentiment_Polarity>0.5;
SQL: SELECT Genres FROM playstore WHERE App IN ( SELECT App FROM user_reviews WHERE Sentiment = 'Positive' AND Sentiment_Polarity > 0.5 ORDER BY Sentiment_Polarity DESC LIMIT 3 )

Database: legislator
Question: List the full name of all current female senators.
Evidence: full name refers to official_full_name; female refers to gender_bio = 'F'; senators refers to type = 'sen'
SQL: SELECT T2.first_name, T2.last_name FROM `current-terms` AS T1 INNER JOIN current AS T2 ON T2.bioguide_id = T1.bioguide WHERE T1.type = 'sen' AND T2.gender_bio = 'F' GROUP BY T2.ballotpedia_id

Database: student_loan
Question: What is the average absence period of a disabled student?
Evidence: average refers to DIVIDE(SUM(month), COUNT(name))
SQL: SELECT AVG(T1.month) FROM longest_absense_from_school AS T1 INNER JOIN disabled AS T2 ON T1.name = T2.name

Database: student_loan
Question: Among the students with payment due, how many of them are unemployed?
Evidence: with payment due refers to bool = 'pos';
SQL: SELECT COUNT(T1.name) FROM no_payment_due AS T1 INNER JOIN unemployed AS T2 ON T2.name = T1.name WHERE T1.bool = 'pos'

Database: retails
Question: Find the supply key of the top ten suppliers with the most account balance, and list the supply key along with the account balance in descending order of account balance.
Evidence: supply key refers to s_suppkey; the most amount account balance refers to MAX(s_acctbal);
SQL: SELECT s_suppkey, s_acctbal FROM supplier ORDER BY s_acctbal DESC LIMIT 10

Database: shakespeare
Question: What is the description for the character mentioned in paragraph No.640171?
Evidence: paragraph No.640171 refers to paragraphs.id = '640171'
SQL: SELECT T1.Description FROM characters AS T1 INNER JOIN paragraphs AS T2 ON T1.id = T2.character_id WHERE T2.id = '640171'

Database: world
Question: Provide the language used by the people of Belize.
Evidence: Belize is a name of country;
SQL: SELECT T2.Language FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = 'Belize'