Database: movie_3
Question: List movie titles with duration over 120 minutes that are in the action category.
Evidence: duration over 120 minutes refers to length > 120; action category refers to category.name = 'action'
SQL: SELECT T1.title FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T3.category_id = T2.category_id WHERE T3.`name` = 'action' AND T1.length > 120

Database: human_resources
Question: How many emplyees have a good job performance?
Evidence: good job performance refers to performance = 'Good'
SQL: SELECT COUNT(*) FROM employee WHERE performance = 'Good'

Database: bike_share_1
Question: When was the hottest temperature recorded? If there are multiple dates with the hottest temperature, indicate all of the dates.
Evidence: the hottest temperature refers to max_temperature_f;
SQL: SELECT max_temperature_f, date FROM weather WHERE max_temperature_f = ( SELECT MAX(max_temperature_f) FROM weather WHERE max_temperature_f IS NOT NULL AND max_temperature_f IS NOT '' )

Database: legislator
Question: List the official full names of 10 legislators who have a YouTube account but no Instagram account.
Evidence: have a YouTube account but no Instagram account refers to facebook is not null and (instagram is null or instagram = '')
SQL: SELECT T2.official_full_name FROM `social-media` AS T1 INNER JOIN current AS T2 ON T1.bioguide = T2.bioguide_id WHERE T1.facebook IS NOT NULL AND (T1.instagram IS NULL OR T1.instagram = '') LIMIT 10

Database: legislator
Question: What is the total number of senators New Jersey have?
Evidence: senators refers to type = 'rep'; New Jersey refers to state = 'NJ';
SQL: SELECT COUNT(type) FROM `historical-terms` WHERE state = 'NJ' AND type = 'rep'

Database: sales_in_weather
Question: What is the sea level and average speed for store number 3 and store number 4?
Evidence: store number 3 refers to store_nbr = 3; average speed refers to avgspeed; store number 4 refers to store_nbr = 4
SQL: SELECT T1.sealevel, T1.avgspeed FROM weather AS T1 INNER JOIN relation AS T2 ON T1.station_nbr = T2.station_nbr WHERE T2.store_nbr = 3 OR T2.store_nbr = 4

Database: car_retails
Question: How many motorcycles have been ordered in 2004?
Evidence: Motorcycles refer to productLine = 'motorcycles'; ordered in 2004 refers to year(orderDate) = 2004;
SQL: SELECT SUM(t2.quantityOrdered) FROM orders AS t1 INNER JOIN orderdetails AS t2 ON t1.orderNumber = t2.orderNumber INNER JOIN products AS t3 ON t2.productCode = t3.productCode WHERE t3.productLine = 'motorcycles' AND STRFTIME('%Y', t1.orderDate) = '2004'

Database: retail_world
Question: In which year did Around the Horn place the most orders?
Evidence: Around the Horn is the CompanyName; year with the most order refers to Year (OrderDate) where Max(Count(OrderID))
SQL: SELECT STRFTIME('%Y', T2.OrderDate) FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.CompanyName = 'Around the Horn' GROUP BY STRFTIME('%Y', T2.OrderDate) ORDER BY COUNT(T2.OrderID) DESC LIMIT 1

Database: retail_world
Question: Where are the ship countries of orders placed by Janet Leverling?
SQL: SELECT DISTINCT T2.ShipCountry FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T1.FirstName = 'Janet' AND T1.LastName = 'Leverling'

Database: movie_3
Question: What is the percentage of horror film titles in English film titles?
Evidence: horror film refers to category.name = 'Horror'; English film refers to language.name = 'English'; percentage = divide(count(film_id where category.name = 'Horror'), count(film_id)) where language.name = 'English' * 100%
SQL: SELECT CAST(SUM(IIF(T3.name = 'Horror', 1, 0)) AS REAL) * 100 / COUNT(T1.film_id) FROM film_category AS T1 INNER JOIN film AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T1.category_id = T3.category_id INNER JOIN language AS T4 ON T2.language_id = T4.language_id WHERE T4.name = 'English'

