Database: video_games
Question: When was the game titled 3DS Classic Collection released?
Evidence: when refers to release_year; the game titled 3DS Classic Collection refers to game_name = '3DS Classic Collection'
SQL: SELECT T1.release_year FROM game_platform AS T1 INNER JOIN game_publisher AS T2 ON T1.game_publisher_id = T2.id INNER JOIN game AS T3 ON T2.game_id = T3.id WHERE T3.game_name = '3DS Classic Collection'

Database: donor
Question: Among the schools' projects whose donation didn't use account credits redemption,how many schools are public magnet schools?
Evidence: donation didn't use account credits redemption refers to payment_included_acct_credit = 'f'; magnet school refers to school_magnet = 't';
SQL: SELECT COUNT(T1.schoolid) FROM projects AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T1.school_magnet = 't' AND T2.payment_included_acct_credit = 'f'

Database: airline
Question: Provide the air carrier description of the flight with the highest actual elapsed time.
Evidence: highest actual elapsed time refers to MAX(ACTUAL_ELAPSED_TIME);
SQL: SELECT T1.Description FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID ORDER BY T2.ACTUAL_ELAPSED_TIME DESC LIMIT 1

Database: social_media
Question: Write down the tweet text posted from Rawang, Selangor, Malaysia.
Evidence: "Rawang" is the City; "Selangor" is the State; "Malaysia" is the Country
SQL: SELECT T1.text FROM twitter AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID WHERE T2.City = 'Rawang' AND T2.State = 'Selangor' AND T2.Country = 'Malaysia'

Database: retails
Question: How many customers are in the furniture segment?
Evidence: furniture segment refers to c_mktsegment = 'FURNITURE'
SQL: SELECT COUNT(c_custkey) FROM customer WHERE c_mktsegment = 'FURNITURE'

Database: synthea
Question: On what dates did the billable period begin for patients with the last name Dickinson?
Evidence: dates when the billable period begin refers to BILLABLEPERIOD;
SQL: SELECT DISTINCT T2.BILLABLEPERIOD FROM patients AS T1 INNER JOIN claims AS T2 ON T1.patient = T2.PATIENT WHERE T1.last = 'Dickinson'

Database: image_and_language
Question: What is the unique id number identifying the onion object class?
Evidence: unique id number identifying refers to OBJ_CLASS_ID; onion object class refers to OBJ_CLASS = 'onion'
SQL: SELECT OBJ_CLASS_ID FROM OBJ_CLASSES WHERE OBJ_CLASS = 'onion'

Database: retail_world
Question: Give the number of territories in the "Northern" region.
Evidence: "Northern" region refers to RegionDescription = 'Northern'
SQL: SELECT COUNT(T1.TerritoryID) FROM Territories AS T1 INNER JOIN Region AS T2 ON T1.RegionID = T2.RegionID WHERE T2.RegionDescription = 'Northern'

Database: music_platform_2
Question: Write the names of the podcasts in the music category that have a rating greater than 3.
Evidence: music category refers to category = 'music'; rating greater than 3 refers to rating > 3; name of the podcast refers to title
SQL: SELECT DISTINCT T2.title FROM categories AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.category = 'music' AND T2.rating > 3

Database: movie_3
Question: Please list the titles of all the films in the category of "Horror".
Evidence: "Horror" is the name of category
SQL: SELECT T1.title FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T2.category_id = T3.category_id WHERE T3.name = 'Horror'

Database: sales_in_weather
Question: How many items weren't sold in store 2 on 1/1/2012?
Evidence: store no.2 refers to store_nbr = 2; item weren't sold refers to units = 0; on 1/1/2012 refers to date = '2012-01-01'
SQL: SELECT COUNT(item_nbr) FROM sales_in_weather WHERE store_nbr = 2 AND units = 0 AND `date` = '2012-01-01'

Database: video_games
Question: What is the ratio of game sales between North America and Japan?
Evidence: ratio = DIVIDE(SUM(num_sales WHERE region_name = 'North America'), SUM(num_sales WHERE region_name = 'Japan')); North America refers to region_name = 'North America'; Japan refers to region_name = 'Japan';
SQL: SELECT SUM(CASE WHEN T2.region_name = 'North America' THEN T1.num_sales ELSE 0 END) / SUM(CASE WHEN T2.region_name = 'Japan' THEN T1.num_sales ELSE 0 END) FROM region_sales AS T1 INNER JOIN region AS T2 ON T1.region_id = T2.id

