Database: university
Question: What is the name of the university with the highest score in teaching in the year 2011?
Evidence: with the highest score refers to MAX(score); in teaching refers to criteria_name = 'Teaching'; name of university refers to university_name;
SQL: SELECT T3.university_name FROM ranking_criteria AS T1 INNER JOIN university_ranking_year AS T2 ON T1.id = T2.ranking_criteria_id INNER JOIN university AS T3 ON T3.id = T2.university_id WHERE T1.criteria_name = 'Teaching' AND T2.year = 2011 ORDER BY T2.score DESC LIMIT 1

Database: bike_share_1
Question: Please list bikes id were used in trips which start station were installed in 2013.
Evidence: start station refers to start_station_name; installed in 2013 refers to installation_date LIKE '%2013';
SQL: SELECT DISTINCT T1.bike_id FROM trip AS T1 INNER JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T2.installation_date LIKE '%2013'

Database: sales
Question: Among customers with the last name of Valdez, who purchased the highest quantity?
Evidence: highest quantity refers to MAX(Quantity);
SQL: SELECT T1.FirstName FROM Customers AS T1 INNER JOIN Sales AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.LastName = 'Valdez' ORDER BY T2.Quantity DESC LIMIT 1

Database: talkingdata
Question: Among the devices on which an event happened on 2016/5/1, how many of them are used by a male user?
Evidence: on 2016/5/1 refers to timestamp = '2016-05-01'; male refers to gender = 'M';
SQL: SELECT COUNT(T1.device_id) FROM events AS T1 INNER JOIN gender_age AS T2 ON T1.device_id = T2.device_id WHERE T1.timestamp = '2016-05-01' AND T2.gender = 'M'

Database: movie
Question: Which character has the longest screen time in the movie Batman?
Evidence: longest screen time refers to max(screentime); movie Batman refers to title = 'Batman'
SQL: SELECT T2.`Character Name` FROM movie AS T1 INNER JOIN characters AS T2 ON T1.MovieID = T2.MovieID WHERE T1.Title = 'Batman' ORDER BY T2.screentime DESC LIMIT 1

Database: student_loan
Question: List out students that enrolled in occ school and enlisted in a fire department.
Evidence: occ school refers to school = 'occ'; department refers to organ; organ = 'fire_department';
SQL: SELECT T1.name FROM enlist AS T1 INNER JOIN enrolled AS T2 ON T2.name = T1.name WHERE T2.school = 'occ' AND T1.organ = 'fire_department'

Database: olympics
Question: Where was the 1920 Summer held?
Evidence: where it was held refers to city_name; the 1920 Summer refers to games_name = '1920 Summer';
SQL: SELECT T2.city_name FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id INNER JOIN games AS T3 ON T1.games_id = T3.id WHERE T3.games_name = '1920 Summer'

Database: retail_complains
Question: How many Credit Card complaints did Sharon handle?
Evidence: Credit Card refers to Product = 'Credit Card'; Sharon refers to server = 'SHARON';
SQL: SELECT COUNT(T1.`Complaint ID`) FROM callcenterlogs AS T1 INNER JOIN events AS T2 ON T1.`Complaint ID` = T2.`Complaint ID` WHERE T2.Product = 'Credit card' AND T1.server = 'SHARON'

Database: student_loan
Question: Which organization does student 313 belong to?
Evidence: organization refers to organ
SQL: SELECT organ FROM enlist WHERE name = 'studenT113'

Database: university
Question: Please list the IDs of the universities with a student staff ratio of over 15 in 2011.
Evidence: in 2011 refers to year 2011; student staff ratio of over 15 refers to student_staff_ratio > 15; ID of the university refers to university_id
SQL: SELECT university_id FROM university_year WHERE year = 2011 AND student_staff_ratio > 15

Database: social_media
Question: How many female users reshared their tweets?
Evidence: female users refers to Gender = 'Female'; reshare refers to IsReshare = 'TRUE'
SQL: SELECT COUNT(T1.UserID) FROM twitter AS T1 INNER JOIN user AS T2 ON T1.UserID = T2.UserID WHERE T2.Gender = 'Female' AND T1.IsReshare = 'TRUE'

