Database: retails
Question: Please list any two parts that come with the wrap bag container and have a supply cost of under 10.
Evidence: part name refers to p_name; wrap bag container refers to p_container = 'WRAP BAG'; supply cost of under 10 refers to ps_supplycost < 10
SQL: SELECT T1.p_name FROM part AS T1 INNER JOIN partsupp AS T2 ON T1.p_partkey = T2.ps_partkey WHERE T2.ps_supplycost < 10 AND T1.p_container = 'WRAP BAG' LIMIT 2

Database: donor
Question: How much did the project that teacher "822b7b8768c17456fdce78b65abcc18e" created donate?
Evidence: teacher "822b7b8768c17456fdce78b65abcc18e" refers to teacher_acctid = '822b7b8768c17456fdce78b65abcc18e'; donated refers to donation_total;
SQL: SELECT T2.donation_total FROM projects AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T1.teacher_acctid = '822b7b8768c17456fdce78b65abcc18e'

Database: software_company
Question: Please list the occupations of the customers with an education level of 11.
Evidence: education level of 11 refers to EDUCATIONNUM = 11;
SQL: SELECT DISTINCT OCCUPATION FROM Customers WHERE EDUCATIONNUM = 11

Database: address
Question: What is the alias of the city called Hartford?
Evidence: "Hartford" is the city
SQL: SELECT DISTINCT T2.alias FROM zip_data AS T1 INNER JOIN alias AS T2 ON T1.zip_code = T2.zip_code WHERE T1.city = 'Hartford'

Database: restaurant
Question: How many deli in Belmont have a review rating of 2 or more?
Evidence: deli ris a food type; Belmont refers to city = 'belmont'; review rating of 2 or more refers to review > 2
SQL: SELECT COUNT(id_restaurant) FROM generalinfo WHERE city = 'belmont' AND review > 2 AND food_type = 'deli'

Database: public_review_platform
Question: Please list all the categories of the Yelp_Business in Arizona.
Evidence: categories refers to category_name; in Arizona refers to state = 'AZ'
SQL: SELECT T1.category_name FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id INNER JOIN Business AS T3 ON T2.business_id = T3.business_id WHERE T3.state LIKE 'AZ' GROUP BY T1.category_name

Database: soccer_2016
Question: Which season has the fewest number of matches?
Evidence: fewest number of matches refers to min(count(Match_Id))
SQL: SELECT Season_Id FROM `Match` GROUP BY Season_Id ORDER BY COUNT(Match_Id) LIMIT 1

Database: music_platform_2
Question: How many reviews does "Planet Money" have?
Evidence: "Planet Money" is the title of podcast
SQL: SELECT COUNT(T2.podcast_id) FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.title = 'Planet Money'

Database: college_completion
Question: In female students in year 2012, how many of them from a state with number of schools ranges from 10 to 20?
Evidence: female refers to gender = 'F'; number of schools refers to schools_count; schools_count BETWEEN 10 AND 20;
SQL: SELECT COUNT(T2.race) FROM state_sector_details AS T1 INNER JOIN state_sector_grads AS T2 ON T2.stateid = T1.stateid WHERE T2.gender = 'F' AND schools_count BETWEEN 10 AND 20 AND T2.year = 2012

Database: movie_platform
Question: How many likes did the critic of the movie "Apocalypse Now" received after giving the movie a rating score of 5?
Evidence: Apocalypse Now refer to movie_title; rating score refer to rating_score = '5';likes received refers to critic_likes

SQL: SELECT T2.critic_likes FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.user_trialist = 0 AND T2.rating_score = 5 AND T1.movie_title = 'Apocalypse Now'

Database: soccer_2016
Question: Which season played the highest number of matches at M Chinnaswamy Stadium?
Evidence: season refers to Season_Id; the highest number of matches refers to max(count(Season_Id)); M Chinnaswamy Stadium refers to Venue_Name = 'M Chinnaswamy Stadium'
SQL: SELECT T1.Season_Id FROM `Match` AS T1 INNER JOIN Venue AS T2 ON T1.Venue_Id = T2.Venue_Id WHERE T2.Venue_Name = 'M Chinnaswamy Stadium' GROUP BY T1.Season_Id ORDER BY COUNT(T1.Season_Id) DESC LIMIT 1

