Database: movie_3
Question: How many rentals did Ella Oliver hire in June 2016?
Evidence: 'Ella Oliver' is a full name of a customer; full name refers to first_name, last_name; rental hired in June 2016 refers to rental_date BETWEEN '2005-06-01' AND '2005-06-30'
SQL: SELECT COUNT(T1.rental_id) FROM rental AS T1 INNER JOIN customer AS T2 ON T1.customer_id = T2.customer_id WHERE T2.first_name = 'ELLA' AND T2.last_name = 'ELLA' AND date(T1.rental_date) BETWEEN '2005-06-01' AND '2005-06-30'

Database: chicago_crime
Question: Who is the alderman in the ward associated with the crime with report number 23769?
Evidence: alderman refers to alderman_suffix, alderman_first_name, alderman_last_name; report number 23769 refers to report_no = 23769
SQL: SELECT T2.alderman_first_name, T2.alderman_last_name FROM Crime AS T1 INNER JOIN Ward AS T2 ON T2.ward_no = T1.ward_no WHERE T1.report_no = 23769

Database: ice_hockey_draft
Question: Calculate the average height in centimeter of all players who played in Acadie-Bathurst Titan during regular season.
Evidence: average height in centimeter = AVG(height_in_cm); height in centimeter refers to height_in_cm; players refers to PlayerName; Acadie-Bathurst Titan refers to TEAM = 'Acadie-Bathurst Titan'; regular season refers to GAMETYPE = 'Regular Season';
SQL: SELECT CAST(SUM(T1.height_in_cm) AS REAL) / COUNT(T2.ELITEID) FROM height_info AS T1 INNER JOIN PlayerInfo AS T2 ON T1.height_id = T2.height INNER JOIN SeasonStatus AS T3 ON T2.ELITEID = T3.ELITEID WHERE T3.TEAM = 'Acadie-Bathurst Titan' AND T3.GAMETYPE = 'Regular Season'

Database: menu
Question: How many pages are there in the "Emil Kuehn" menu?
Evidence: Emil Kuehn is a name of menu;
SQL: SELECT SUM(CASE WHEN T1.name = 'Emil Kuehn' THEN 1 ELSE 0 END) FROM Menu AS T1 INNER JOIN MenuPage AS T2 ON T1.id = T2.menu_id

Database: simpson_episodes
Question: Write down the website address which stores the episode image of episode 5.
Evidence: website address refers to episode_image
SQL: SELECT episode_image FROM Episode WHERE episode = 5;

Database: talkingdata
Question: Describe the phone brands and models of the users who participated in events on 5th May, 2016 at the coordinates of (112,44).
Evidence: models refers to device_model; on 5th May, 2016 refers to timestamp LIKE '2016-05-05%'; coordinates of (112,44) refers to longitude = 112 AND latitude = 44;
SQL: SELECT DISTINCT T2.phone_brand, T2.device_model FROM events AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T2.device_id = T1.device_id WHERE T1.timestamp LIKE '2016-05-05%' AND T1.longitude = 112 AND T1.latitude = 44

Database: professional_basketball
Question: How many players whose teams were ranked 6 in 1937?
Evidence: ranked 6 refers to rank = 6; in 1937 refers to year = 1937
SQL: SELECT COUNT(DISTINCT T1.playerID) FROM players AS T1 INNER JOIN players_teams AS T2 ON T1.playerID = T2.playerID INNER JOIN teams AS T3 ON T3.tmID = T2.tmID WHERE T3.year = 1937 AND T3.rank = 6

Database: car_retails
Question: What are the total payments of customers with no credit limit in 2003?
Evidence: total payment refers to SUM(amount); no credit limit refers to creditLimit = 0; year(paymentDate) = '2003';
SQL: SELECT SUM(amount) FROM payments WHERE STRFTIME('%Y', paymentDate) = '2003' AND customerNumber IN ( SELECT customerNumber FROM customers WHERE creditLimit = 0 )

Database: shooting
Question: How many incidents in which the subject's weapon was a vehicle were investigated by a female officer?
Evidence: subject's weapon was a vehicle refers to subject_weapon = 'Vehicle'; female refers to gender = 'F'
SQL: SELECT COUNT(T1.case_number) FROM incidents AS T1 INNER JOIN officers AS T2 ON T1.case_number = T2.case_number WHERE T1.subject_weapon = 'Vehicle' AND T2.gender = 'F'

