Database: university
Question: Provide the number of students at Yale University in 2016.
Evidence: number of students refers to num_students; Yale University refers to university_name = 'Yale University'; in 2016 refers to year = 2016
SQL: SELECT T1.num_students FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T2.university_name = 'Yale University' AND T1.year = 2016

Database: regional_sales
Question: How many orders placed were with more than 5 product quantities?
Evidence: orders refer to OrderNumber; more than 5 product quantities refer to Order Quantity > 5;
SQL: SELECT SUM(IIF(`Order Quantity` > 5, 1, 0)) FROM `Sales Orders`

Database: cookbook
Question: Among the recipes that take more than 10 minutes to prepare, what is the title of the one with the most calories?
Evidence: more than 10 minutes to prepare refers to prep_min > 10; the most calories refers to MAX(calories)
SQL: SELECT T1.title FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id WHERE T1.prep_min > 10 ORDER BY T2.calories DESC LIMIT 1

Database: superstore
Question: List the name of all products in the west superstore that customers chose for same-day shipment in the year 2013.
Evidence: name of all products refers to Product Name; same-day shipment refers to "Ship Mode" = 'Same Day'; year 2013 refers to "Ship Date" BETWEEN '2013-01-01' AND '2013-12-31'
SQL: SELECT T2.`Product Name` FROM west_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T1.`Ship Mode` = 'Same Day' AND T1.`Ship Date` LIKE '2013%'

Database: chicago_crime
Question: What is the precise location or coordinate where most of the robberies in Rogers Park occurred?
Evidence: precise location or coordinate refers to latitude, longitude; most refers to fbi_code_no = 3; robbery refers to title = 'Robbery'; Rogers Park refers to community_area_name = 'Rogers Park'
SQL: SELECT T2.latitude, T2.longitude FROM Community_Area AS T1 INNER JOIN Crime AS T2 ON T1.community_area_no = T2.community_area_no INNER JOIN FBI_Code AS T3 ON T2.fbi_code_no = T3.fbi_code_no WHERE T1.community_area_name = 'Rogers Park' AND T3.title = 'Robbery' AND T3.fbi_code_no = 3

Database: movie_3
Question: Among the films starred by Angelina Astaire, what is the title of the film with a replacement cost of 27.99?
Evidence: Angelina Astaire' is a full name of an actor; full name refers to first_name, last_name
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 = 'Angelina' AND T1.last_name = 'Astaire' AND T3.replacement_cost = 27.99

Database: image_and_language
Question: What is the relation between object sample no.8 and object sample no.4 in image no.1?
Evidence: relation refers to PRED_CLASS; object sample no.8 and object sample no.4 refers to OBJ1_SAMPLE_ID = 8 AND OBJ2_SAMPLE_ID = 4; image no.1 refers to IMG_ID = 1
SQL: SELECT T1.PRED_CLASS FROM PRED_CLASSES AS T1 INNER JOIN IMG_REL AS T2 ON T1.PRED_CLASS_ID = T2.PRED_CLASS_ID WHERE T2.IMG_ID = 1 AND T2.OBJ1_SAMPLE_ID = 8 AND T2.OBJ2_SAMPLE_ID = 4

Database: movielens
Question: Among the users who gave a rating of 5, how many of them are male?
Evidence: Male users mean that u_gender = 'M'
SQL: SELECT COUNT(T1.userid) FROM u2base AS T1 INNER JOIN users AS T2 ON T1.userid = T2.userid WHERE T1.rating = 5 AND T2.u_gender = 'M'

Database: public_review_platform
Question: Provide business ids with opening hours 10AM on Saturday.
Evidence: opening hours 10AM on Saturday refer to Business_Hours where opening_time = '10AM' and day_id = 6;
SQL: SELECT DISTINCT business_id FROM Business_Hours WHERE day_id = 6 AND opening_time = '10AM'

Database: social_media
Question: What is the gender of the user who tweeted `tw-715909161071091712`?
Evidence: "tw-715909161071091712" is the TweetID
SQL: SELECT T2.Gender FROM twitter AS T1 INNER JOIN user AS T2 ON T1.UserID = T2.UserID WHERE T1.TweetID = 'tw-715909161071091712'

