Database: university
Question: In which country does the most populated university in 2014 located ?
Evidence: the most populated university refers to max(num_students); in 2014 refers to year = 2014
SQL: SELECT T2.country_id FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T1.year = 2014 ORDER BY T1.num_students DESC LIMIT 1

Database: student_loan
Question: Count the number of students from UCSD enlisted in the peace corps.
Evidence: in the peace corps refers to organ = 'peace_corps'; from UCSD refers to school = 'ucsd';
SQL: SELECT COUNT(T1.name) FROM enlist AS T1 INNER JOIN enrolled AS T2 ON T1.`name` = T2.`name` WHERE T2.school = 'ucsd' AND T1.organ = 'peace_corps'

Database: disney
Question: List the movie titles and associated songs directed by Ron Clements.
Evidence: Ron Clements refers director = 'Ron Clements';
SQL: SELECT T1.movie_title, T1.song FROM characters AS T1 INNER JOIN director AS T2 ON T1.movie_title = T2.name WHERE T2.director = 'Ron Clements'

Database: craftbeer
Question: When compared to the total number of breweries in the US producing American Blonde Ale, how many in the state of Wisconsin produces American Blonde Ale? Indicate your answer in percentage (%).
Evidence: Percentage of the state of Wisconsin produces American Blonde Ale could be computed by count(breweries in Wisconsin producing American Blonde Ale) / count(all breweries)
SQL: SELECT CAST(SUM(IIF(T2.state = 'WI', 1, 0)) AS REAL) * 100 / COUNT(T1.id) FROM beers AS T1 INNER JOIN breweries AS T2 ON T1.brewery_id = T2.id WHERE T1.style = 'American Blonde Ale'

Database: chicago_crime
Question: Please state the district name where incident number JB106545 took place.
Evidence: incident number JB106545 refers to case_number = 'JB106545'
SQL: SELECT T1.case_number FROM Crime AS T1 INNER JOIN FBI_Code AS T2 ON T1.fbi_code_no = T2.fbi_code_no WHERE T2.title = 'Criminal Sexual Assault' AND T2.crime_against = 'Persons' AND T1.arrest = 'TRUE' LIMIT 3

Database: app_store
Question: Which apps have 5 rating? List out then application name.
Evidence: application name refers to App;
SQL: SELECT DISTINCT App FROM playstore WHERE Rating = 5

Database: restaurant
Question: What type of food is served at the restaurant located at 3140, Alpine Road at San Mateo County?
Evidence: 3140 Alpine Road at San Mateo County refers to street_num = 3140 AND street_name = 'alpine rd' AND County = 'san mateo county'; type of food refers to food_type
SQL: SELECT T2.food_type FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant INNER JOIN geographic AS T3 ON T2.city = T3.city WHERE T3.County = 'san mateo county' AND T1.street_name = 'alpine rd' AND T1.street_num = 3140

Database: authors
Question: How many publications were published in relation to the conference 'Adaptive Multimedia Retrieval' in 2007?
Evidence: 'Adaptive Multimedia Retrieval is the FullName of paper; in 2007 refer to Year = 2007
SQL: SELECT COUNT(T2.ConferenceId) FROM Conference AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.ConferenceId WHERE T1.FullName = 'Adaptive Multimedia Retrieval' AND T2.Year = 2007

Database: movies_4
Question: Which keywords belong to the movie titles with the highest popularity?
Evidence: Which keywords refers to keyword_name; highest popularity refers to max(popularity)
SQL: SELECT T3.keyword_name FROM movie AS T1 INNER JOIN movie_keywords AS T2 ON T1.movie_id = T2.movie_id INNER JOIN keyword AS T3 ON T2.keyword_id = T3.keyword_id ORDER BY T1.popularity DESC LIMIT 1