Database: university
Question: Among the universities in Australia, how many of them have more than 15000 students in 2011?
Evidence: in 2011 refers to year 2011; have more than 15000 students refers to num_students > 15000; in Australia refers to country_name = 'Australia';
SQL: SELECT COUNT(*) FROM university AS T1 INNER JOIN university_year AS T2 ON T1.id = T2.university_id INNER JOIN country AS T3 ON T3.id = T1.country_id WHERE T3.country_name = 'Australia' AND T2.year = 2011 AND T2.num_students > 15000

Database: airline
Question: Please list any three airports with their codes.
SQL: SELECT Code, Description FROM Airports LIMIT 3

Database: chicago_crime
Question: Give the name of the community area which had the most pocket-picking thefts.
Evidence: name of the community area refers to community_area_name; the most refers to max(case_number); pocket-picking theft refers to primary_description = 'THEFT' AND secondary_description = 'POCKET-PICKING'
SQL: SELECT T3.community_area_name FROM IUCR AS T1 INNER JOIN Crime AS T2 ON T1.iucr_no = T2.iucr_no INNER JOIN Community_Area AS T3 ON T2.community_area_no = T3.community_area_no WHERE T1.primary_description = 'THEFT' AND T1.secondary_description = 'POCKET-PICKING' GROUP BY T2.community_area_no ORDER BY T2.case_number DESC LIMIT 1

Database: retail_complains
Question: List all the server of the phone complaints with a late response from the company.
Evidence: phone complaint refers to Submitted via = 'Phone'; late response refers to Timely response? = 'No'
SQL: SELECT DISTINCT T2.server FROM events AS T1 INNER JOIN callcenterlogs AS T2 ON T1.`Complaint ID` = T2.`Complaint ID` WHERE T1.`Submitted via` = 'Phone' AND T1.`Timely response?` = 'No'

Database: shipping
Question: What is the most populated city in California?
Evidence: in California refers to state = 'CA'; most populated city refers to Max(population)
SQL: SELECT city_name FROM city WHERE state = 'California' AND population = ( SELECT MAX(population) FROM city WHERE state = 'California' )

Database: sales_in_weather
Question: How many stations were able to sell item 5 on January 2014?
Evidence: item 5 refers to item_nbr = 5; on January 2014 refers to Substring (date, 1, 7) = '2014-01'
SQL: SELECT COUNT(DISTINCT T2.station_nbr) AS number FROM sales_in_weather AS T1 INNER JOIN relation AS T2 ON T1.store_nbr = T2.store_nbr WHERE SUBSTR(`date`, 1, 7) = '2014-01' AND item_nbr = 5

Database: superstore
Question: Indicate the profit of product Sauder Camden County Barrister Bookcase, Planked Cherry Finish.
Evidence: Sauder Camden County Barrister Bookcase, Planked Cherry Finish' refers to "Product Name"
SQL: SELECT DISTINCT T1.Profit FROM south_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.`Product Name` = 'Sauder Camden County Barrister Bookcase, Planked Cherry Finish'

Database: shipping
Question: How many shipments were shipped to the most densely populated city?
Evidence: most densely populated city refers to Max(Divide(area, population))
SQL: SELECT COUNT(*) FROM shipment AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id ORDER BY T2.area / T2.population DESC LIMIT 1

Database: public_review_platform
Question: List down the business ID and attribute value of the attribute name of "payment_types_visa".
SQL: SELECT T2.business_id, T2.attribute_value FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T1.attribute_name = 'payment_types_visa'

Database: college_completion
Question: State the name and website of the institutes from the state with 209 graduate cohort in 2011.
Evidence: name of the institutes refers to chronname; website refers to site; graduate cohort refers to grad_cohort; in 2011 refers to year = '2011';
SQL: SELECT T1.chronname, T1.site FROM institution_details AS T1 INNER JOIN state_sector_grads AS T2 ON T1.state = T2.state WHERE T2.year = 2011 AND T2.grad_cohort = 209

Database: airline
Question: What is the code of Mississippi Valley Airlines?
Evidence: Mississippi Valley Airlines refers to Description like 'Mississippi Valley Airlines%';
SQL: SELECT Code FROM `Air Carriers` WHERE Description LIKE 'Mississippi Valley Airlines%'