Database: chicago_crime
Question: Please list the case numbers of all the crimes whose short description of the kind of crime is "Homicide 1st & 2nd Degree" in the FBI classification.
Evidence: "Homicide 1st & 2nd Degree" is the title
SQL: SELECT T2.case_number FROM FBI_Code AS T1 INNER JOIN Crime AS T2 ON T1.fbi_code_no = T2.fbi_code_no WHERE T1.title = 'Homicide 1st & 2nd Degree'

Database: chicago_crime
Question: Please list any three criminal sexual assault cases against persons where the criminals have been arrested.
Evidence: "Criminal Sexual Assault" is the title of crime; against person refers to crime_against = 'Persons'; criminals have been arrested refers to arrest = 'TRUE'; cases refers to case_number
SQL: SELECT T2.case_number FROM FBI_Code AS T1 INNER JOIN Crime AS T2 ON T1.fbi_code_no = T2.fbi_code_no WHERE T1.title = 'Criminal Sexual Assault' AND T2.arrest = 'TRUE' AND T1.crime_against = 'Persons' LIMIT 3

Database: video_games
Question: List the platforms that release the most games each year.
Evidence: platform refers to platform_id; the most games refers to max(count(game_publisher_id))
SQL: SELECT T1.platform_name 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 GROUP BY T2.release_year, T1.platform_name ORDER BY COUNT(DISTINCT T3.game_id) DESC

Database: student_loan
Question: Find the percentage of male students enlisted in the fire department.
Evidence: percentage refers to DIVIDE(COUNT(organ = 'fire_department'), COUNT(name))
SQL: SELECT CAST(COUNT(T2.name) AS REAL) * 100 / COUNT(T1.name) FROM enlist AS T1 LEFT JOIN male AS T2 ON T1.name = T2.name WHERE T1.organ = 'fire_department'

Database: world_development_indicators
Question: In which country's latest trade data and latest water withdrawal data were both updated in the year 2013? Give its long name and Alpha 2 code.
SQL: SELECT LongName, Alpha2Code FROM Country WHERE LatestTradeData = 2013 AND LatestWaterWithdrawalData = 2013

Database: movie_3
Question: Determine the number of action movies available for rent.
Evidence: action movie refers to category.name = 'Action'
SQL: SELECT COUNT(T2.film_id) FROM category AS T1 INNER JOIN film_category AS T2 ON T1.category_id = T2.category_id WHERE T1.name = 'Action'

Database: car_retails
Question: What is the amount of customers of 1957 Chevy Pickup by customers in a month?
SQL: SELECT COUNT(T2.customerNumber) FROM orderdetails AS T1 INNER JOIN orders AS T2 ON T1.orderNumber = T2.orderNumber WHERE T1.productCode IN ( SELECT productCode FROM products WHERE productName = '1957 Chevy Pickup' )

Database: restaurant
Question: How many American restaurants are located in Front, San Francisco?
Evidence: American restaurant refers to food_type = 'american'; Front refers to street_name = 'front'; San Francisco refers to city = 'san francisco'
SQL: SELECT COUNT(T2.food_type = 'american') FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T1.city = 'san francisco' AND T1.street_name = 'front'

Database: movie_platform
Question: What is the URL to the movie director page on Mubi of the movie titled "Red Blooded American Girl"
Evidence: movie titled "Red Blooded American Girl" refers to movie_title = 'Red Blooded American Girl'
SQL: SELECT director_url FROM movies WHERE movie_title LIKE 'Red Blooded American Girl'

Database: student_loan
Question: Calculate the ratio of unemployed students who have never been absent from school.
Evidence: ratio = CONCAT(DIVIDE(MULTIPLY(COUNT(unemployed.name WHERE month = 0), 100), COUNT(month)),'%'); unemployed students who have never been absent from school refers to (unemployed.name WHERE month = 0);
SQL: SELECT CAST(SUM(IIF(T2.month = 0, 1, 0)) AS REAL) * 100 / COUNT(T1.name) FROM unemployed AS T1 INNER JOIN longest_absense_from_school AS T2 ON T2.name = T1.name

Database: public_review_platform
Question: List out 10 business ID that are being reviewed the most by users and list out what are top 3 business categories.
Evidence: being reviewed the most refers to MAX(user_id); business categories refer to category_name;
SQL: SELECT T2.business_id, T3.category_name FROM Reviews AS T1 INNER JOIN Business_categories AS T2 ON T1.business_id = T2.business_id INNER JOIN Categories AS T3 ON T2.category_id = T3.category_id GROUP BY T2.business_id ORDER BY COUNT(T1.user_id) DESC LIMIT 10

Database: olympics
Question: What is the percentage of male athletes from Estonia?
Evidence: DIVIDE(COUNT(id where gender = 'M'), COUNT(id)) as percentage where region_name = 'Estonia';
SQL: SELECT CAST(COUNT(CASE WHEN T3.gender = 'M' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.person_id) FROM noc_region AS T1 INNER JOIN person_region AS T2 ON T1.id = T2.region_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T1.region_name = 'Estonia'

Database: regional_sales
Question: Find the average number of ornaments sold each month in 2018.
Evidence: DIVIDE(SUM(Order Quantity where Product Name = 'Ornaments' and OrderDate LIKE '%/18'), 12);
SQL: SELECT CAST(SUM(T2.`Order Quantity`) AS REAL) / 12 FROM Products AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._ProductID = T1.ProductID WHERE T1.`Product Name` = 'Ornaments' AND T2.OrderDate LIKE '%/%/18'

Database: computer_student
Question: How many professors teaches basic or medium undergraduate courses?
Evidence: professors refers to taughtBy.p_id; basic or medium undergraduate courses refers to couresLevel = 'Level_300'
SQL: SELECT COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel = 'Level_300'

Database: book_publishing_company
Question: Which job level is O'Rourke at?
Evidence: job level refers to job_lvl
SQL: SELECT job_lvl FROM employee WHERE lname = 'O''Rourke'

Database: retail_world
Question: For the order paying the highest freight, how many kinds of products does it contain?
Evidence: highest freight refers to MAX(Freight); kinds of products refers to ProductID;
SQL: SELECT COUNT(T2.ProductID) FROM Orders AS T1 INNER JOIN `Order Details` AS T2 ON T1.OrderID = T2.OrderID WHERE T1.Freight = ( SELECT MAX(Freight) FROM Orders ) GROUP BY T1.OrderID

Database: software_company
Question: List the income and number of inhabitants of customers with a reference ID greater than the 50% of average of number of false response?
Evidence: reference ID greater than the 50% of average of number of false response refers to REFID > DIVIDE(MULTIPLY(0.5, COUNT(RESPONSE = 'false')), COUNT(RESPONSE)); income refers to INCOME_K; number of inhabitants refer to INHABITANTS_K;
SQL: SELECT T2.INCOME_K, T2.INHABITANTS_K FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID INNER JOIN Mailings1_2 AS T3 ON T1.ID = T3.REFID WHERE T3.REFID > ( SELECT 0.5 * COUNT(CASE WHEN RESPONSE = 'false' THEN 1 ELSE NULL END) / COUNT(RESPONSE) FROM Mailings1_2 )

Database: disney
Question: Give the name of the movie which the song "I Thought I Lost You" is associated with.
Evidence: name of the movie refers to movie_title;
SQL: SELECT movie_title FROM characters WHERE song = 'I Thought I Lost You'