Database: legislator
Question: Find the difference between the number of female senators and representatives born between 1930 to 1970.
Evidence: difference = SUBTRACT(SUM(type = 'sen' WHERE gender_bio = 'F' AND strftime('%Y', birthday_bio) between '1930' and '1970'), SUM(type = 'rep' WHERE gender_bio = 'F' AND strftime('%Y', birthday_bio) between '1930' and '1970')); female refers to gender_bio = 'F'; senators refers to type = 'sen'; representatives refers to type = 'rep'; born between 1930 to 1970 strftime('%Y', birthday_bio) between '1930' and '1970';
SQL: SELECT SUM(CASE WHEN T2.type = 'sen' THEN 1 ELSE 0 END) - SUM(CASE WHEN T2.type = 'rep' THEN 1 ELSE 0 END) FROM historical AS T1 INNER JOIN `historical-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.gender_bio = 'F' AND strftime('%Y', T1.birthday_bio) BETWEEN '1930' AND '1970'

Database: beer_factory
Question: What is the transaction ratio being made at Sac State American River Courtyard and Sac State Union?
Evidence: transaction ratio = DIVIDE(SUM(TransactionID WHERE LocationName = 'Sac State American River Courtyard'), SUM(TransactionID WHERE LocationName = 'Sac State Union')); Sac State American River Courtyard refers to LocationName = 'Sac State American River Courtyard'; Sac State Union refers to LocationName = 'Sac State Union';
SQL: SELECT CAST(COUNT(CASE WHEN T2.LocationName = 'Sac State American River Courtyard' THEN T1.TransactionID ELSE NULL END) AS REAL) * 100 / COUNT(CASE WHEN T2.LocationName = 'Sac State Union' THEN T1.TransactionID ELSE NULL END) FROM `transaction` AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID

Database: movies_4
Question: What is the iso code of "Kyrgyz Republic"?
Evidence: iso code refers to country_iso_code; "Kyrgyz Republic" refers to country_name = 'Kyrgyz Republic'
SQL: SELECT COUNTry_iso_code FROM COUNTry WHERE COUNTry_name = 'Kyrgyz Republic'

Database: talkingdata
Question: What is the percentage of users who are in the same behavior category as "Academic Information"?
Evidence: percentage = MULTIPLY(DIVIDE(SUM(category = 'Academic Information'), COUNT(app_id)), 1.0); behavior category refers to category; category = 'Academic Information';
SQL: SELECT SUM(IIF(T1.category = 'Academic Information', 1.0, 0)) / COUNT(T2.app_id) AS per FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T1.label_id = T2.label_id

Database: legislator
Question: What is the full name of the oldest legislator?
Evidence: full name = first_name, last_name; oldest legislator refers to MIN(birthday_bio);
SQL: SELECT first_name, last_name FROM historical ORDER BY birthday_bio LIMIT 1

Database: donor
Question: How many number of donations did the project 'A Rug For Reaching Readers' get?
Evidence: A Rug For Reaching Readers'is the title;
SQL: SELECT SUM(T2.donation_total) FROM essays AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T1.title LIKE 'A Rug For Reaching Readers'

Database: simpson_episodes
Question: Please give the name of the director who achieved the Outstanding Animated Program (For Programming Less Than One Hour) award whose episode title is "No Loan Again, Naturally".
Evidence: the director refers to role = 'director'
SQL: SELECT T1.person FROM Award AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE T1.role = 'director' AND T1.award = 'Outstanding Animated Program (For Programming Less Than One Hour)' AND T2.title = 'No Loan Again, Naturally';

Database: retail_world
Question: What is the total amount of sales made in the year 1997?
Evidence: year 1997 refers to year(OrderDate) = 1997; total amount of sales refers to (UnitPrice * Quantity)
SQL: SELECT SUM(T2.UnitPrice * T2.Quantity * (1 - T2.Discount)) FROM Orders AS T1 INNER JOIN `Order Details` AS T2 ON T1.OrderID = T2.OrderID WHERE T1.OrderDate LIKE '1997%'

Database: movie_3
Question: Please give the title of the film starring PENELOPE GUINESS and has the highest replacement cost.
Evidence: highest replacement cost refers to Max (replacement_cost)
SQL: SELECT T3.title FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T1.first_name = 'PENELOPE' AND T1.last_name = 'GUINESS' ORDER BY T3.replacement_cost DESC LIMIT 1