Database: world_development_indicators
Question: Which country has the highest value of Merchandise imports by the reporting economy (current US$)?
Evidence: country refers to CountryName; the highest value implies MAX(Value); IndicatorName = 'Merchandise imports by the reporting economy (current US$)';
SQL: SELECT CountryName FROM Indicators WHERE IndicatorName = 'Merchandise imports by the reporting economy (current US$)' ORDER BY Value DESC LIMIT 1

Database: public_review_platform
Question: How many businesses in AZ state do not open on Thursday?
Evidence: do not open on Thursday refers to day_of_week = 'Thursday' AND label_time_4 = 'None';
SQL: SELECT COUNT(T1.business_id) FROM Business AS T1 INNER JOIN Checkins AS T2 ON T1.business_id = T2.business_id INNER JOIN Days AS T3 ON T2.day_id = T3.day_id WHERE T2.label_time_4 LIKE 'None' AND T1.state LIKE 'AZ' AND T3.day_of_week LIKE 'Thursday'

Database: music_platform_2
Question: What is the name of the podcast in which a commentor left a comment with the title 'Long time listener, calling it quits?' Include the URL of the podcast as well.
Evidence: comment refers to review; 'Long time listener, calling it quits' is the title of review;  name of the podcast refers to title of podcast; URL refers to itunes_url
SQL: SELECT podcast_id, itunes_url FROM podcasts WHERE podcast_id = ( SELECT podcast_id FROM reviews WHERE title = 'Long time listener, calling it quits' )

Database: authors
Question: How many of the papers are preprinted or not published?
Evidence: preprinted or not published refers to Year = 0
SQL: SELECT COUNT(Id) FROM Paper WHERE Year = 0

Database: bike_share_1
Question: List out all stations name that having a mean temperature 20 degree Celsius in year 2014.
Evidence: mean temperature refers to mean_temperature_f; mean temperature of 20 degree Celsius refers to DIVIDE(SUBTRACT(mean_temperature_f, 32), 1.8) = 20; in 2014 refers to date LIKE'%2015%';
SQL: SELECT DISTINCT T2.start_station_name, T2.end_station_name FROM weather AS T1 INNER JOIN trip AS T2 ON T1.zip_code = T2.zip_code WHERE T1.date LIKE '%2014' AND T1.mean_temperature_f = 20 * 1.8 + 32

Database: coinmarketcap
Question: Name the coin and date of transactions with the greatest decline in percent change in 1 hour.
Evidence: the greatest decline in percent change in 1 hour refers to max(percent_change_1h)
SQL: SELECT T1.name, T2.date FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T2.percent_change_1h = ( SELECT MIN(percent_change_1h) FROM historical )

Database: chicago_crime
Question: What are the neighborhoods that are located in the North Center community area?
Evidence: "North Center" is the community_area_name; neighborhoods refers to neighborhood_name
SQL: SELECT T2.neighborhood_name FROM Community_Area AS T1 INNER JOIN Neighborhood AS T2 ON T1.community_area_no = T2.community_area_no WHERE T1.community_area_name = 'North Center'

Database: donor
Question: Which donor has donated the most for a project whose main subject area is Literacy & Language? Please give his or her ID.
Evidence: main subject area refers to primary_focus_area = 'Literacy & Language'; donated the most refers to Max(donation_total);
SQL: SELECT T2.donor_acctid FROM projects AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T1.primary_focus_area = 'Literacy & Language' ORDER BY T2.donation_total DESC LIMIT 1

Database: retail_world
Question: What are the the total number of territory in each region?
SQL: SELECT COUNT(TerritoryDescription) FROM Territories WHERE RegionID IN (1, 2, 3, 4) GROUP BY RegionID

Database: menu
Question: List down the image IDs for menu located at Manhattan Hotel.
Evidence: located at Manhattan Hotel refers to location = 'Manhattan Hotel';
SQL: SELECT T1.image_id FROM MenuPage AS T1 INNER JOIN Menu AS T2 ON T2.id = T1.menu_id WHERE T2.location = 'Manhattan Hotel'

