Database: university
Question: For the university id 268, show its number of students in 2013.
Evidence: number of students refers to num_students; in 2013 refers to year = 2013
SQL: SELECT num_students FROM university_year WHERE university_id = 268 AND year = 2013

Database: sales
Question: What is the price and quantity of the product named Seat Tube?
SQL: SELECT DISTINCT T2.Price, T1.Quantity FROM Sales AS T1 INNER JOIN Products AS T2 ON T1.ProductID = T2.ProductID WHERE T2.Name = 'Seat Tube'

Database: student_loan
Question: Calculate the percentage of female students.
Evidence: percentage = CONCAT(DIVIDE(MULTIPLY(COUNT(person.name which is not in male.name)), 100), COUNT(person.name that is IN male.name),'%'); female students refers to person.name who are NOT in male.name;
SQL: SELECT CAST(SUM(IIF(T2.name IS NULL, 1, 0)) AS REAL) * 100 / COUNT(T1.name) FROM person AS T1 LEFT JOIN male AS T2 ON T2.name = T1.name

Database: books
Question: How many orders were delivered in 2021?
Evidence: delivered refers to status_value = 'Delivered'; in 2021 refers to status_date LIKE '2021%'
SQL: SELECT COUNT(*) FROM order_status AS T1 INNER JOIN order_history AS T2 ON T1.status_id = T2.status_id WHERE T1.status_value = 'Delivered' AND STRFTIME('%Y', T2.status_date) = '2021'

Database: music_tracker
Question: Please list the titles of all the releases with the tag "1980s".
Evidence: titles refer to groupName;
SQL: SELECT T1.groupName FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T2.tag = '1980s'

Database: retail_complains
Question: List date of the review of the Eagle Capital from Indianapolis, Indiana.
Evidence: Eagle Capital refers to Product = 'Eagle Capital'; Indianapolis refers to city = 'Indianapolis'; Indiana refers to state_abbrev = 'IN'
SQL: SELECT T2.Date FROM district AS T1 INNER JOIN reviews AS T2 ON T1.district_id = T2.district_id WHERE T2.Product = 'Eagle Capital' AND T1.city = 'Indianapolis' AND T1.state_abbrev = 'IN'

Database: world_development_indicators
Question: Please list the Alpha2Codes of all the countries that have an indicator on Rural population in 1960.
Evidence: in 1960 refers to year = '1960'
SQL: SELECT T1.Alpha2Code FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.IndicatorName = 'Rural population' AND T2.Year = 1960

Database: college_completion
Question: What is the state name of male graduate in 2011 from a private for profit institution with black students?
Evidence: male refers to gender = 'M'; in 2011 refers to year = '2011'; private for profit refers to control = 'Private for-profit'; black refers to race = 'B';
SQL: SELECT DISTINCT T1.state FROM state_sector_details AS T1 INNER JOIN state_sector_grads AS T2 ON T2.stateid = T1.stateid WHERE T2.gender = 'M' AND T2.race = 'B' AND T1.control = 'Private for-profit' AND T2.year = 2011

Database: student_loan
Question: What is the ratio of disable female to male students?
Evidence: ratio refers to DIVIDE(COUNT(name not from male), COUNT(name from male))
SQL: SELECT CAST(SUM(IIF(T2.name IS NULL, 1, 0)) AS REAL) * 100 / COUNT(T2.name) FROM disabled AS T1 LEFT JOIN male AS T2 ON T1.`name` = T2.`name`

Database: public_review_platform
Question: How many users who have joined Yelp since "2005" but have no fans?
Evidence: joined Yelp since 2005 refers to user_yelping_since_year = 2005; no fans refers to user_fans = 'None';
SQL: SELECT COUNT(user_id) FROM Users WHERE user_yelping_since_year = 2005 AND user_fans LIKE 'None'

Database: car_retails
Question: How many 2003 Harley-Davidson Eagle Drag Bikes were ordered?
Evidence: 2003 Harley-Davidson Eagle Drag Bikes refers to productName; how many ordered refers to COUNT(quantityOrdered);
SQL: SELECT SUM(t2.quantityOrdered) FROM products AS t1 INNER JOIN orderdetails AS t2 ON t1.productCode = t2.productCode WHERE t1.productName = '2003 Harley-Davidson Eagle Drag Bike'

