Database: regional_sales
Question: Describe the customer names and lasting delivery periods for the product of "Bedroom Furniture" by wholesale channel in 2019.
Evidence: delivery period in 2019 means time between placing of an order and the receipt of product and refers to SUBTRACT(DeliveryDate, OrderDate) where SUBSTR(OrderDate, -2 ) = '19'; Sales Channel = 'Wholesale'; Product Name = 'Bedroom Furniture';
SQL: SELECT T1.`Customer Names`, T2.DeliveryDate FROM Customers AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._CustomerID = T1.CustomerID INNER JOIN Products AS T3 ON T3.ProductID = T2._ProductID WHERE T2.`Sales Channel` = 'Wholesale' AND T3.`Product Name` = 'Bedroom Furniture' AND T2.OrderDate LIKE '%/%/19'

Database: college_completion
Question: In the state with the highest number of schools, how many institutions have a percentage of no less than 90 of undergraduates who attend full-time? List all of the institutions' names.
Evidence: highest number of schools refers to MAX(schools_count); percentage of no less than 90 of undergraduates who attend full-time refers to ft_pct > 90; institutions' names refers to chronname;
SQL: SELECT COUNT(t1.unitid), t1.chronname FROM institution_details AS T1 INNER JOIN state_sector_details AS T2 ON t1.state = t2.state WHERE t1.ft_pct > 90 ORDER BY t2.schools_count DESC LIMIT 1

Database: talkingdata
Question: What is the ratio of active and inactive app users of the event ID "58"?
Evidence: ratio = DIVIDE(SUM(is_active = 1), SUM(is_active = 0)); active refers to is_active = 1; inactive refers to is_active = 0;
SQL: SELECT SUM(IIF(is_active = 1, 1, 0)) / SUM(IIF(is_active = 0, 1, 0)) AS per FROM app_events WHERE event_id = 58

Database: simpson_episodes
Question: What is the episode ID that received 2 stars and 9 votes?
Evidence: 2 stars refers to stars = 2; 9 votes refers to votes = 9
SQL: SELECT episode_id FROM Vote WHERE stars = 2 AND votes = 9;

Database: authors
Question: How many papers are published in year 2000 under the conference "SSPR"?
Evidence: SSPR is a ShortName; papers refers to Paper.Id
SQL: SELECT COUNT(T1.Id) FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T1.Year = 2000 AND T2.ShortName = 'SSPR'

Database: app_store
Question: List down app that does not have negative sentiment and give their average rating?
Evidence: doest not have negative sentiment refers to Sentiment! = 'Negative'; average = AVG(Sentiment_Polarity);
SQL: SELECT T1.App, AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment != 'Negative' GROUP BY T1.App

Database: menu
Question: List the dishes included on page number 30 with the least in full height.
Evidence: least in full height refers to MIN(full_height);
SQL: SELECT T3.name FROM MenuPage AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.menu_page_id INNER JOIN Dish AS T3 ON T2.dish_id = T3.id WHERE T1.page_number = 30 ORDER BY T1.full_height DESC, T1.full_height ASC LIMIT 1

Database: computer_student
Question: What is the level of the course with the most number of teachers?
Evidence: level of the course refers to courseLevel; course with most number of teachers refers to course_id = max(count(taughtBy.p_id))
SQL: SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T2.course_id ORDER BY COUNT(T2.p_id) DESC LIMIT 1

Database: movies_4
Question: What is the original language of the "Four Rooms" movie?
Evidence: language refers to language_name; original language refers to language_role = 'Original'; "Four Rooms" refers to title = 'Four Rooms'
SQL: SELECT T3.language_name FROM movie AS T1 INNER JOIN movie_languages AS T2 ON T1.movie_id = T2.movie_id INNER JOIN language AS T3 ON T2.language_id = T3.language_id INNER JOIN language_role AS T4 ON T2.language_role_id = T4.role_id WHERE T4.language_role = 'Original' AND T1.title = 'Four Rooms'

