Database: movie_platform
Question: What is the average number of number of movies added to the lists of user 8516503? Indicate how many movies did he/she give a rating score of 5.
Evidence: average number of number of movies refers to AVG(list_movie_number); user 8516503 refers to user_id = 8516503; rating score of 5 refers to rating_score = 5
SQL: SELECT AVG(T3.list_movie_number) , SUM(CASE WHEN T1.rating_score = 5 THEN 1 ELSE 0 END) FROM ratings AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id INNER JOIN lists AS T3 ON T2.user_id = T3.user_id WHERE T1.user_id = 8516503

Database: professional_basketball
Question: For the player who had the most rebounds throughout his allstar appearances, what was his weight and height?
Evidence: the most rebounds refers to max(rebounds)
SQL: SELECT T1.weight, T1.height FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID ORDER BY T2.rebounds DESC LIMIT 1

Database: shakespeare
Question: When did Shakespeare write the first poem?
Evidence: first poem refers to GenreType = 'Poem' and Date = 'min'
SQL: SELECT MIN(Date) FROM works WHERE GenreType = 'Poem'

Database: superstore
Question: What is the total sales of furniture products in the east superstore in the year 2016.

Evidence: furniture products refers to Category = 'Furnitures'; in the year 2016 refers to "Order Date" BETWEEN '2016-01-01' AND '2016-12-31'
SQL: SELECT SUM(T1.Sales) FROM east_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE STRFTIME('%Y', T1.`Order Date`) = '2016' AND T2.Category = 'Furniture'

Database: movie_3
Question: Please list the titles of all the films that have more than 2 special features.
Evidence: more than 2 special features refers to Count(special_features) > 2
SQL: SELECT title FROM ( SELECT title, COUNT(special_features) AS num FROM film GROUP BY title ) AS T ORDER BY T.num > 2

Database: soccer_2016
Question: Which country is the youngest player from?
Evidence: country refers to Country_Name; youngest player refers to max(DOB)
SQL: SELECT T1.Country_Name FROM Country AS T1 INNER JOIN Player AS T2 ON T1.Country_Id = T2.Country_Name ORDER BY T2.DOB DESC LIMIT 1

Database: computer_student
Question: Who are the top 5 professors who teaches the highest number of professional or master/undergraduate courses?
Evidence: professors refers to course.p_id; highest number of professional or master/undergraduate courses refers to max(count(course.course_id)) where courseLevel = 'Level_500'
SQL: SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel = 'Level_500' GROUP BY T2.p_id ORDER BY COUNT(T2.p_id) DESC LIMIT 5

Database: image_and_language
Question: On image no. 20, identify the attribute ID that is composed of the highest number of objects.
Evidence: image no. 20 refers to IMG_ID = 20; attribute ID refers to ATT_CLASS_ID; highest number of objects refers to max(count(ATT_CLASS_ID))
SQL: SELECT ATT_CLASS_ID FROM IMG_OBJ_ATT WHERE IMG_ID = 20 GROUP BY ATT_CLASS_ID ORDER BY COUNT(ATT_CLASS_ID) DESC LIMIT 1

Database: address
Question: What is the CBSA name and type in York, ME?
Evidence: "York" is the city; 'ME' is the state; type refers to CBSA_type
SQL: SELECT T1.CBSA_name, T1.CBSA_type FROM CBSA AS T1 INNER JOIN zip_data AS T2 ON T1.CBSA = T2.CBSA WHERE T2.city = 'York' AND T2.state = 'ME'

Database: bike_share_1
Question: Find the average ride time of the bikes that started at Steuart at Market station and ended at Embarcadero at Sansome station in July 2014.
Evidence: started at refers to start_station_name; start_station_name = 'Steuart at Market'; ended at refers to end_station_name; end_station_name = 'Embarcadero at Sansome'; rides in July 2004 refers to start_date = '7/1/2014 0:00'AND end_date = '7/31/2014 12:59';average ride time = DIVIDE(SUM(duration), COUNT(id))
SQL: SELECT AVG(duration) FROM trip WHERE start_date = '7/1/2014%' AND end_date = '7/31/2014%' AND start_station_name = 'Steuart at Market' AND end_station_name = 'Embarcadero at Sansome'

