Database: university
Question: What is the difference in overall student enrollment and international student enrollment at the Harvard university from 2011 to 2012?
Evidence: Harvard University refers to university_name = 'Harvard University'; difference in overall student enrollment and international student refers to SUBTRACT(SUM(num_students), SUM(DIVIDE(MULTIPLY(pct_international_students, num_students), 100))); from 2011 to 2012 refers to year BETWEEN 2011 AND 2012
SQL: SELECT SUM(T1.num_students) - SUM(CAST(T1.num_students * T1.pct_international_students AS REAL) / 100) FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T2.university_name = 'Harvard University' AND T1.year BETWEEN 2011 AND 2012

Database: social_media
Question: Among all the tweets sent by male users in Argentina, what is the text of the one with the most number of likes?
Evidence: male user refers to Gender = 'Male'; 'Argentina' is the Country; most number of likes refers to Max(Likes)
SQL: SELECT T2.text FROM user AS T1 INNER JOIN twitter AS T2 ON T1.UserID = T2.UserID INNER JOIN location AS T3 ON T2.LocationID = T3.LocationID WHERE T3.Country = 'Argentina' AND T1.Gender = 'Male' ORDER BY T2.Likes DESC LIMIT 1

Database: ice_hockey_draft
Question: How many playoffs did Per Mars participate in?
Evidence: playoffs refers to GAMETYPE = 'Playoffs';
SQL: SELECT SUM(T2.GP) FROM PlayerInfo AS T1 INNER JOIN SeasonStatus AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.PlayerName = 'Per Mars' AND T2.GAMETYPE = 'Playoffs'

Database: movie_platform
Question: What is the average rating score of the 'Pavee Lackeen: The Traveller Girl' movie and what year was it released?
Evidence: year it was released refers to movie_release_year; average rating score refers to AVG(rating_score where movie_title = 'Final Destination 6'); Final Destination 6 refers to movie_title
SQL: SELECT AVG(T1.rating_score), T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Pavee Lackeen: The Traveller Girl'

Database: movie_platform
Question: Name all lists created by a user who was a subcriber when created the list.
Evidence: was a subscriber refers to user_subscriber = 1
SQL: SELECT DISTINCT T2.list_id FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.list_id = T2.list_id WHERE T1.user_subscriber = 1

Database: ice_hockey_draft
Question: Who is the oldest player who played for Avangard Omsk during the regular season in 2000-2001?
Evidence: oldest player refers to MIN(birthdate); Avangard Omsk refers to TEAM = 'Avangard Omsk'; regular season refers to GAMETYPE = 'Regular Season'; 2000-2001 season refers to SEASON = '2000-2001';

SQL: SELECT T2.PlayerName FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.SEASON = '2000-2001' AND T1.GAMETYPE = 'Regular Season' AND T1.TEAM = 'Avangard Omsk' ORDER BY T2.birthdate ASC LIMIT 1

Database: shakespeare
Question: In the Venus and Adonis, what is the description of the last scene listed?
Evidence: Venus and Adonis refers to Title = 'Venus and Adonis'; last scene refers to max(Scene)
SQL: SELECT T2.Description FROM works AS T1 RIGHT JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T1.Title = 'Venus and Adonis' ORDER BY T2.Scene DESC LIMIT 1

Database: retail_world
Question: How many sales representatives whose salaries are higher than 2000?
Evidence: "Sales Representative" is the Title; higher than 2000 refers to Salary > 2000
SQL: SELECT COUNT(Title) FROM Employees WHERE Salary > 2000 AND Title = 'Sales Representative'

Database: chicago_crime
Question: Please list the names of all the neighborhoods in the community area with the most population.
Evidence: name of neighborhood refers to neighborhood_name; the most population refers to max(population)
SQL: SELECT T1.neighborhood_name FROM Neighborhood AS T1 INNER JOIN Community_Area AS T2 ON T2.community_area_no = T2.community_area_no ORDER BY T2.population DESC LIMIT 1