Database: car_retails
Question: When were the products ordered by Cruz & Sons Co. on 2003-03-03 shipped?
Evidence: Cruz & Sons Co. is name of customer; ordered on 2003-03-03 refers to orderDate;
SQL: SELECT t1.shippedDate FROM orders AS t1 INNER JOIN customers AS t2 ON t1.customerNumber = t2.customerNumber WHERE t2.customerName = 'Cruz & Sons Co.' AND t1.orderDate = '2003-03-03'

Database: video_games
Question: What is the name of the publisher that released the most video games in 2007?
Evidence: name of the publisher refers to publisher_name; publisher that released the most video games in 2007 refers to MAX(COUNT(publisher_name)) WHERE release_year = 2007;
SQL: SELECT T3.publisher_name FROM game_platform AS T1 INNER JOIN game_publisher AS T2 ON T1.game_publisher_id = T2.id INNER JOIN publisher AS T3 ON T2.publisher_id = T3.id WHERE T1.release_year = 2007 GROUP BY T3.publisher_name ORDER BY COUNT(DISTINCT T2.game_id) DESC LIMIT 1

Database: food_inspection_2
Question: Please list the full names of all the sanitarians under the supervision of Darlisha Jacobs.
Evidence: full name refers to first_name, last_name
SQL: SELECT first_name, last_name FROM employee WHERE title = 'Sanitarian' AND supervisor = ( SELECT employee_id FROM employee WHERE first_name = 'Darlisha' AND last_name = 'Jacobs' )

Database: sales
Question: List the full name of customers who spend more than 50,000 in descending order the amount spend.
Evidence: full name of the customer = FirstName, MiddleInitial, LastName; more than 50,000 in the amount refers to MULTIPLY(Quantity, Price) > 50000;
SQL: SELECT DISTINCT T3.FirstName, T3.MiddleInitial, T3.LastName FROM Products AS T1 INNER JOIN Sales AS T2 ON T1.ProductID = T2.ProductID INNER JOIN Customers AS T3 ON T2.CustomerID = T3.CustomerID WHERE T2.Quantity * T1.Price > 50000

Database: movielens
Question: What are the ID of actors with quality rating of 3 acted in English USA movies?
Evidence: English movies refers to isEnglish = 'T'; USA is a country
SQL: SELECT T2.actorid FROM movies AS T1 INNER JOIN movies2actors AS T2 ON T1.movieid = T2.movieid INNER JOIN actors AS T3 ON T2.actorid = T3.actorid WHERE T3.a_quality = 3 AND T1.country = 'USA' AND T1.isEnglish = 'T'

Database: student_loan
Question: Calculate the average enlisted students per organization.
Evidence: average = DIVIDE(FLOOR(COUNT(NAME), COUNT(DISTINCT organ)));
SQL: SELECT CAST(COUNT(NAME) AS REAL) * 100 / COUNT(DISTINCT organ) FROM enlist

Database: mental_health_survey
Question: From 2016 to 2019, how many users each year were asked the question 13?
Evidence: From 2016 to 2019 refer to SurveyID 2016 BETWEEN 2019; Question 13 refer to QuestionID
SQL: SELECT SurveyID, COUNT(UserID) FROM Answer WHERE QuestionID = 13 AND SurveyID BETWEEN 2016 AND 2019 GROUP BY SurveyID

Database: disney
Question: Who was the first ever Disney villain?
Evidence: the first ever villian is villian that was released before all others in time which refers to substr(release_date, length(release_date) - 1, length(release_date)) desc limit 1;
SQL: SELECT villian FROM characters ORDER BY SUBSTR(release_date, LENGTH(release_date) - 1, LENGTH(release_date)) DESC LIMIT 1

Database: coinmarketcap
Question: State the transaction date and the price when Bitcoin was bottomed?
Evidence: was bottomed refers to min(price)
SQL: SELECT T2.date, T2.price FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T1.name = 'Bitcoin' ORDER BY T2.price LIMIT 1