Database: professional_basketball
Question: Who is the tallest player in Denver Nuggets since 1980?
Evidence: "Denver Nuggets" is the name of team; since 1980 refers to year > 1980; tallest player = Max(height)
SQL: SELECT T1.firstName, T1.lastName FROM players AS T1 INNER JOIN players_teams AS T2 ON T1.playerID = T2.playerID INNER JOIN teams AS T3 ON T3.tmID = T2.tmID WHERE T3.name = 'Denver Nuggets' AND T2.year > 1980 ORDER BY T1.height DESC LIMIT 1

Database: language_corpus
Question: Which word that has 274499 repetitions in the Catalan language?
Evidence: lid = 1 menas it's Catalan language; 274499 repetitions refers to occurrences = 274499
SQL: SELECT T1.word FROM words AS T1 INNER JOIN langs_words AS T2 ON T1.wid = T2.wid WHERE T2.occurrences = 274499 AND T2.lid = 1

Database: movie_platform
Question: How many films were released in 2007?
Evidence: film released in 2007 refers to movie_release_year = 2007; film refers to movie
SQL: SELECT COUNT(*) FROM movies WHERE movie_release_year = 2007

Database: movie_platform
Question: What is the name of the movie whose critic received the highest amount of likes? Indicate the URL to the rating on Mubi.
Evidence: critic received the highest amount of likes refers to MAX(critic_likes);
SQL: SELECT T2.movie_title, T1.rating_url FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.critic_likes DESC LIMIT 1

Database: cars
Question: Among the cars introduced in 1977, provide the names and the horse powers of cars from Europe.
Evidence: introduced in 1977 refers to model_year = 1977; car's name refers to car_name; from Europe refers to country = 'Europe'
SQL: SELECT T1.car_name, T1.horsepower FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country WHERE T2.model_year = 1977 AND T3.country = 'Europe'

Database: food_inspection_2
Question: How many sanitarian employees in Chicago are from the zip code 60617?
Evidence: sanitarian refers to title = 'Sanitarian'; in Chicago refers to city = 'Chicago'; zip code 60617 refers to zip = 60617
SQL: SELECT COUNT(employee_id) FROM employee WHERE zip = '60617'

Database: computer_student
Question: Please list the IDs of all the faculty employees who teaches a basic or medium undergraduate course.
Evidence: faculty employees refers to hasPosition = 'Faculty_eme'; basic or medium undergraduate course refers to courseLevel = 'Level_300'
SQL: SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T1.courseLevel = 'Level_300' AND T3.hasPosition = 'Faculty_eme'

Database: retail_world
Question: Who are the top 8 suppliers supplying the products with the highest user satisfaction?
Evidence: highest user satisfaction refers to max(ReorderLevel);
SQL: SELECT T2.CompanyName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID ORDER BY T1.ReorderLevel DESC LIMIT 8

Database: sales
Question: List the first names of customers who have purchased products from sale person id 1.
SQL: SELECT T1.FirstName FROM Customers AS T1 INNER JOIN Sales AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.SalesPersonID = 1

Database: language_corpus
Question: List all the first words of the biwords pair where the second word is 'antic'.
Evidence: first words refer to w1st.word; second word is 'antic' refers to w2nd.word = 'antic'
SQL: SELECT T1.word FROM words AS T1 INNER JOIN biwords AS T2 ON T1.wid = T2.w1st WHERE T2.w2nd = ( SELECT wid FROM words WHERE word = 'antic' )

Database: soccer_2016
Question: Among the players, what percentage are both captain and keeper?
Evidence: captain and keeper refers to Role_Desc = 'CaptainKeeper'; percentage = divide(count(Player_Id) when Role_Desc = 'CaptainKeeper', count(Player_Id)) as percentage
SQL: SELECT CAST(SUM(CASE WHEN T2.Role_Desc = 'CaptainKeeper' THEN 1 ELSE 0 END) AS REAL) * 100 / TOTAL(T1.Player_Id) FROM Player_Match AS T1 INNER JOIN Rolee AS T2 ON T1.Role_Id = T2.Role_Id