Database: professional_basketball
Question: Among the Most improved Players awarded from 1985-1990, how many player whose country is USA?
Evidence: the Most improved Player refers to award = 'Most Improved Player'; from 1985-1990 refers to year between 1985 and 1990; country is USA refers to birthCountry = 'USA'
SQL: SELECT COUNT(DISTINCT T2.playerID) FROM awards_players AS T1 INNER JOIN players AS T2 ON T1.playerID = T2.playerID WHERE T1.award = 'Most Improved Player' AND T2.birthCountry = 'USA' AND T1.year BETWEEN 1985 AND 1990

Database: codebase_comments
Question: For the solution of the most 'sw' methods, what is its path?
Evidence: solution refers to SolutionId; sw refers to Lang = 'sw'; solution with the most 'sw' methods refers to MAX(COUNT(Lang = 'sw'));
SQL: SELECT DISTINCT T1.Path FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.Lang = 'sw'

Database: disney
Question: Who is the hero character of the adventure movie which was released on 2016/3/4?
Evidence: released on 2016/3/4 refers to release_date = '4-Mar-16'; adventure movie refers to genre = 'Adventure' ;
SQL: SELECT T1.hero FROM characters AS T1 INNER JOIN movies_total_gross AS T2 ON T2.movie_title = T1.movie_title WHERE T2.genre = 'Adventure' AND T1.release_date = '4-Mar-16'

Database: synthea
Question: How many Asian female patients take oxaliplatin 5 MG/ML [Eloxatin]?
Evidence: female refers to gender = 'F'; oxaliplatin 5 MG/ML [Eloxatin] refers to medications where DESCRIPTION = 'oxaliplatin 5 MG/ML [Eloxatin]';
SQL: SELECT COUNT(DISTINCT T2.patient) FROM medications AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T1.DESCRIPTION = 'oxaliplatin 5 MG/ML [Eloxatin]' AND T2.race = 'asian' AND T2.gender = 'F'

Database: address
Question: Provide the city where zip code 19019 is located and the alias of that city.
SQL: SELECT T2.city, T1.alias FROM alias AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.zip_code = 19019

Database: retail_complains
Question: What is the email id of clients whose calls were hung?
Evidence: email id refers to email; calls were hung refers to outcome = 'Hang';
SQL: SELECT T1.email FROM client AS T1 INNER JOIN callcenterlogs AS T2 ON T1.client_id = T2.`rand client` WHERE T2.outcome = 'HANG'

Database: shipping
Question: How many shipments with weight of no more than 1,000 pounds were shipped by the oldest truck?
Evidence: weight of no more than 1000 pounds refers to weight < 1000; oldest truck refers to Min (model_year)
SQL: SELECT COUNT(*) FROM truck AS T1 INNER JOIN shipment AS T2 ON T1.truck_id = T2.truck_id WHERE T2.weight < 1000 ORDER BY T1.model_year ASC LIMIT 1

Database: retail_complains
Question: What is the product complained by Alexander Bronx Lewis?
SQL: SELECT DISTINCT T2.Product FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T1.first = 'Alexander' AND T1.middle = 'Bronx' AND T1.last = 'Lewis'

Database: movies_4
Question: Provide the homepage of the Bahasa Indonesia movies.
Evidence: Bahasa Indonesia movies refers to language_name = 'Bahasa indonesia'
SQL: SELECT DISTINCT T1.homepage FROM movie AS T1 INNER JOIN movie_languages AS T2 ON T1.movie_id = T2.movie_id INNER JOIN language AS T3 ON T2.language_id = T3.language_id WHERE T3.language_name = 'Bahasa indonesia'

Database: image_and_language
Question: How many images have "keyboard" as their object class?
Evidence: images refer to IMG_ID; "keyboard" as object class refers to OBJ_CLASS = 'keyboard';
SQL: SELECT COUNT(T1.IMG_ID) FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.OBJ_CLASS = 'keyboard'

Database: menu
Question: What dishes made their first and last appearances in 1855 and 1900, respectively?
Evidence: first appearance in 1855 refers to first_appeared = 1855; last appearance in 1900 refers to last_appeared = 1900;
SQL: SELECT name FROM Dish WHERE first_appeared = 1855 AND last_appeared = 1900