Database: cars
Question: Which car in the database provides the best crash protection based on its weight? How much is it?
Evidence: the best crash protection refers to max(weight); cost refers to price
SQL: SELECT T1.ID, T2.price FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID ORDER BY T1.weight DESC LIMIT 1

Database: superstore
Question: How many customers in Chicago ordered at least 10 Cardinal EasyOpen D-Ring Binders in a single order?
Evidence: at least 10 goods refers to Quantity > = 14; Cardinal EasyOpen D-Ring Binders refers to "Product Name"; customers in Chicago refers to City = 'Chicago'
SQL: SELECT COUNT(DISTINCT T1.`Customer ID`) FROM west_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T1.`Product ID` WHERE T3.`Product Name` = 'Cardinal EasyOpen D-Ring Binders' AND T2.City = 'Chicago' AND T1.Quantity > 10

Database: movie_3
Question: Which actor acted in ANONYMOUS HUMAN?
Evidence: actor refers to first_name, last_name; ANONYMOUS HUMAN refers to title = 'ANONYMOUS HUMAN'
SQL: SELECT T1.first_name, T1.last_name FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T3.film_id = T2.film_id WHERE T3.title = 'ANONYMOUS HUMAN'

Database: retail_world
Question: What is the company name of the customer who made the biggest amount of purchase in a single order before discount?
Evidence: biggest amount of purchase in a single order refers to MAX(MULTIPLY(UnitPrice, Quantity)); before discount refers to Discount = 0
SQL: SELECT T1.CompanyName FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN `Order Details` AS T3 ON T2.OrderID = T3.OrderID WHERE T3.Discount = 0 GROUP BY T1.CompanyName ORDER BY SUM(T3.UnitPrice * T3.Quantity) DESC LIMIT 1

Database: chicago_crime
Question: Calculate the average population of community areas in the West side.
Evidence: the West side refers to side = 'West'; average population = avg(population) where side = 'West'
SQL: SELECT AVG(population) FROM Community_Area WHERE side = 'West '

Database: cs_semester
Question: How many professors are more popular than Zhou Zhihua?
Evidence: higher popularity means the professor is more popular;
SQL: SELECT COUNT(prof_id) FROM prof WHERE popularity > ( SELECT popularity FROM prof WHERE first_name = 'Zhihua' AND last_name = 'Zhou' )

Database: menu
Question: Name the dishes that cost 180,000.
Evidence: cost 180,000 refers to price = 180000;
SQL: SELECT T1.name FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id WHERE T2.price = 180000

Database: sales
Question: Among all the customers who have purchased ML Bottom Bracket, identify the percentage of sales by Albert I. Ringer?
Evidence: ML Bottom Bracket' is name of product; percentage = MULTIPLY(DIVIDE(SUM(CustomerID WHERE FirstName = 'Albert' AND MiddleInitial = 'I' AND LastName = 'Ringer'), COUNT(CustomerID)), 1.0);
SQL: SELECT CAST(SUM(IIF(T3.FirstName = 'Albert' AND T3.MiddleInitial = 'I' AND T3.LastName = 'Ringer', 1, 0)) AS REAL) * 100 / COUNT(T2.CustomerID) FROM Products AS T1 INNER JOIN Sales AS T2 ON T1.ProductID = T2.ProductID INNER JOIN Employees AS T3 ON T2.SalesPersonID = T3.EmployeeID WHERE T1.Name = 'ML Bottom Bracket'

Database: movie_platform
Question: Which movie got the most critic comments? Give the name of the movie.
Evidence: name of the movie refers to movie_title; most critic comments refers to MAX(critic_comments)
SQL: SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id GROUP BY T2.movie_title ORDER BY COUNT(T1.critic_comments) DESC LIMIT 1