Database: ice_hockey_draft
Question: Among the USA players, who has the lightest weight?
Evidence: USA refers to nation = 'USA' ; players refers to PlayerName; lightest weight refers to MIN(weight_in_lbs);

SQL: SELECT T2.PlayerName FROM weight_info AS T1 INNER JOIN PlayerInfo AS T2 ON T1.weight_id = T2.weight WHERE T2.nation = 'USA' ORDER BY T1.weight_in_lbs ASC LIMIT 1

Database: disney
Question: Name the top 5 highest-grossing Disney movies adjusted for inflation. Identify the percentage they contributed to the total of Disney's current gross.
Evidence: The top 5 highest-grossing movies adjusted for inflation refer to MAX(inflation_adjusted_gross)LIMIT 5; DIVIDE(SUM(MAX(inflation_adjusted_gross LIMIT 5)), SUM(inflation_adjusted_gross)) as percentage;
SQL: SELECT SUM(CASE WHEN CAST(REPLACE(trim(inflation_adjusted_gross, '$'), ',', '') AS REAL) > 1236035515 THEN CAST(REPLACE(trim(inflation_adjusted_gross, '$'), ',', '') AS REAL) ELSE 0 END) * 100 / SUM(CAST(REPLACE(trim(inflation_adjusted_gross, '$'), ',', '') AS REAL)) FROM movies_total_gross

Database: world_development_indicators
Question: Write down the description and series code of Benin in year 2005.
Evidence: Benin is the short name of the country; year 2005 refers to Year = 'YR2005';
SQL: SELECT T2.Description, T2.Seriescode FROM Country AS T1 INNER JOIN FootNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T1.TableName = 'Benin' AND T2.Year = 'YR2005'

Database: retail_complains
Question: Who is the owner of the final phone number for the complaints on server "MORIAH" on 9/11/2013?
Evidence: owner refers to first, middle, last; on 9/11/2013 refers to Date received = '2013-09-11'
SQL: SELECT T1.first, T1.middle, T1.last FROM client AS T1 INNER JOIN callcenterlogs AS T2 ON T1.client_id = T2.`rand client` WHERE T2.server = 'MORIAH' AND T2.`Date received` = '2013-09-11'

Database: student_loan
Question: List out the number of students who have the longest duration of absense from school and enlisted in the peace corps.
Evidence: longest duration of absence refers to MAX(month); peace corps refers to organ = 'peace_corps';
SQL: SELECT COUNT(T1.NAME) FROM longest_absense_from_school AS T1 INNER JOIN enlist AS T2 ON T1.name = T2.name WHERE T2.organ = 'peace_corps' ORDER BY T1.month DESC LIMIT 1

Database: legislator
Question: What are the first and last name of the representatives of the house in district 9?
Evidence: representatives refers to type = 'rep';
SQL: SELECT T2.first_name, T2.last_name FROM `historical-terms` AS T1 INNER JOIN historical AS T2 ON T2.bioguide_id = T1.bioguide WHERE T1.district = 9

Database: legislator
Question: List all the Jewish current legislators that had served in Florida.
Evidence: Jewish refers to religion_bio = 'Jewish'; in Florida refers to state = 'FL';
SQL: SELECT T1.first_name, T1.last_name FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.religion_bio = 'Jewish' AND T2.state = 'FL' GROUP BY T1.first_name, T1.last_name

Database: superstore
Question: Who is the customer with an order shipped on March 5, 2013, in the eastern region?
Evidence: Who is the customer refers to Customer Name; shipped on March 5, 2013 refers to "Ship Date" = '2013-03-05'; eastern region refers to Region = 'East'
SQL: SELECT DISTINCT T2.`Customer Name` FROM east_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T1.`Ship Date` = '2013-03-05'

Database: shakespeare
Question: How many scenes are there in work id 7, act 1?
SQL: SELECT COUNT(id) FROM chapters WHERE work_id = 7 AND Act = 1