Database: movie_platform
Question: What is the user ID of the user, who was a subscriber when he created the list, who created a list for 10 consecutive years? If there are multiple users, indicate each of their user IDs.
Evidence: user was a subscriber when he created the list refers to user_subscriber = 1; user who created a list for 10 consecutive years refers to user_id with list_creation_date_utc for 10 succeeding years;
SQL: SELECT user_id FROM lists_users WHERE user_subscriber = 1 GROUP BY user_id HAVING MAX(SUBSTR(list_creation_date_utc, 1, 4)) - MIN(SUBSTR(list_creation_date_utc, 1, 4)) >= 10

Database: professional_basketball
Question: Among the NBA winning coaches, which are from STL team? Please list their coach id.
Evidence: NBA refers to lgID = 'NBA'; STL team refers to tmID = 'STL'
SQL: SELECT DISTINCT T2.coachID FROM coaches AS T1 INNER JOIN awards_coaches AS T2 ON T1.coachID = T2.coachID WHERE T1.tmID = 'STL' AND T1.lgID = 'NBA'

Database: books
Question: What is the total price of all the books ordered by Lucas Wyldbore?
Evidence: total price refers to Sum(price)
SQL: SELECT SUM(T1.price) FROM order_line AS T1 INNER JOIN cust_order AS T2 ON T2.order_id = T1.order_id INNER JOIN customer AS T3 ON T3.customer_id = T2.customer_id WHERE T3.first_name = 'Lucas' AND T3.last_name = 'Wyldbore'

Database: address
Question: What party does the area with the zip code 91701 belong to?
SQL: SELECT T1.party FROM congress AS T1 INNER JOIN state AS T2 ON T1.abbreviation = T2.abbreviation INNER JOIN zip_data AS T3 ON T2.abbreviation = T3.state WHERE T3.zip_code = 91701 GROUP BY T1.party

Database: sales
Question: Among products bought by Kathryn Ashe, what is the name of the product with the highest quantity?
Evidence: highest quantity refers to MAX(Quantity);
SQL: SELECT T1.Name 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 T3.FirstName = 'Kathryn' AND T3.LastName = 'Ashe' ORDER BY T2.Quantity DESC LIMIT 1

Database: student_loan
Question: What is the number of unemployed and bankrupt students?
SQL: SELECT COUNT(T1.name) FROM unemployed AS T1 INNER JOIN filed_for_bankrupcy AS T2 ON T1.name = T2.name

Database: address
Question: Calculate the percentage of households in residential areas of countries over 10000.
Evidence: DIVIDE(SUM(households > 10000), SUM(households)) as percentage;
SQL: SELECT CAST(COUNT(CASE WHEN T2.households > 10000 THEN T1.zip_code ELSE NULL END) AS REAL) * 100 / COUNT(T1.zip_code) FROM country AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code

Database: student_loan
Question: What is the school and gender of student34?
Evidence: male.name = 'student34' means student34's gender is male; if 'student34' can't be found in 'male.name', it means student34 is female; student34 is a name of student;
SQL: SELECT T1.school , IIF(T3.name IS NULL, 'female', 'male') AS gender FROM enrolled AS T1 INNER JOIN person AS T2 ON T1.name = T2.name LEFT JOIN male AS T3 ON T2.name = T3.name WHERE T2.name = 'student34'

Database: shipping
Question: Tell the name of the driver who received the shipment on 2017/11/5.
Evidence: shipment on 2017/11/5 refers to ship_date = '2017-11/05'; name refers to first_name, last_name
SQL: SELECT T2.first_name, T2.last_name FROM shipment AS T1 INNER JOIN driver AS T2 ON T1.driver_id = T2.driver_id WHERE T1.ship_date = '2017-11-05'

Database: music_platform_2
Question: How many reviews are created for the podcast "Scaling Global" under?
Evidence: "Scaling Global" is the title of podcast
SQL: SELECT COUNT(T2.content) FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.title = 'Scaling Global'