Database: legislator
Question: Provide the type and end date of the term of the legislator named John Vining.
Evidence: end date of the term refers to end;
SQL: SELECT T2.type, T2.end FROM historical AS T1 INNER JOIN `historical-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.first_name = 'John' AND T1.last_name = 'Vining'

Database: world
Question: Within the 5 most crowded cities in the world, which country has the most languages used?
Evidence: most crowded cities refers to MAX(Population); has the most languages used refers to MAX(COUNT(Language));
SQL: SELECT Name FROM ( SELECT T1.Name, T2.Language FROM City AS T1 INNER JOIN CountryLanguage AS T2 ON T1.CountryCode = T2.CountryCode GROUP BY T1.Name, T1.Population, T2.Language ORDER BY T1.Population DESC ) AS T3 GROUP BY t3.Name ORDER BY COUNT(Language) DESC LIMIT 1

Database: chicago_crime
Question: Give the neighborhood name of West Englewood community.
Evidence: West Englewood community refers to community_area_name = 'West Englewood'
SQL: SELECT T1.neighborhood_name FROM Neighborhood AS T1 INNER JOIN Community_Area AS T2 ON T1.community_area_no = T2.community_area_no WHERE T2.community_area_name = 'West Englewood'

Database: image_and_language
Question: State the object class of sample no.10 of image no.2320341.
Evidence: object class refers to OBJ_CLASS; sample no.10 refers to OBJ_SAMPLE_ID = 10; image no.2320341 refers to IMG_ID = 2320341
SQL: SELECT T1.OBJ_CLASS FROM OBJ_CLASSES AS T1 INNER JOIN IMG_OBJ AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.IMG_ID = 2320341 AND T2.OBJ_SAMPLE_ID = 10

Database: shipping
Question: What is the annual revenue of Klett & Sons Repair?
Evidence: "Klett & Sons Repair" is the cust_name
SQL: SELECT annual_revenue FROM customer WHERE cust_name = 'Klett & Sons Repair'

Database: cars
Question: List the names and prices of the cars with model 82 and mileage per gallon of greater than 30.
Evidence: car's name refers to car_name; model 82 refers to model = 82; mileage per gallon of greater than 30 refers to mpg > 30
SQL: SELECT T2.car_name, T1.price FROM price AS T1 INNER JOIN data AS T2 ON T1.ID = T2.ID WHERE T2.model = 82 AND T2.mpg > 30

Database: college_completion
Question: How many 4-year public institutions are there in the state of Florida? Give all of their names.
Evidence: 4-year refers to level = '4-year'; public refers to control = 'Public'; names refers to chronname;
SQL: SELECT T1.chronname FROM institution_details AS T1 INNER JOIN state_sector_details AS T2 WHERE T2.level = '4-year' AND T2.control = 'Public' AND T2.state = 'Florida'

Database: movielens
Question: Please list down the ID of actors and directors in action movies.
SQL: SELECT T2.actorid, T1.directorid FROM movies2directors AS T1 INNER JOIN movies2actors AS T2 ON T1.movieid = T2.movieid WHERE T1.genre = 'Action'

Database: soccer_2016
Question: List down all of the venues in Mumbai.
Evidence: venues refers to Venue_Name; Mumbai refers to City_Name = 'Mumbai'
SQL: SELECT T2.Venue_Name FROM City AS T1 INNER JOIN Venue AS T2 ON T2.City_Id = T1.City_Id WHERE T1.City_Name = 'Mumbai'

Database: video_games
Question: How many games available on PSP were released in 2004?
Evidence: PSP refers to platform_name = 'PSP'; released in 2004 refers to release_year = 2004;
SQL: SELECT COUNT(T3.game_id) FROM platform AS T1 INNER JOIN game_platform AS T2 ON T1.id = T2.platform_id INNER JOIN game_publisher AS T3 ON T2.game_publisher_id = T3.id WHERE T1.platform_name = 'PSP' AND T2.release_year = 2004