Database: donor
Question: Name the project titles meant for school whereby 65% of the students are on reduced lunch.
Evidence: 65% of the students are on reduced lunch refers to poverty_level = 'highest poverty'
SQL: SELECT T1.title FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T2.poverty_level LIKE 'highest%'

Database: app_store
Question: What is the average rating of comic category apps? How many users hold positive attitude towards this app?
Evidence: average rating = AVG(Rating where Category = 'COMICS'); number of users who hold a positive attitude towards the app refers to SUM(Sentiment = 'Positive');
SQL: SELECT AVG(T1.Rating) , COUNT(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE NULL END) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'COMICS'

Database: book_publishing_company
Question: Calculate the percentage of the employees who are Editor or Designer?
Evidence: Editor or Auditor are job description which refers to job_desc; percentage = DIVIDE(count(job_desc = 'Editor' or job_desc = 'Auditor'), count(emp_id))*100
SQL: SELECT CAST(SUM(CASE WHEN T2.job_desc IN ('Editor', 'Designer') THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.job_id) FROM employee AS T1 INNER JOIN jobs AS T2 ON T1.job_id = T2.job_id

Database: retail_world
Question: Please calculate the number of orders from customers by country in 1996.
Evidence: in 1996 refer to YEAR(OrderDate) = 1996; number of order = Count(OrderID)
SQL: SELECT COUNT(T2.CustomerID) FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID WHERE STRFTIME('%Y', T2.OrderDate) = '1996' GROUP BY T1.Country

Database: shipping
Question: How many shipments did Zachery Hicks transport goods to New York in the year 2016?
Evidence: "New York" is the city_name; in 2016 refers to CAST(ship_date AS DATE) = 2016
SQL: SELECT COUNT(*) FROM city AS T1 INNER JOIN shipment AS T2 ON T1.city_id = T2.city_id INNER JOIN driver AS T3 ON T3.driver_id = T2.driver_id WHERE T3.first_name = 'Zachery' AND T3.last_name = 'Hicks' AND T1.city_name = 'New York' AND STRFTIME('%Y', T2.ship_date) = '2016'

Database: shipping
Question: List all the name of the customers that received a shipment in February 2017.
Evidence: shipment in February 2017 refers to ship_date LIKE '2017-02-%'; name of customer refers to cust_name
SQL: SELECT T1.cust_name FROM customer AS T1 INNER JOIN shipment AS T2 ON T1.cust_id = T2.cust_id WHERE T2.ship_date LIKE '2017-02%'

Database: computer_student
Question: Find the professor ID and position in faculty who taught high-level undergraduate course of less than 10 in ID.
Evidence: professor ID refers to person.p_id when professor = 1; position in faculty refers to hasPosition; high-level undergraduate course refers to courseLevel = 'Level_400'; less than 10 in ID refers to course.course_id < 10
SQL: SELECT T1.p_id, T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T3.courseLevel = 'Level_400' AND T2.course_id < 10

Database: computer_student
Question: How many people teaches course no.11?
Evidence: people refers to taughtBy.p_id; course no.11 refers to course_id = 11
SQL: SELECT COUNT(*) FROM taughtBy WHERE course_id = 11

Database: chicago_crime
Question: What is the FBI code and definition of Gambling?
Evidence: FBI code refers to fbi_code_no; definition refers to description; Gambling refers to title = 'Gambling'
SQL: SELECT fbi_code_no, description FROM FBI_Code WHERE title = 'Gambling'

Database: disney
Question: How many movies for mature audiences or parental guidance suggested did Bill Thompson work as a voice actor?
Evidence: movies for mature audiences or parental guidance refer to movie_title where MPAA_rating = 'PG';
SQL: SELECT COUNT(T.movie) FROM ( SELECT T1.movie FROM `voice-actors` AS T1 INNER JOIN movies_total_gross AS T2 ON T1.movie = T2.movie_title WHERE MPAA_rating = 'PG' AND `voice-actor` = 'Bill Thompson' GROUP BY T1.movie ) AS T