Database: image_and_language
Question: What object class is in the X and Y coordinates of 126 and 363?
Evidence: object class refers to OBJ_CLASS; X and Y coordinates of 126 and 363 refer to coordinates of the bounding box where X = 126 and Y = 363;
SQL: SELECT T1.IMG_ID, 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.X = 126 AND T1.Y = 363

Database: movie_3
Question: For how long can you rent the movie 'Dirty Ace'?
Evidence: length refers to rental_duration; 'Dirty Ace' refers to title = 'DIRTY ACE'
SQL: SELECT rental_duration FROM film WHERE title = 'DIRTY ACE'

Database: shipping
Question: Among the top 5 heaviest shipments, how many shipments were transported via Mack?
Evidence: heaviest shipment refers to Max(weight); via Mack refers to make = 'Mack'
SQL: SELECT COUNT(T2.ship_id) FROM truck AS T1 INNER JOIN shipment AS T2 ON T1.truck_id = T2.truck_id WHERE T1.make = 'Mack' ORDER BY T2.weight DESC LIMIT 1

Database: simpson_episodes
Question: In 2010, which episode did Joel H. Cohen win an award for?
Evidence: In 2010 refers to year = 2010
SQL: SELECT T2.title FROM Award AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE SUBSTR(T1.year, 1, 4) = '2010' AND T1.person = 'Joel H. Cohen';

Database: movie_3
Question: Among the movies, what percentage are horror?
Evidence: horror is a name of film category; calculation = DIVIDE(COUNT('horror'), COUNT(category_id)) * 100
SQL: SELECT CAST(SUM(IIF(T2.name = 'horror', 1, 0)) AS REAL) * 100 / COUNT(T2.category_id) FROM film_category AS T1 INNER JOIN category AS T2 ON T1.category_id = T2.category_id

Database: student_loan
Question: Among the students who filed for bankruptcy, how many students are disabled?
SQL: SELECT COUNT(T1.name) FROM disabled AS T1 INNER JOIN filed_for_bankrupcy AS T2 ON T1.name = T2.name

Database: world
Question: What are the districts that belong to the country with the largest surface area?
Evidence: largest surface area refers to MAX(SurfaceArea);
SQL: SELECT T1.District FROM City AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.Code WHERE T2.Name = ( SELECT Name FROM Country ORDER BY SurfaceArea DESC LIMIT 1 )

Database: video_games
Question: Provide the number of games sold in North America on the PS4 platform.
Evidence: number of games sold refers to sum(multiply(num_sales, 100000)); in North America refers to region_name = 'North America'; on the PS4 platform refers to platform_name = 'PS4'
SQL: SELECT SUM(T1.num_sales * 100000) FROM region_sales AS T1 INNER JOIN region AS T2 ON T1.region_id = T2.id INNER JOIN game_platform AS T3 ON T1.game_platform_id = T3.id INNER JOIN platform AS T4 ON T3.platform_id = T4.id WHERE T2.region_name = 'North America' AND T4.platform_name = 'PS4'

Database: software_company
Question: How many customers are from the place with the highest average income per month?
Evidence: place with the highest average income per month refers to GEOID where MAX(INCOME_K);
SQL: SELECT COUNT(T1.ID) FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID ORDER BY T2.INCOME_K DESC LIMIT 1

Database: retail_world
Question: Who is the one representing the company "Heli Swaren GmbH & Co. KG"?
Evidence: Heli Swaren GmbH & Co. KG is the name of the company; who is representing refers to ContactName;
SQL: SELECT ContactName FROM Suppliers WHERE CompanyName = 'Heli Swaren GmbH & Co. KG'

Database: books
Question: How many books under 300 pages has HarperCollins Publishers published?
Evidence: under 300 pages refers to num_pages < 300; 'HarperCollins Publishers" is the publisher_name
SQL: SELECT COUNT(*) FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id WHERE T2.publisher_name = 'HarperCollins Publishers' AND T1.num_pages < 300