Database: shipping
Question: Please list the destination cities of all the shipments ordered by S K L Enterprises Inc.
Evidence: "S K L Enterprises Inc" is the cust_name; destination cities refers to city_name
SQL: SELECT DISTINCT T3.city_name FROM customer AS T1 INNER JOIN shipment AS T2 ON T1.cust_id = T2.cust_id INNER JOIN city AS T3 ON T3.city_id = T2.city_id WHERE T1.cust_name = 'S K L Enterprises Inc'

Database: regional_sales
Question: How many sales teams are there in the Midwest?
Evidence: "Midwest" is the Region
SQL: SELECT SUM(CASE WHEN Region = 'Midwest' THEN 1 ELSE 0 END) FROM `Sales Team`

Database: simpson_episodes
Question: What is the average height of people from USA?
Evidence: people from USA refers to birth_country = 'USA'; average height = AVG(height_meters)
SQL: SELECT AVG(height_meters) FROM Person WHERE birth_country = 'USA';

Database: student_loan
Question: How many male students have no due payments?
Evidence: have no due payments refers to bool = 'neg';
SQL: SELECT COUNT(T1.name) FROM no_payment_due AS T1 INNER JOIN male AS T2 ON T1.name = T2.name WHERE T1.bool = 'neg'

Database: public_review_platform
Question: Does Yelp business No."11825" have a "parking lot"?
Evidence: business No."11825" refers to business_id = '12476'; have a "parking lot" refers to attribute_value = 'parking_lot'
SQL: SELECT T1.attribute_value FROM Business_Attributes AS T1 INNER JOIN Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T1.business_id = 11825 AND T2.attribute_name = 'parking_lot'

Database: food_inspection_2
Question: What is the point level of "Refrigeration and metal stem thermometers provided and conspicuous"?
Evidence: "Refrigeration and metal stem thermometers provided and conspicuous" refers to Description = 'Refrigeration and metal stem thermometers provided and conspicuous '
SQL: SELECT point_level FROM inspection_point WHERE Description = 'Refrigeration and metal stem thermometers provided and conspicuous '

Database: language_corpus
Question: How many appearances does the word ID No. 2823 have in the Wikipedia page "Astre"?
Evidence: Astre refers to title = 'Astre'; word ID No. 2823 refers to wid = 2823; appearances refers to pages_words_sampling.occurrences
SQL: SELECT SUM(T2.occurrences) FROM pages AS T1 INNER JOIN pages_words AS T2 ON T1.pid = T2.pid WHERE T1.title = 'Astre' AND T2.wid = 2823

Database: student_loan
Question: What is the status of payment of student 124?
Evidence: status of payment is mentioned in no_payment_due; bool = 'pos' means the student has payment due; bool = 'neg' means the student has no payment due; student124 is a name of student;
SQL: SELECT `bool` FROM no_payment_due WHERE name = 'student124'

Database: address
Question: Based on the population in 2020, calculate the percentage for the population of Asian in the zip code where the CBSA was Atmore, AL.
Evidence: "Atmore, AL" is CBSA_name; percentage = Divide(asian_population, population_2020) * 100
SQL: SELECT CAST(T2.asian_population AS REAL) * 100 / T2.population_2010 FROM CBSA AS T1 INNER JOIN zip_data AS T2 ON T1.CBSA = T2.CBSA WHERE T1.CBSA_name = 'Atmore, AL'

Database: coinmarketcap
Question: Which crytocurrency was ranked the first by CoinMarketCap on 2013/4/28?
Evidence: ranked the first refers to cmc_rank = 1; on 2013/4/28 refers to date = '2013-04-28'
SQL: SELECT T1.name FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T2.date = '2013-04-28' AND T2.cmc_rank = 1

Database: movie_3
Question: Which film has a higher replacement cost, ACE GOLDFINGER or ACADEMY DINOSAUR?
Evidence: higher replacement cost refers to Max(replacement_cost); 'ACE GOLDFIINGER' and 'ACADEMY DINOSAUR' are both the title of film
SQL: SELECT title FROM film WHERE title IN ('ACE GOLDFINGER', 'ACADEMY DINOSAUR') ORDER BY replacement_cost DESC LIMIT 1

