Database: codebase_comments
Question: Show the full Comment of the method "DE2_UE_Fahrradkurier.de2_uebung_fahrradkurierDataSet1TableAdapters.TableAdapterManager.UpdateInsertedRows".
SQL: SELECT FullComment FROM Method WHERE Name = 'DE2_UE_Fahrradkurier.de2_uebung_fahrradkurierDataSet1TableAdapters.TableAdapterManager.UpdateInsertedRows'

Database: world_development_indicators
Question: Which countries in the upper middle income category still have unfinished external debt reporting? Please provide the country codes in your answer.
Evidence: in the upper middle income category refers to incomegroup = 'Upper middle income'; still have unfinished external debt reporting refers to ExternalDebtReportingStatus = 'Preliminary'
SQL: SELECT CountryCode FROM Country WHERE IncomeGroup = 'Upper middle income' AND ExternalDebtReportingStatus = 'Preliminary'

Database: cs_semester
Question: Among courses with difficulty of 3, how many students have intellegence level of 2?
Evidence: difficulty of 3 refers to diff = 3; intelligence = 2
SQL: SELECT COUNT(T1.student_id) FROM student AS T1 INNER JOIN registration AS T2 ON T1.student_id = T2.student_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.diff = 3 AND T1.intelligence = 2

Database: superstore
Question: How much is the total quantity of items from the East region shipped on 3/25/2015? Name the products.
Evidence: shipped on 3/25/2015 refers to "Ship Date" = Date('2015-03-25');
SQL: SELECT SUM(T1.Quantity), T2.`Product Name` FROM east_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T1.`Ship Date` = '2015-03-25' AND T2.Region = 'East'

Database: image_and_language
Question: State the width and height of the object with the class of 'van' in image 1.
Evidence: The bounding box's W and H abbreviations stand for the object's width and height respectively; class of 'van' in image 1 refers to OBJ_CLASS = 'van' where IMG_ID = 1;
SQL: SELECT T1.H, T1.W FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T1.IMG_ID = 1 AND T2.OBJ_CLASS = 'van'

Database: address
Question: Give the area code of the city with the white population ranging between 1700 to 2000.
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.white_population BETWEEN 1700 AND 2000

Database: retail_world
Question: What product have the highest unit price and how many quantity have been being sold?
Evidence: product refers to ProductID; highest unit price refers to Max(UnitPrice)
SQL: SELECT T1.ProductName, T2.Quantity FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID ORDER BY T1.UnitPrice DESC LIMIT 1

Database: retail_complains
Question: How many complaints have the client Diesel Galloway filed?
SQL: SELECT COUNT(T1.client_id) FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T1.first = 'Diesel' AND T1.last = 'Galloway'

Database: legislator
Question: Provide the full name and birth date of the legislator with a contact form of http://www.brown.senate.gov/contact/.
Evidence: full name refers to official_full_name; birth date refers to birthday_bio;
SQL: SELECT T1.official_full_name, T1.birthday_bio FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.contact_form = 'http://www.brown.senate.gov/contact/'

Database: music_tracker
Question: What are the top 5 tags with the highest amount of downloads?
Evidence: the highest amount of downloads refers to MAX(totalSnatched);
SQL: SELECT T2.tag FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T1.releaseType = 'album' ORDER BY T1.totalSnatched DESC LIMIT 5

Database: car_retails
Question: Which sales representatives in New York city whose leader is Anthony Bow with the employee number is 1143? Indicate their employee numbers.
Evidence: reportsTO' is the leader of the 'employeeNumber';
SQL: SELECT T1.employeeNumber FROM employees AS T1 INNER JOIN offices AS T2 ON T1.officeCode = T2.officeCode WHERE T1.reportsTo = 1143 AND T2.city = 'NYC'

Database: beer_factory
Question: Give me the full name of the first customer, and tell me how long ago he or she wrote his or her first review since making his or her first purchase.
Evidence: full name = First, Last; how long ago = SUBTRACT(ReviewDate, FirstPurchaseDate);
SQL: SELECT T1.First, T1.Last , strftime('%J', ReviewDate) - strftime('%J', FirstPurchaseDate) AS TIMEAGO FROM customers AS T1 INNER JOIN rootbeerreview AS T2 ON T1.CustomerID = T2.CustomerID LIMIT 1

Database: coinmarketcap
Question: List the names of the top five coins traded on January 1, 2014.
Evidence: the top five coins refers to cmc_rank< = 5; on January 1, 2014 refers to date = '2014-01-01'
SQL: SELECT T1.name FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T2.date = '2014-01-01' AND T2.cmc_rank <= 5

Database: chicago_crime
Question: Please list any three community areas with a population of more than 50,000.
Evidence: population of more than 50000 refers to Population > 50000; community area refers to community_area_name
SQL: SELECT community_area_name FROM Community_Area WHERE population > 50000 LIMIT 3

Database: social_media
Question: Users in which city of Argentina post the most tweets?
Evidence: "Argentina" is the Country; post the most tweets refers to Max(Count(TweetID))
SQL: SELECT T2.City FROM twitter AS T1 INNER JOIN location AS T2 ON T2.LocationID = T1.LocationID WHERE T2.Country = 'Argentina' GROUP BY T2.City ORDER BY COUNT(T1.TweetID) DESC LIMIT 1

Database: olympics
Question: What is the name of the oldest competitor?
Evidence: name refers to full_name; the oldest refers to MAX(age);
SQL: SELECT T1.full_name FROM person AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.person_id ORDER BY T2.age DESC LIMIT 1

Database: talkingdata
Question: Among all the times event no.2 happened when the app user was not active, when was the earliest time this situation happened?
Evidence: event no. refers to event_id; event_id = 2; not active refers to is_active = 0; earliest time refers to MIN(timestamp);
SQL: SELECT T2.timestamp FROM app_events AS T1 INNER JOIN events AS T2 ON T2.event_id = T1.event_id WHERE T1.is_active = 0 AND T2.event_id = 2 ORDER BY T2.timestamp LIMIT 1

Database: movie_platform
Question: Among the users who are trailists when rating the movie "When Will I Be Loved", how many of them have rated "1" on the movie?
Evidence: When Will I Be Loved refers to movie_title; the user was a trialist when he rated the movie refers to user_trialist = 1;rated 1 on the movie refers to rating_score = 1;
SQL: SELECT COUNT(T1.user_id) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'When Will I Be Loved' AND T1.rating_score = 1 AND T1.user_trialist = 1

Database: disney
Question: Which actor voices Akela from The Jungle Book?
Evidence: Akela refers character = 'Akela'; which actor voices refers to voice-actor;
SQL: SELECT `voice-actor` FROM `voice-actors` WHERE character = 'Akela'

Database: retail_world
Question: Identify the total number of orders processed by Northwind employee named Andrew Fuller. What percent of those orders was shipped to Austria?
Evidence: 'Andrew Fuller' is the full name of an employee; full name refers to FistName, LastName; Austria refers to ShipCountry; calculation = DIVIDE(SUM(ShipCountry = 'Austria'), COUNT(OrderID)) * 100
SQL: SELECT CAST(COUNT(CASE WHEN T2.ShipCountry = 'Austria' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.OrderID) FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T1.FirstName = 'Andrew' AND T1.LastName = 'Fuller'