Database: regional_sales
Question: How many sales team were from Northeast?
Evidence: Northeast is the name of the region;
SQL: SELECT SUM(CASE WHEN Region = 'Northeast' THEN 1 ELSE 0 END) FROM `Sales Team`

Database: language_corpus
Question: List out the title of Catalan language Wikipedia page that has wikipedia revision page id as 106601.
Evidence: Wikipedia revision page id as 106601 refers to revision = 106601;
SQL: SELECT title FROM pages WHERE revision = 106601

Database: movies_4
Question: List down the movie titles that were produced in Canada.
Evidence: produced in Canada refers to country_name = 'Canada'
SQL: SELECT T1.title 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 = 'Canada'

Database: retail_complains
Question: What is the percentage of the increase of complaints filed by the clients from New York from the year 2016 to the year 2017?
Evidence: percentage of increase = MULTIPLY(DIVIDE(SUBTRACT(SUM(year("Date received") = 2017), SUM(year("Date received") = 2016)), SUM(year("Date received") = 2016)), 1.0); New York refers to city = 'New York'; year("Date received") BETWEEN 2016 AND 2017;
SQL: SELECT 100.0 * (SUM(CASE WHEN strftime('%Y', T2.`Date received`) = '2017' THEN 1 ELSE 0 END) - SUM(CASE WHEN strftime('%Y', T2.`Date received`) = '2016' THEN 1 ELSE 0 END)) / SUM(CASE WHEN strftime('%Y', T2.`Date received`) = '2016' THEN 1 ELSE 0 END) FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T1.city = 'New York City'

Database: talkingdata
Question: Please provide the age group of any LG Nexus 4 device users.
Evidence: age group refers to `group`; LG Nexus 4 refers to phone_brand = 'LG' AND device_model = 'Nexus 4';
SQL: SELECT T1.`group` FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.phone_brand = 'LG' AND T2.device_model = 'Nexus 4'

Database: restaurant
Question: List all counties where there is no Bakers Square Restaurant & Pie Shop.
Evidence: no Bakers Square Restaurant & Pie Shop refers to label <> 'bakers square restaurant & pie shop'
SQL: SELECT DISTINCT T2.county FROM generalinfo AS T1 INNER JOIN geographic AS T2 ON T1.city = T2.city WHERE T1.label != 'bakers square restaurant & pie shop'

Database: movie_3
Question: Please list the titles of the films that are released in 2006 and have a rental rate of $2.99.
Evidence: released in 2006 refers to release_year = 2006; rental rate of $2.99 refers to rental_rate = 2.99
SQL: SELECT title FROM film WHERE release_year = 2006 AND rental_rate = 2.99

Database: legislator
Question: List the full names, Twitter IDs, and YouTube IDs of legislators who have Richard as their first name.
Evidence: full names refers to official_full_name; Richard as their first name refers to first_name = 'Richard'
SQL: SELECT T2.official_full_name, T1.twitter_id, T1.youtube_id FROM `social-media` AS T1 INNER JOIN current AS T2 ON T1.bioguide = T2.bioguide_id WHERE T2.first_name = 'Richard'

Database: retail_world
Question: List the names of non-US suppliers that have discontinued.
Evidence: non-US refers to Country <> 'USA'; discontinued refers to Discontinued = 1
SQL: SELECT DISTINCT T2.CompanyName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.Discontinued = 1 AND T2.Country != 'USA'

Database: restaurant
Question: Please name any three restaurants that have an unidentified region.
Evidence: restaurant name refers to label; unidentified region refers to region = 'unknown'
SQL: SELECT T2.label FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant INNER JOIN geographic AS T3 ON T2.city = T3.city WHERE T3.region = 'unknown' LIMIT 3