Database: college_completion
Question: Among the race of all students, what is the control of institution and level of institution with highest number of students?
Evidence: highest number of students refers to student_count; all students refer to race = 'X'.
SQL: SELECT DISTINCT T1.control, T1.level FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T2.race = 'X' AND T1.student_count = ( SELECT MAX(T1.student_count) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T2.race = 'X' )

Database: student_loan
Question: Please provide a disability breakdown for each school.
Evidence: disability breakdown refers to the number of disabled students;
SQL: SELECT COUNT(T1.name) FROM enrolled AS T1 INNER JOIN disabled AS T2 ON T2.name = T1.name GROUP BY T1.school

Database: retail_complains
Question: What is the detailed product of the complaint filed by Diesel Galloway on 2014/7/3?
Evidence: detailed product refers to "sub-product"; on 2014/7/3 refers to "Date received" = '2014-07-03';
SQL: SELECT T2.`Sub-product` FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T1.first = 'Diesel' AND T1.last = 'Galloway' AND T2.`Date received` = '2014-07-03'

Database: student_loan
Question: How many bankrupt students are there in the Marines?
Evidence: Marines refers to organ = 'marines';
SQL: SELECT COUNT(T1.name) FROM filed_for_bankrupcy AS T1 INNER JOIN enlist AS T2 ON T1.name = T2.name WHERE T2.organ = 'marines'

Database: food_inspection_2
Question: How many inspections were sanitarian Joshua Rosa responsible for in 2010?
Evidence: in 2010 refers to inspection_date like '2010%'
SQL: SELECT COUNT(T2.inspection_id) FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE strftime('%Y', T2.inspection_date) = '2010' AND T1.first_name = 'Joshua' AND T1.last_name = 'Rosa'

Database: shakespeare
Question: How many scenes are there in King John?
Evidence: King John refers to Title = 'King John'
SQL: SELECT COUNT(T2.Scene) FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T1.Title = 'King John'

Database: retails
Question: Calculate the total price of orders by Customer#000000013.
Evidence: Customer#000000013 is the name of the customer which refers to c_name;
SQL: SELECT SUM(T1.o_totalprice) FROM orders AS T1 INNER JOIN customer AS T2 ON T1.o_custkey = T2.c_custkey WHERE T2.c_name = 'Customer#000000013'

Database: movie_platform
Question: Between 1/1/2017 to 12/31/2017, how many users who were eligible for trial when they rated the movie "Patti Smith: Dream of Life"and what is the image URL to the movie on Mubi?
Evidence: Between 1/1/2017 to 12/31/2017 refers to rating_timestamp_utc between '2017-01-01 00:00:00' and '2017-12-31 00:00:00'; eligible for trial refers to user_eligible_for_trial = 1; movie "Patti Smith: Dream of Life" refers to movie_title = 'Patti Smith: Dream of Life'
SQL: SELECT COUNT(T1.user_id), T2.movie_image_url FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE datetime(T1.rating_timestamp_utc) BETWEEN '2017-01-01 00:00:00' AND '2017-12-31 00:00:00'

Database: beer_factory
Question: What is the average review given by a subscriber?
Evidence: average review = AVG(StarRating); subscriber refers to SubscribedToEmailList = 'TRUE';
SQL: SELECT AVG(T2.StarRating) FROM customers AS T1 INNER JOIN rootbeerreview AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.SubscribedToEmailList = 'TRUE'

Database: books
Question: What is the average number of pages in the books written by Jennifer Crusie?
Evidence: "Jennifer Crusie" is the author_name; average number of pages refers to AVG(num_pages)
SQL: SELECT AVG(T1.num_pages) FROM book AS T1 INNER JOIN book_author AS T2 ON T1.book_id = T2.book_id INNER JOIN author AS T3 ON T3.author_id = T2.author_id WHERE T3.author_name = 'Jennifer Crusie'