Database: shipping
Question: What is the full name of the driver who delivered the most shipments to the least populated city?
Evidence: least populated city refers to Min(population); fullname refers to first_name, last_name; most shipment refers to driver_id where Max(Count (ship_id))
SQL: SELECT T1.first_name, T1.last_name FROM driver AS T1 INNER JOIN shipment AS T2 ON T1.driver_id = T2.driver_id INNER JOIN city AS T3 ON T3.city_id = T2.city_id GROUP BY T1.first_name, T1.last_name, T3.population HAVING T3.population = MAX(T3.population) ORDER BY COUNT(*) DESC LIMIT 1

Database: movie_3
Question: Find and list the full name of customers who rented more family movies than Sci-Fi movies.
Evidence: full name refers to first_name, last_name; 'family' AND 'Sci-Fi' are names of the category; customers who rented more family movies than Sci-Fi movies refers to count(name = 'Family') > count(name = 'Sci-Fi')
SQL: SELECT DISTINCT IIF(SUM(IIF(T5.name = 'Family', 1, 0)) - SUM(IIF(T5.name = 'Sci-Fi', 1, 0)) > 0, T1.first_name, 0) FROM customer AS T1 INNER JOIN rental AS T2 ON T1.customer_id = T2.customer_id INNER JOIN inventory AS T3 ON T2.inventory_id = T3.inventory_id INNER JOIN film_category AS T4 ON T4.film_id = T3.film_id INNER JOIN category AS T5 ON T4.category_id = T5.category_id GROUP BY T1.customer_id

Database: university
Question: What is the criteria name of the university ID 32 in 2015?
Evidence: in 2015 refers to year = 2015
SQL: SELECT T1.criteria_name FROM ranking_criteria AS T1 INNER JOIN university_ranking_year AS T2 ON T1.id = T2.ranking_criteria_id WHERE T2.university_id = 32 AND T2.year = 2015

Database: shipping
Question: To whom did the company transport its heaviest shipment?
Evidence: heaviest shipment refers to Max(weight)
SQL: SELECT T2.cust_name FROM shipment AS T1 INNER JOIN customer AS T2 ON T1.cust_id = T2.cust_id ORDER BY T1.weight DESC LIMIT 1

Database: synthea
Question: Among the male patients, list down 5 birth dates of patients taking the medication "Penicillin V Potassium 250 MG".
Evidence: male patients refers to gender = 'M'; Penicillin V Potassium 250 MG refers to medications.DESCRIPTION = 'Penicillin V Potassium 250 MG';
SQL: SELECT DISTINCT T2.birthdate FROM medications AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T1.DESCRIPTION = 'Penicillin V Potassium 250 MG' AND T2.gender = 'M' LIMIT 5

Database: sales_in_weather
Question: Which weather station does store no.20 belong to?
Evidence: store no.20 refers to store_nbr = 20; weather station refers to station_nbr
SQL: SELECT station_nbr FROM relation WHERE store_nbr = 20

Database: address
Question: What is the area code of the city with the largest land area?
Evidence: largest land area refers to Max(land_area)
SQL: SELECT T1.area_code FROM area_code AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.land_area = ( SELECT MAX(land_area) FROM zip_data )

Database: synthea
Question: How many stroke patients have married?
Evidence: stroke refers to conditions where DESCRIPTION = 'Stroke'; married refers to the marital status of the patient in which marital = 'M';
SQL: SELECT COUNT(DISTINCT T1.patient) FROM patients AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Stroke' AND T1.marital = 'M'

Database: movie_platform
Question: Please provide the title of the list with the most comments on the list.
Evidence: the most comments refers to Max(list_comments);
SQL: SELECT list_title FROM lists GROUP BY list_title ORDER BY COUNT(list_comments) DESC LIMIT 1

Database: ice_hockey_draft
Question: Who among the players in season 2000-2001 has committed the highest rule violations or penalty minutes?
Evidence: committed the highest rule violations or penalty minutes refers to MAX(PIM); 2000-2001 season refers to SEASON = '2000-2001'
SQL: SELECT T2.PlayerName FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.SEASON = '2000-2001' ORDER BY T1.PIM DESC LIMIT 1