Database: music_tracker
Question: An American rapper '2Pac' released his first solo album in 1991, how many years have passed until his next album was released?
Evidence: 2Pac is an artist; album refers to releaseType; groupYear = 1991; SUBTRACT(groupYear = 1991, groupYear where releaseType = 'album' LIMIT 1 OFFSET 1);
SQL: SELECT ( SELECT groupYear FROM torrents WHERE artist LIKE '2Pac' AND releaseType LIKE 'album' ORDER BY groupYear LIMIT 1, 1 ) - groupYear FROM torrents WHERE artist LIKE '2Pac' AND releaseType LIKE 'album' AND groupYear = 1991

Database: retails
Question: Provide the nation and region of the customer with the address of wH55UnX7 VI?
Evidence: nation refers to n_name; region refers to r_name; address of wH55UnX7 VI refers to c_address = 'wH55UnX7 VI';
SQL: SELECT T1.n_name, T3.r_name FROM nation AS T1 INNER JOIN customer AS T2 ON T1.n_nationkey = T2.c_nationkey INNER JOIN region AS T3 ON T1.n_regionkey = T3.r_regionkey WHERE T2.c_address = 'wH55UnX7 VI'

Database: superstore
Question: List the product's name bought by the customer named Bill Shonely from the Central region.
SQL: SELECT DISTINCT T3.`Product Name` FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T2.`Product ID` WHERE T1.`Customer Name` = 'Bill Shonely' AND T2.Region = 'Central'

Database: codebase_comments
Question: Which method has the summary "Write a command to the log"?
SQL: SELECT Name FROM Method WHERE Summary = 'Write a command to the log'