Database: professional_basketball
Question: in which year costela01 obtained the best balance of games won as a coach?
Evidence: "costela01" is the coachID; best balance of game won refers to Max(Divide(won, Sum(won, lost)))
SQL: SELECT year FROM coaches WHERE coachID = 'costela01' ORDER BY CAST(won AS REAL) / (won + lost) DESC LIMIT 1

Database: talkingdata
Question: How many female users belong to the age group of 27 to 28?
Evidence: female refers to gender = 'F'; age group of 27 to 28 refers to `group` = 'F27-28';
SQL: SELECT COUNT(device_id) FROM gender_age WHERE `group` = 'F27-28' AND gender = 'F'

Database: airline
Question: Please list the destination cities of all the flights that were cancelled on 2018/8/1.
Evidence: destination cities refers to DEST; cancelled refers to CANCELLED = 1; on 2018/8/1 refers to FL_DATE = '2018/8/1';
SQL: SELECT DEST FROM Airlines WHERE FL_DATE = '2018/8/1' AND CANCELLED = 1 GROUP BY DEST

Database: public_review_platform
Question: How many Yelp_Business in Arizona has user no. 3 reviewed?
Evidence: in Arizona refers to state = 'AZ'; user no. 3 refers to user_id = 3
SQL: SELECT COUNT(T2.business_id) FROM Reviews AS T1 INNER JOIN Business AS T2 ON T1.business_id = T2.business_id WHERE T2.state LIKE 'AZ' AND T1.user_id = 3

Database: college_completion
Question: Which cohort had the higher percentage of students who graduated from Central Alabama Community College in 2011 within 150 percent of normal/expected time, female White students or male White students?
Evidence: amount of percentage = SUM(grad_150 WHERE gender = 'F') as female; percentage = SUM(grad_150 WHERE gender = 'M') as male; Central Alabama Community College refers to chronname = 'Central Alabama Community College'; in 2011 refers to year = 2011; graduated within 150 percent of normal/expected time refers to grad_150; female refers to gender = 'F'; White refers to race = 'w'; male refers to gender = 'M';
SQL: SELECT IIF(SUM(CASE WHEN T2.gender = 'F' THEN T2.grad_150 ELSE 0 END) > SUM(CASE WHEN T2.gender = 'M' THEN T2.grad_150 ELSE 0 END), 'female White students', 'male White students') FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T1.chronname = 'Central Alabama Community College' AND T2.year = 2011 AND T2.race = 'W'

Database: human_resources
Question: If Jose Rodriguez tried his best, how many percentage can his salary raise without changing his position?
Evidence: Jose Rodriguez is the full name of an employee; full name = firstname, lastname; calculation = DIVIDE(SUBTRACT(maxsalary, salary), salary) * 100
SQL: SELECT 100 * (CAST(REPLACE(SUBSTR(T2.maxsalary, 4), ',', '') AS REAL) - CAST(REPLACE(SUBSTR(T1.salary, 4), ',', '') AS REAL)) / CAST(REPLACE(SUBSTR(T1.salary, 4), ',', '') AS REAL) AS per FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T1.firstname = 'Jose' AND T1.lastname = 'Rodriguez'

Database: restaurant
Question: Give the street number of a bar in Oakland with a 2.7 review.
Evidence: street number refers to street_num; bar refers to food_type = 'bar'; Oakland refers to city = 'oakland'; 2.7 review refers to review = 2.7
SQL: SELECT T2.street_num FROM generalinfo AS T1 INNER JOIN location AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T1.review = 2.7 AND T2.city = 'oakland' AND T1.food_type = 'bar'

Database: retails
Question: How many items that were shipped via air were returned in 1994?
Evidence: items refer to l_linenumber; shipped via air in 1994 refers to year(l_shipdate) = 1994 where l_shipmode = 'AIR'; returned refer to l_returnflag = 'R';
SQL: SELECT COUNT(l_linenumber) FROM lineitem WHERE l_returnflag = 'R' AND l_shipmode = 'AIR' AND STRFTIME('%Y', l_shipdate) = '1994'

Database: airline
Question: What is the airport description of the airport code A11?
SQL: SELECT Description FROM Airports WHERE Code = 'A11'