Database: retail_world
Question: What are the names of the products that were discountinued?
Evidence: discontinued refers to Discontinued = 1; name of products refers to ProductName
SQL: SELECT ProductName FROM Products WHERE Discontinued = 1

Database: shakespeare
Question: For how many times has the scene "OLIVIA’S house." appeared in Twelfth Night?
Evidence: "OLIVIA’S house."  refers to chapters.Description = 'OLIVIA’S house.'; Twelfth Night refers to Title = 'Twelfth Night'
SQL: SELECT COUNT(T2.id) FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T2.Description = 'OLIVIA’S house.' AND T1.Title = 'Twelfth Night'

Database: restaurant
Question: Identify all the restaurants in Marin County by their id.
SQL: SELECT T1.id_restaurant FROM generalinfo AS T1 INNER JOIN geographic AS T2 ON T1.city = T2.city WHERE T2.county = 'marin county'

Database: shakespeare
Question: Between Rome and Juliet, which character was mentioned the most in the The Tragedy of Romeo and Juliet? Calculate for Romeo and Juliet's individual amount of appearance in percentage against the overall number of characters that appeared in the said work.
Evidence: Rome and Juliet refers to CharName = 'Romeo' and CharName = 'Juliet'; The Tragedy of Romeo and Juliet refers to LongTitle = 'The Tragedy of Romeo and Juliet'; percentage = divide(sum(charater.id) when CharName = 'Romeo', sum(charater.id)) as percentage and percentage = divide(sum(charater.id) when CharName = 'Juliet', count(charater.id)) as percentage
SQL: SELECT SUM(IIF(T4.CharName = 'Romeo', 1, 0)), SUM(IIF(T4.CharName = 'Juliet', 1, 0)), CAST(SUM(IIF(T4.CharName = 'Romeo', 1, 0)) + SUM(IIF(T4.CharName = 'Juliet', 1, 0)) AS REAL) * 100 / COUNT(T1.id) FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id INNER JOIN paragraphs AS T3 ON T2.id = T3.chapter_id INNER JOIN characters AS T4 ON T3.character_id = T4.id

Database: address
Question: Among the cities belonging to the country named Arroyo, calculate the percentage of increase in the population in these cities from 2010 to 2020.
Evidence: DIVIDE(SUBTRACT(SUM(population_2020)), SUM(population_2010)), SUM(population_2010) as percentage where county = 'ARROYO';
SQL: SELECT CAST((SUM(T2.population_2020) - SUM(T2.population_2010)) AS REAL) * 100 / SUM(T2.population_2010) FROM country AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.city = 'Arroyo'

Database: disney
Question: How many movies were released by Disney between 2010 and 2016?
Evidence: Movies refer to movie_title; released between 2010 and 2016 refers to substr(release_date, length(release_date) - 1, length(release_date)) between '10' and '16';
SQL: SELECT COUNT(movie_title) FROM characters WHERE SUBSTR(release_date, LENGTH(release_date) - 1, LENGTH(release_date)) BETWEEN '10' AND '16'

Database: university
Question: How many universities have at least 80,000 students in the year 2011?
Evidence: have at least 80,000 students refers to num_students > 8000; year = 2011
SQL: SELECT COUNT(*) FROM university_year WHERE num_students > 80000 AND year = 2011

Database: cars
Question: What is the fastest car made by Japan?
Evidence: the fastest refers to max(horsepower); made by Japan refers to country = 'Japan'; name of the car refers to car_name
SQL: SELECT T1.car_name 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 T3.country = 'Japan' ORDER BY T1.horsepower DESC LIMIT 1

Database: books
Question: How many customers ordered the book titled "Anleitung zum Zickigsein"
Evidence: "Anleitung zum Zickigsein" is the title of the book
SQL: SELECT COUNT(*) FROM book AS T1 INNER JOIN order_line AS T2 ON T1.book_id = T2.book_id WHERE T1.title = 'Anleitung zum Zickigsein'