Database: computer_student
Question: Calculate the percentage of high-level undergraduate course.
Evidence: high-level undergraduate course refers to courseLevel = 'Level_400'; percentage = divide(count(course.course_id) when courseLevel = 'Level_400', count(course.course_id)) * 100%
SQL: SELECT CAST(SUM(CASE  WHEN courseLevel = 'Level_400' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) AS per FROM course

Database: olympics
Question: State the name of sport id 19.
Evidence: name of sport refers to sport_name
SQL: SELECT sport_name FROM sport WHERE id = 19

Database: books
Question: What is the sum of the number of pages of the books ordered by Mick Sever?
Evidence: sum of the number of pages refers to Sum(num_pages)
SQL: SELECT SUM(T1.num_pages) FROM book AS T1 INNER JOIN order_line AS T2 ON T1.book_id = T2.book_id INNER JOIN cust_order AS T3 ON T3.order_id = T2.order_id INNER JOIN customer AS T4 ON T4.customer_id = T3.customer_id WHERE T4.first_name = 'Mick' AND T4.last_name = 'Sever'

Database: movie_3
Question: What is the most common special features of science-fiction movies?
Evidence: "science fiction" is the name of category; most common special features refers to Max(frequency(special_features))
SQL: SELECT T1.special_features FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T2.category_id = T3.category_id WHERE T3.name = 'sci-fi' ORDER BY T1.special_features DESC LIMIT 1

Database: book_publishing_company
Question: Please list the stores that ordered the book "Life Without Fear".
Evidence: store name refers to stor_name
SQL: SELECT T2.stor_name FROM sales AS T1 INNER JOIN stores AS T2 ON T1.stor_id = T2.stor_id INNER JOIN titles AS T3 ON T1.title_id = T3.title_id WHERE T3.title = 'Life Without Fear'

Database: synthea
Question: List out the procedure and medicine prescribed for drug overdose patients.
Evidence: procedure refers to procedures.DESCRIPTION; medicine prescribed refers to medications.DESCRIPTION; drug overdose refers to encounters.REASONDESCRIPTION = 'Drug overdose';
SQL: SELECT DISTINCT T2.DESCRIPTION, T3.DESCRIPTION FROM encounters AS T1 INNER JOIN procedures AS T2 ON T1.PATIENT = T2.PATIENT INNER JOIN medications AS T3 ON T1.PATIENT = T3.PATIENT WHERE T1.REASONDESCRIPTION = 'Drug overdose'

Database: codebase_comments
Question: Please provide the number of stars that the repository of the solution 20 have.
Evidence: solution refers to Solution.ID; Solution.Id = 20;
SQL: SELECT T1.Stars FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T2.Id = 20

Database: movie_3
Question: On what date was the rented material for the movie BLOOD ARGONAUTS returned?
Evidence: 'BLOOD ARGONAUTS' is a title of a film; date a movie was returned refers to return_date
SQL: SELECT T1.rental_date FROM rental AS T1 INNER JOIN inventory AS T2 ON T1.inventory_id = T2.inventory_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T3.title = 'BLOOD ARGONAUTS'

Database: car_retails
Question: From which branch does the sales representative employee who made the most sales in 2005? Please indicates its full address and phone number.
Evidence: orderDate between '2005-01-01' and '2005-12-31'; full address = addressLine1+addressLine2;
SQL: SELECT T3.addressLine1, T3.addressLine2, T3.phone FROM orderdetails AS T1 INNER JOIN orders AS T2 ON T1.orderNumber = T2.orderNumber INNER JOIN customers AS T3 ON T2.customerNumber = T3.customerNumber INNER JOIN employees AS T4 ON T3.salesRepEmployeeNumber = T4.employeeNumber INNER JOIN offices AS T5 ON T4.officeCode = T5.officeCode WHERE STRFTIME('%Y', T2.orderDate) = '2005' AND T4.jobTitle = 'Sales Rep' ORDER BY T1.quantityOrdered DESC LIMIT 1

Database: authors
Question: List the title of papers with a conference ID from 160 to 170, include their conference short name.
Evidence: conference ID from 160 to 170 refers to ConferenceId BETWEEN 160 AND 170
SQL: SELECT DISTINCT T1.Title, T2.ShortName FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T1.ConferenceId BETWEEN 160 AND 170

Database: soccer_2016
Question: Please list the names of the players who use the right hand as their batting hand and are from Australia.
Evidence: name of player refers to Player_Name; right hand as batting hand refers to Batting_Hand = 'Right-hand bat'; Australia refers to Country_Name = 'Australia'
SQL: SELECT T2.Player_Name FROM Country AS T1 INNER JOIN Player AS T2 ON T2.Country_Name = T1.Country_id INNER JOIN Batting_Style AS T3 ON T2.Batting_hand = T3.Batting_Id WHERE T1.Country_Name = 'Australia' AND T3.Batting_Hand = 'Right-hand bat'

Database: cars
Question: What is the maximum sweep volume of a car that costs less than $30000?
Evidence: cost less than $30000 refers to price < 30000; the maximum sweep volume = max(divide(displacement, cylinders)) where price < 30000
SQL: SELECT MAX(T1.displacement / T1.cylinders) FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T2.price < 30000

Database: simpson_episodes
Question: How many WGA Award (TV) award recipients were born in the USA from 2009 to 2010?
Evidence: WGA Award (TV) award refers to award_category = 'WGA Award (TV)'; born in the USA refers to birth_country = 'USA'; from 2009 to 2010 refers to birthdate BETWEEN '2019-01-01' and '2019-12-31'
SQL: SELECT COUNT(*) FROM Person AS T1 INNER JOIN Award AS T2 ON T1.name = T2.person WHERE T2.award_category = 'WGA Award (TV)' AND T1.birth_country = 'USA' AND T2.year BETWEEN 2009 AND 2010;

Database: retail_world
Question: Indicate the address of the company Eastern Connection whose contact name is Ann Devon.
Evidence: 'Eastern Connection' is a CompanyName; 'Ann Devon' is the full name of an employee; full name refers to FirstName, LastName
SQL: SELECT Address FROM Customers WHERE CompanyName = 'Eastern Connection' AND ContactName = 'Ann Devon'

Database: music_platform_2
Question: How many people rated 5 for the podcast which title contains the word 'spoiler' under the 'art' category '?
Evidence: rated 5 refers to rating = 5; contain the word 'spoilers' refers to title like '%spoilers%'; 'art' is the category name;
SQL: SELECT COUNT(T3.podcast_id) FROM categories AS T1 INNER JOIN podcasts AS T2 ON T2.podcast_id = T1.podcast_id INNER JOIN reviews AS T3 ON T3.podcast_id = T2.podcast_id WHERE T2.title LIKE '%spoilers%' AND T1.category = 'arts' AND T3.rating = 5