Database: social_media
Question: For the tweet which got a reach number of 547851, which country did it come from?
Evidence: reach number of 547851 refers to Reach = 547851
SQL: SELECT T2.Country FROM twitter AS T1 INNER JOIN location AS T2 ON T2.LocationID = T1.LocationID WHERE T1.Reach = 547851

Database: codebase_comments
Question: For the method which got the tokenized name as 't jadwal entity get single mpic', what is the path time for its solution?
Evidence: tokenized name refers to NameTokenized; NameTokenized = 't jadwal entity get single mpic'; path time for its solution refers to ProcessedTime;
SQL: SELECT DISTINCT T1.ProcessedTime FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.NameTokenized = 't jadwal entity get single mpic'

Database: cs_semester
Question: Which of the two courses, "Advanced Operating System" or "Intro to BlockChain', did most of the students receive an A in?
Evidence: A refers to an excellent grade in which grade = 'A';
SQL: SELECT T2.name FROM registration AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.grade = 'A' AND T2.name IN ('Advanced Operating System', 'Intro to BlockChain') GROUP BY T2.name ORDER BY COUNT(T1.student_id) DESC LIMIT 1

Database: beer_factory
Question: What is the percentage difference of River City sale compare to Frostie?
Evidence: percentage difference = (DIVIDE(MULTIPLY(SUBTRACT(SUM(PurchasePrice WHERE BrandName = 'River City'), SUM(PurchasePrice WHERE BrandName = 'Frostie')), 100), SUM(PurchasePrice WHERE BrandName = 'Frostie'))); River City refers to BrandName = 'River City'; Frostie refers to BrandName = 'Frostie';
SQL: SELECT CAST((SUM(CASE WHEN T3.BrandName = 'River City' THEN T2.PurchasePrice ELSE 0 END) - SUM(CASE WHEN T3.BrandName = 'Frostie' THEN T2.PurchasePrice ELSE 0 END)) AS REAL) * 100 / SUM(CASE WHEN T3.BrandName = 'Frostie' THEN T2.PurchasePrice ELSE 0 END) FROM rootbeer AS T1 INNER JOIN `transaction` AS T2 ON T1.RootBeerID = T2.RootBeerID INNER JOIN rootbeerbrand AS T3 ON T1.BrandID = T3.BrandID

Database: movie
Question: Who played the character named "Chanice Kobolowski"?
SQL: SELECT T2.Name FROM characters AS T1 INNER JOIN actor AS T2 ON T1.ActorID = T2.ActorID WHERE T1.`Character Name` = 'Chanice Kobolowski'

Database: university
Question: Show the name of country id 66.
Evidence: name of country refers to country_name
SQL: SELECT country_name FROM country WHERE id = 66

Database: citeseer
Question: How many papers were cited by schmidt99advanced cited word3555?
Evidence: paper cited by refers to citing_paper_id; citing_paper_id = 'schmidt99advanced';
SQL: SELECT COUNT(T2.paper_id) FROM cites AS T1 INNER JOIN content AS T2 ON T1.cited_paper_id = T2.paper_id WHERE T1.citing_paper_id = 'schmidt99advanced' AND T2.word_cited_id = 'word3555'

Database: books
Question: What is the number of pages of the book in the order ID 1167?
Evidence: number of pages refers to num_pages
SQL: SELECT T1.num_pages FROM book AS T1 INNER JOIN order_line AS T2 ON T1.book_id = T2.book_id WHERE T2.order_id = 1167

Database: car_retails
Question: Which two products has the highest and lowest expected profits? Determine the total price for each product in terms of the largest quantity that was ordered.
Evidence: expected profits = SUBTRACT(msrp, buyPrice); total price = MULTIPLY(quantityOrdered, priceEach)
SQL: SELECT T2.productName, SUM(T1.quantityOrdered * T1.priceEach) FROM orderdetails AS T1 INNER JOIN ( SELECT productCode, productName FROM products ORDER BY MSRP - buyPrice DESC LIMIT 1 ) AS T2 ON T1.productCode = T2.productCode UNION SELECT T2.productName, SUM(quantityOrdered * priceEach) FROM orderdetails AS T1 INNER JOIN ( SELECT productCode, productName FROM products ORDER BY MSRP - buyPrice ASC LIMIT 1 ) AS T2 ON T1.productCode = T2.productCode