Database: synthea
Question: Why did Elly Koss need to take Acetaminophen?
Evidence: why need to take Acetaminophen refers to REASONDESCRIPTION  where DESCRIPTION like 'Acetaminophen%' from medications;
SQL: SELECT T2.REASONDESCRIPTION FROM patients AS T1 INNER JOIN medications AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Elly' AND T1.last = 'Koss' AND T2.description LIKE 'Acetaminophen%'

Database: language_corpus
Question: What is the locale of the language of the page titled "Asclepi"?
Evidence: page titled "Asclepi" refers to title = 'Asclepi' ;
SQL: SELECT T2.locale FROM pages AS T1 INNER JOIN langs AS T2 ON T1.lid = T2.lid WHERE T1.title = 'Asclepi'

Database: shipping
Question: How many customers are manufacturer?
Evidence: "manufacturer" is the cust_type
SQL: SELECT COUNT(*) FROM customer WHERE cust_type = 'manufacturer'

Database: retail_world
Question: What product is the least shipped to the postal code 28023?
Evidence: the least shipped product refers ProductName where MIN(Quantity);
SQL: SELECT T4.ProductName FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN `Order Details` AS T3 ON T2.OrderID = T3.OrderID INNER JOIN Products AS T4 ON T3.ProductID = T4.ProductID WHERE T1.PostalCode = 28023 ORDER BY T3.Quantity LIMIT 1

Database: synthea
Question: How many of the patients who underwent a 'bone immobilization' procedure have a driver's license?
Evidence: patients who underwent a 'bone immobilization' procedure refer to PATIENT from procedures where DESCRIPTION = 'Bone immobilization'; have a driver's license refers to drivers is not null;
SQL: SELECT COUNT(DISTINCT T1.patient) FROM patients AS T1 INNER JOIN procedures AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Bone immobilization' AND T1.drivers IS NOT NULL

Database: university
Question: Name the most famous university in Argentina.
Evidence: in Argentina refers to country_name = 'Argentina';  most famous refers to MAX(SUM(score))
SQL: SELECT T1.university_name FROM university AS T1 INNER JOIN university_ranking_year AS T2 ON T1.id = T2.university_id INNER JOIN country AS T3 ON T3.id = T1.country_id WHERE T3.country_name = 'Argentina' GROUP BY T1.university_name ORDER BY SUM(T2.score) DESC LIMIT 1

Database: olympics
Question: Please list all game names that were held in Los Angeles.
Evidence: Los Angeles refers to city_name = 'Los Angeles';
SQL: SELECT T3.games_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 T2.city_name = 'Los Angeles'

Database: bike_share_1
Question: How many stations in San Francico can hold more than 20 bikes?
Evidence: San Francico is the name of the city; can hold more than 20 bikes implies dock's capacity and refers to dock_count≥20;
SQL: SELECT SUM(CASE WHEN city = 'San Francisco' AND dock_count > 20 THEN 1 ELSE 0 END) FROM station

Database: retail_complains
Question: Did Ms. Lyric Emely Taylor provide the consent for result of the complaint call on 2016/5/20?
Evidence: Ms refers to sex = 'Female'; "Consumer consent provided?" in (null, 'N/A', 'Empty') means that the company didn't get the permission of consent; "Consumer consent provided?" not in (null, 'N/A', 'Empty') means the customers provide the consent; on 2016/5/20 refers to Date received = '2016-05-20';
SQL: SELECT CASE WHEN T2.`Consumer consent provided?` IN (NULL, 'N/A', '') THEN 'No' ELSE 'Yes' END FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T1.first = 'Lyric' AND T1.middle = 'Emely' AND T1.last = 'Taylor' AND T1.sex = 'Female' AND T2.`Date received` = '2016-05-20'

Database: olympics
Question: What is the game name that was held in Beijing in 2008?
Evidence: Beijing refers to city_name = 'Beijing'; in 2008 refers to games_year = '2008';
SQL: SELECT T3.games_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 T2.city_name = 'Beijing' AND T3.games_year = 2008