Database: retail_world
Question: How many sales values have been created by sales representative and which sales representative have the highest sales?
Evidence: sales representative refers to Title = 'Sales Representative'; sales values refers to MULTIPLY(Quantity, UnitPrice); the highest sales refers to max(MULTIPLY(Quantity, UnitPrice))
SQL: SELECT SUM(T3.UnitPrice * T3.Quantity) FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID INNER JOIN `Order Details` AS T3 ON T2.OrderID = T3.OrderID WHERE T1.Title = 'Sales Representative' ORDER BY SUM(T3.UnitPrice * T3.Quantity)

Database: menu
Question: State the name of menu with the longest full height.
Evidence: longest full height refers to MAX(full_height);
SQL: SELECT T2.name FROM MenuPage AS T1 INNER JOIN Menu AS T2 ON T2.id = T1.menu_id ORDER BY T1.full_height DESC LIMIT 1

Database: retail_world
Question: Sir Rodney's Marmalade is supplied by which company and who is the contact for this company?
Evidence: 'Sir Rodney's Marmalade' is a ProductName; company refers to CompanyName; contact for a company refers to ContactName
SQL: SELECT T2.CompanyName, T2.ContactName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.ProductName LIKE 'Sir Rodney%s Marmalade'

Database: image_and_language
Question: Provide the number of predicted classes.
Evidence: predicted classes refers to PRED_CLASS
SQL: SELECT COUNT(PRED_CLASS_ID) FROM PRED_CLASSES

Database: shipping
Question: List the ship ID of shipments shipped to the most populated city.
Evidence: most populated city refers to Max(population)
SQL: SELECT T1.ship_id FROM shipment AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id ORDER BY T2.population DESC LIMIT 1

Database: public_review_platform
Question: List the categories of active businesses in Surprise, AZ.
Evidence: categories refers to category_name; active businesses refers to active = 'true'; in Surprise, AZ refers to city = 'Surprise' and state = 'AZ'
SQL: SELECT T3.category_name FROM Business AS T1 INNER JOIN Business_Categories ON T1.business_id = Business_Categories.business_id INNER JOIN Categories AS T3 ON Business_Categories.category_id = T3.category_id WHERE T1.active LIKE 'TRUE' AND T1.state LIKE 'AZ' AND T1.city LIKE 'Surprise' GROUP BY T3.category_name

Database: law_episode
Question: Who is the youngest person to ever play a "clerk" role in the series?
Evidence: who refers to name; the youngest person refers to max(birthdate); a "clerk" role refers to role = 'Clerk'
SQL: SELECT T2.name FROM Credit AS T1 INNER JOIN Person AS T2 ON T2.person_id = T1.person_id WHERE T1.role = 'Clerk' AND T2.birthdate IS NOT NULL ORDER BY T2.birthdate LIMIT 1

Database: student_loan
Question: How many SMC's students that absent for 7 months?
Evidence: SMC's students refers to school = 'smc'; absent for 7 months refers to month = 7
SQL: SELECT COUNT(T1.name) FROM enrolled AS T1 INNER JOIN longest_absense_from_school AS T2 ON T1.name = T2.name WHERE T1.school = 'smc' AND T2.month = 7

Database: menu
Question: Among the menus that include baked apples with cream, who is the sponsor of the menu with the highest price?
Evidence: baked apples with cream is a name of dish; highest price refers to MAX(price);
SQL: SELECT T4.sponsor FROM MenuPage AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.menu_page_id INNER JOIN Dish AS T3 ON T2.dish_id = T3.id INNER JOIN Menu AS T4 ON T4.id = T1.menu_id WHERE T3.name = 'Baked apples with cream' AND T3.id = 107 ORDER BY T2.price DESC LIMIT 1

Database: menu
Question: What is the position coordinate on the page menu of the "Small Hominy" dish and how long did it appear?
Evidence: position coordinate = xpos, ypos; Small Hominy is a name of dish; how long it appear = SUBTRACT(last_appeared, first_appeared);
SQL: SELECT T2.xpos, T2.ypos, T1.last_appeared - T1.first_appeared FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id WHERE T1.name = 'Small Hominy'

Database: food_inspection_2
Question: How many inspections with critical food safety problems are under inspection point id 3?
Evidence: critical food safety problems refers to fine = 500; point_id = 3
SQL: SELECT COUNT(inspection_id) FROM violation WHERE point_id = 3 AND fine = 500

Database: retail_world
Question: Which company has the lowest unit price? Please give the company name and the product name.
Evidence: lowest unit price refers to Min(UnitPrice)
SQL: SELECT T2.CompanyName, T1.ProductName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.UnitPrice = ( SELECT MIN(UnitPrice) FROM Products )

Database: public_review_platform
Question: How long does business number 12 in Scottsdale stay open on day number 3?
Evidence: business number refers to business_id; Scottsdale refers to city = 'Scottsdale'; day number refers to day_id;
SQL: SELECT T2.closing_time - T2.opening_time AS "hour" FROM Business AS T1 INNER JOIN Business_Hours AS T2 ON T1.business_id = T2.business_id WHERE T1.business_id = 12 AND T1.city LIKE 'Scottsdale' AND T2.day_id = 3

Database: world_development_indicators
Question: What percentage of countries in South Asia have the Life expectancy at birth, female (years) greater than 50?
Evidence: South Asia is the name of the region; IndicatorName = 'Life expectancy at birth, female (years)'; greater than 50 refers to Value>50; DIVIDE(COUNT(CountryCode where IndicatorName = 'Life expectancy at birth, female (years)'; Value>50; Region = 'South Asia'), COUNT(CountryCode where Region = 'South Asia')) as percentage;
SQL: SELECT CAST(SUM(CASE WHEN T2.value > 50 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.CountryCode) FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.Region = 'South Asia' AND T2.IndicatorName = 'Life expectancy at birth, female (years)'

Database: movie_platform
Question: For the list with more than 200 followers, state the title and how long the list has been created?
Evidence: more than 200 followers refers to list_followers >200; how long the list has been created refers to SUBTRACT(CURRENT_TIMESTAMP,list_creation_timestamp_utc)
SQL: SELECT list_title , 365 * (strftime('%Y', 'now') - strftime('%Y', list_creation_timestamp_utc)) + 30 * (strftime('%m', 'now') - strftime('%m', list_creation_timestamp_utc)) + strftime('%d', 'now') - strftime('%d', list_creation_timestamp_utc) FROM lists WHERE list_followers > 200

Database: movie_platform
Question: How many movies directed by Francis Ford Coppola have a popularity of more than 1,000? Indicate what is the highest amount of likes that each critic per movie has received, if there's any.
Evidence: Francis Ford Coppola refers to director_name; popularity of more than 1,000 refers to movie_popularity >1000;highest amount of likes that each critic per movie has received refers to MAX(critic_likes)
SQL: SELECT COUNT(T2.movie_title), T1.critic FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.director_name = 'Francis Ford Coppola' AND T2.movie_popularity > 1000

Database: olympics
Question: Please list the names of all the Olympic games that John Aalberg has taken part in.
Evidence: name of the Olympic games refers to games_name;
SQL: SELECT T1.games_name FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T3.full_name = 'John Aalberg'

Database: shakespeare
Question: Give the character's ID of the character that said the paragraph "O my poor brother! and so perchance may he be."
Evidence: "O my poor brother! and so perchance may he be." refers to  PlainText = 'O my poor brother! and so perchance may he be.'
SQL: SELECT character_id FROM paragraphs WHERE PlainText = 'O my poor brother! and so perchance may he be.'