Database: public_review_platform
Question: List down the business ID with a star range from 2 to 3, located at Mesa.
Evidence: star range from 2 to 3 refers to stars > = 2 AND stars < 4;  located at Mesa refers to city = 'Mesa'
SQL: SELECT business_id FROM Business WHERE city LIKE 'Mesa' AND stars BETWEEN 2 AND 3

Database: movie_3
Question: Indicate the title of all the films rated as 'Adults Only'.
Evidence: 'Adults Only' refers to rating = 'NC-17'
SQL: SELECT title FROM film WHERE rating = 'NC-17'

Database: law_episode
Question: What was the rating of the episodes that Jace Alexander worked on?
SQL: SELECT T1.rating FROM Episode AS T1 INNER JOIN Credit AS T2 ON T1.episode_id = T2.episode_id INNER JOIN Person AS T3 ON T3.person_id = T2.person_id WHERE T3.name = 'Jace Alexander'

Database: authors
Question: What are the three journals that the papers written by Andrew Cain were published in? Please provide your answer with the full name of each journal.
Evidence: written by Andrew Cain refers to Name = 'Andrew Cain'
SQL: SELECT T3.FullName FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId INNER JOIN Journal AS T3 ON T1.JournalId = T3.Id WHERE T2.Name = 'Andrew Cain'

Database: simpson_episodes
Question: How many votes of 5-star did the episode "Lisa the Drama Queen" receive?
Evidence: episode "Lisa the Drama Queen" refers to title = 'Lisa the Drama Queen';
SQL: SELECT SUM(T2.votes) FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T1.title = 'Lisa the Drama Queen' AND T2.stars = 5;

Database: chicago_crime
Question: List the community area names in the Northwest.
Evidence: the Northwest refers to side = 'Northwest'
SQL: SELECT community_area_name FROM Community_Area WHERE side = 'Northwest'

Database: simpson_episodes
Question: List all the keyword for 'Take My Life, Please' episode.
Evidence: "Take My Life,Please" is the title of episode
SQL: SELECT T2.keyword FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id WHERE T1.title = 'Take My Life, Please';

Database: european_football_1
Question: What is the most consecutive games tied by Ebbsfleet as an away team in the 2008 season?
Evidence: consecutive games mean happen one after the other without interruption and refer to Date; tied refers to FTR = 'D';
SQL: SELECT COUNT(*) FROM matchs WHERE season = 2008 AND AwayTeam = 'Ebbsfleet' AND FTR = 'D'

Database: retail_complains
Question: Which division is Diesel Galloway in?
SQL: SELECT T2.division FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T1.first = 'Diesel' AND T1.last = 'Galloway'

Database: image_and_language
Question: What is the most common object class of image ID 56?
Evidence: the most common object class of image ID 56 refers to MAX(COUNT(OBJ_CLASS_ID)) where IMG_ID = 56;
SQL: SELECT T2.OBJ_CLASS FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T1.IMG_ID = 56 GROUP BY T2.OBJ_CLASS ORDER BY COUNT(T2.OBJ_CLASS_ID) DESC LIMIT 1

Database: public_review_platform
Question: Write down the number of running business with each review count in Cave Creek city.
Evidence: number of running business refers to COUNT(business_id) where active = 'true'; each review count includes review_count = 'High', review_count = 'Medium', review_count = 'Low';
SQL: SELECT SUM(CASE WHEN review_count = 'High' THEN 1 ELSE 0 END) AS high , SUM(CASE WHEN review_count = 'Medium' THEN 1 ELSE 0 END) AS Medium , SUM(CASE WHEN review_count = 'Low' THEN 1 ELSE 0 END) AS low FROM Business WHERE city = 'Cave Creek' AND active = 'true'

Database: shakespeare
Question: Please list all of the character descriptions in paragraph 20.
Evidence: paragraph 20 refers to ParagraphNum = 20
SQL: SELECT T1.Description FROM characters AS T1 INNER JOIN paragraphs AS T2 ON T1.id = T2.character_id WHERE T2.ParagraphNum = 20