Database: books
Question: What is the shipping method ordered by Nicolette Sadler at 6/29/2020 7:40:07 PM?
Evidence: ordered at 6/29/2020 7:40:07 PM refers to order_date = '2020-06-29 19:40:07'; shipping method refers to method_name
SQL: SELECT T3.method_name FROM cust_order AS T1 INNER JOIN customer AS T2 ON T1.customer_id = T2.customer_id INNER JOIN shipping_method AS T3 ON T3.method_id = T1.shipping_method_id WHERE T2.first_name = 'Nicolette' AND T2.last_name = 'Sadler' AND T1.order_date = '2020-06-29 19:40:07'

Database: donor
Question: Among the technology items, what percentage of them are from Best Buy for Business? Provide the date of the project related to those items.
Evidence: technology items refers to project_resource_type = 'Technology'; from Best Buy for Business refers to vendor_name = 'Best Buy for Business'; percentage refers to DIVIDE(count(case when vendor_name = 'Best Buy for Business'),count(projectid))
SQL: SELECT CAST(SUM(CASE WHEN T1.vendor_name = 'Best Buy for Business' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.projectid) FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.project_resource_type = 'Technology' UNION ALL SELECT DISTINCT T1.date_posted FROM projects AS T1 INNER JOIN resources AS T2 ON T1.projectid = T2.projectid WHERE T2.vendor_name = 'Best Buy for Business' AND T2.project_resource_type = 'Technology'

Database: public_review_platform
Question: How long was the review for business number 2 that user number 612 wrote?
Evidence: how long was the review refers to review_length; business number refers to business_id; user number refers to user_id;
SQL: SELECT review_length FROM Reviews WHERE user_id = 612 AND review_stars = 5 AND business_id = 2

Database: college_completion
Question: Tell the number of 4-year private not-for-profit schools in the home state of "Brevard Community College".
Evidence: 4-year refers to level = '4-year'; private not-for-profit refers to control = 'Private not-for-profit'; Brevard Community College refers to chronname = 'Brevard Community College';
SQL: SELECT COUNT(T1.chronname) FROM institution_details AS T1 INNER JOIN state_sector_details AS T2 ON T2.state = T1.state WHERE T2.level = '4-year' AND T2.control = 'Private not-for-profit' AND T1.chronname = 'Brevard Community College'

Database: language_corpus
Question: How many words are there on the page titled "Asclepi"?
Evidence: page titled "Asclepi" refers to title = 'Asclepi' ;
SQL: SELECT words FROM pages WHERE title = 'Asclepi'

Database: simpson_episodes
Question: List down all the roles of Matt Groening on the episode titled 'In the Name of the Grandfather' along with the episode number and series number.
Evidence: "Matt Groening" is the person; 'In the Name of the Grandfather' is the title of episode; episode number refers to episode; series number refers to number_in_series
SQL: SELECT T2.role, T1.episode, T1.number_in_series FROM Episode AS T1 INNER JOIN Credit AS T2 ON T1.episode_id = T2.episode_id WHERE T2.person = 'Matt Groening' AND T1.title = 'In the Name of the Grandfather';

Database: app_store
Question: How many users holds neutral attitude towards the HTC Weather app? Indicate the app's rating on the Google Play Store.
Evidence: user holds neutral attitude refers to Sentiment = 'Neutral';
SQL: SELECT COUNT(T1.Rating), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'HTC Weather' AND T2.Sentiment = 'Neutral'

Database: public_review_platform
Question: What are the categories of businesses that have opening time on Sunday?
Evidence: categories of businesses refer to category_name; Sunday refers to day_of_week where day_id = 1;
SQL: SELECT DISTINCT T1.category_name FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id INNER JOIN Business_Hours AS T3 ON T2.business_id = T3.business_id INNER JOIN Days AS T4 ON T3.day_id = T4.day_id WHERE T4.day_of_week = 'Sunday' AND T3.opening_time <> ''

Database: video_games
Question: Calculate the difference between sales of games from region ID 2 and region ID 3.
Evidence: difference = SUBTRACT(SUM(num_sales WHERE region_id = 2), SUM(num_sales WHERE region_id = 3));
SQL: SELECT SUM(CASE WHEN T.region_id = 2 THEN T.num_sales ELSE 0 END) - SUM(CASE WHEN T.region_id = 3 THEN T.num_sales ELSE 0 END) FROM region_sales t

Database: college_completion
Question: What was the number of female Hispanic students who graduated within 100 percent of expected time for "Pennsylvania State University-Altoona"?
Evidence: female refers to gender = 'F'; Hispanic refers to race = 'H'; graduated within 100 percent of expected time refers to grad_100; Pennsylvania State University-Altoona refers to chronname = 'Pennsylvania State University-Altoona';
SQL: SELECT SUM(T2.grad_100) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T1.chronname = 'Pennsylvania State University-Altoona' AND T2.gender = 'F' AND T2.race = 'H'

Database: soccer_2016
Question: How many overs were there in each innings of match ID "336011"?
SQL: SELECT SUM(CASE WHEN Innings_No = 1 THEN 1 ELSE 0 END) AS IN1 , SUM(CASE WHEN Innings_No = 2 THEN 1 ELSE 0 END) AS IN2 FROM Ball_by_Ball WHERE Match_Id = 336011

Database: regional_sales
Question: In which region can you find the stores located in the state whose median income is no more than 30,000?
Evidence: median income no more than 30,000 refers to Median Income < 30,000
SQL: SELECT T FROM ( SELECT DISTINCT CASE  WHEN T2.`Median Income` < 30000 THEN T1.Region END AS T FROM Regions T1 INNER JOIN `Store Locations` T2 ON T2.StateCode = T1.StateCode ) WHERE T IS NOT NULL

Database: car_retails
Question: Who is the sales agent of the customer who has made the highest payment? Include the full names of employee and his/her supervisor.
Evidence: payment refers to amount; full name = firstName+lastName; supervisor refers to reportsTO; 'reportsTO' is the leader of the 'employeeNumber';
SQL: SELECT T1.firstName, T1.lastName, T1.reportsTo FROM employees AS T1 INNER JOIN customers AS T2 ON T1.employeeNumber = T2.salesRepEmployeeNumber INNER JOIN payments AS T3 ON T2.customerNumber = T3.customerNumber ORDER BY T3.amount DESC LIMIT 1

Database: movies_4
Question: Provide the average revenue of all the French movies.
Evidence: French movies refers to country_name = 'France'; average revenue = AVG(revenue)
SQL: SELECT AVG(T1.revenue) FROM movie AS T1 INNER JOIN production_COUNTry AS T2 ON T1.movie_id = T2.movie_id INNER JOIN COUNTry AS T3 ON T2.COUNTry_id = T3.COUNTry_id WHERE T3.COUNTry_name = 'France'

Database: public_review_platform
Question: Find out which business is opened for 24/7 and list out what is the business attribute.
Evidence: opened for 24/7 refers to Business_Hours WHERE opening_time = closing_time and business_id COUNT(day_id) = 7; business attribute refers to attribute_name
SQL: SELECT T5.attribute_name FROM Business_Hours AS T1 INNER JOIN Days AS T2 ON T1.day_id = T2.day_id INNER JOIN Business AS T3 ON T1.business_id = T3.business_id INNER JOIN Business_Attributes AS T4 ON T3.business_id = T4.business_id INNER JOIN Attributes AS T5 ON T4.attribute_id = T5.attribute_id WHERE T2.day_id LIKE '1' AND '2' AND '3' AND '4' AND '5' AND '6' AND '7' AND T1.opening_time = T1.closing_time GROUP BY T5.attribute_name

Database: books
Question: Indicate the title of the six books with the greatest potential value as collectibles.
Evidence: greatest potential value refers to Min(publication_date)
SQL: SELECT title FROM book ORDER BY publication_date ASC LIMIT 6