Database: bike_share_1
Question: What is the difference between the hottest temperature and the coldest temperature in in Fahrenheit on 8/29/2013 for the area where the zip code is 94107?
Evidence: hottest temperature refers to max_temperatutre_f; coldest temperature refers to min_temperature_f; difference = SUBTRACT(max_temperature_f, min_temperature_f); date = '8/29/2013'
SQL: SELECT SUM(IIF(zip_code = 94107 AND date = '8/29/2013', max_temperature_f - min_temperature_f, 0)) FROM weather

Database: music_platform_2
Question: What is the percentage of the podcast that are categorized in four or more categories?
Evidence: categorized in 4 or more refers to Count(category) > 4; percentage = Divide(Count(podcast_id(count(category) > 4)), Count(podcast_id)) * 100
SQL: SELECT COUNT(T1.podcast_id) FROM ( SELECT podcast_id FROM categories GROUP BY podcast_id HAVING COUNT(category) >= 4 ) AS T1

Database: software_company
Question: List the income and number of inhabitants of customers with an age greater than the 80% of average age of all customers?
Evidence: age greater than the 80% of average age refers to age > (AVG(age) * 0.8); income refers to INCOME_K; number of inhabitants refers to INHABITANTS_K;
SQL: SELECT T2.INCOME_K, T2.INHABITANTS_K FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID GROUP BY T2.INCOME_K, T2.INHABITANTS_K HAVING T1.age > 0.8 * AVG(T1.age)

Database: restaurant
Question: How many cities are located in the Bay Area?
Evidence: the Bay Area refers to region = 'bay area'
SQL: SELECT COUNT(city) FROM geographic WHERE region = 'bay area'

Database: app_store
Question: List out genre that have downloads more than 1000000000.
Evidence: downloads and installs are synonyms; Installs = '1,000,000,000+';
SQL: SELECT Genres FROM playstore WHERE Installs = '1,000,000,000+' GROUP BY Genres

Database: retail_complains
Question: Which city in West North Central has the highest number of customers over the age of 60?
Evidence: in North Central refers to Region = 'North Central'; highest number of customers refers to max(count(client_id)); over the age of 60 refers to age > 60
SQL: SELECT T2.city FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T2.division = 'West North Central' AND T1.age > 60 GROUP BY T2.city ORDER BY COUNT(T2.city) DESC LIMIT 1

Database: movie
Question: What is the average rating of all the movies starring Tom Cruise?
Evidence: starring Tom Cruise refers to name = 'Tom Cruise'; average rating = divide(sum(rating where name = 'Tom Cruise'), count(movieid where name = 'Tom Cruise'))
SQL: SELECT AVG(T1.Rating) FROM movie AS T1 INNER JOIN characters AS T2 ON T1.MovieID = T2.MovieID INNER JOIN actor AS T3 ON T3.ActorID = T2.ActorID WHERE T3.Name = 'Tom Cruise'

Database: human_resources
Question: How many positions have a maximum salary of no more than US$1000,000?
Evidence: maximum salary of no more than US$1000,000 refers to maxsalary < '100000';
SQL: SELECT COUNT(*) FROM position WHERE CAST(REPLACE(SUBSTR(maxsalary, 4), ',', '') AS REAL) < 100000

Database: music_platform_2
Question: List all the podcast title and its itunes url under the 'society-culture' category.
SQL: SELECT T2.title, T2.itunes_url FROM categories AS T1 INNER JOIN podcasts AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.category = 'society-culture'

Database: shipping
Question: What is the average weight of the goods being transported on a single shipment ordered by S K L Enterprises Inc?
Evidence: "S K L Enterprises Inc" is the cust_name; average = Divide (Sum(weight), Count(ship_id))
SQL: SELECT AVG(T2.weight) FROM customer AS T1 INNER JOIN shipment AS T2 ON T1.cust_id = T2.cust_id WHERE T1.cust_name = 'S K L Enterprises Inc'

Database: bike_share_1
Question: How many bikes have been borrowed at San Jose Diridon Caltrain Station on the date and time of 10/20/2013 8:11:01 AM and indicate the station's coordinates.
Evidence: number of bikes that have been borrowed refers to SUM(bikes_available); San Jose Diridon Caltrain Station refers to name = 'San Jose Diridon Caltrain Station'; station's coordinates refers to (lat, long);
SQL: SELECT SUM(T2.bikes_available), T1.long, T1.lat FROM station AS T1 INNER JOIN status AS T2 ON T2.station_id = T1.id WHERE T2.time = '2013/10/20 8:11:01' AND T1.name = 'San Jose Diridon Caltrain Station'

Database: shakespeare
Question: Which of Shakespeare's work has chapter description of "A field near Windsor"?
SQL: SELECT T2.Title FROM chapters AS T1 INNER JOIN works AS T2 ON T1.work_id = T2.id WHERE T1.Description = 'A field near Windsor.'

Database: public_review_platform
Question: What is the attribute value of an active business with a low review count and 3 stars which is located at Goodyear, AZ?
Evidence: active business ID refers to active = 'true'; low review count refers to review_count = 'Low'; 3 stars refers to stars = 3; Goodyear is a city; AZ is a state
SQL: SELECT DISTINCT T2.attribute_value FROM Business AS T1 INNER JOIN Business_Attributes AS T2 ON T1.business_id = T2.business_id INNER JOIN Attributes AS T3 ON T2.attribute_id = T3.attribute_id WHERE T1.state = 'AZ' AND T1.city = 'Goodyear' AND T1.active = 'true' AND T1.stars = 3 AND T1.review_count = 'Low'

Database: legislator
Question: How old was Jr. F. James Sensenbrenner when he first started as a legislator?
Evidence: Jr. F. James Sensenbrenner is an official_full_name; How old refers to SUBTRACT(MIN(start), birthday_bio)
SQL: SELECT CAST(MIN(T2.start) - T1.birthday_bio AS DATE) AS AGE FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.official_full_name = 'F. James Sensenbrenner, Jr.'

Database: world_development_indicators
Question: List down 10 country codes and it's short names.
SQL: SELECT CountryCode, ShortName FROM Country LIMIT 10

Database: books
Question: Give the publisher's name of the books authored by Alan Lee.
Evidence: "Alan Lee" is the author_name; publisher's name refers to publisher_name
SQL: SELECT T4.publisher_name 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 INNER JOIN publisher AS T4 ON T4.publisher_id = T1.publisher_id WHERE T3.author_name = 'Alan Lee' GROUP BY T4.publisher_name

Database: talkingdata
Question: Please list the location coordinates of all the Galaxy Note 2 devices when an event happened.
Evidence: location coordinates = longitude, latitude; Galaxy Note 2 refers to device_model = 'Galaxy Note 2';
SQL: SELECT T1.longitude, T1.latitude FROM events AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.device_model = 'Galaxy Note 2'

Database: public_review_platform
Question: Among the users who received high compliments from other users, which users joined Yelp earliest?
Evidence: high compliments refers to number_of_compliments = ' High'; joined Yelp earliest refers to min(user_yelping_since_year)
SQL: SELECT T2.user_id FROM Users AS T1 INNER JOIN Users_Compliments AS T2 ON T1.user_id = T2.user_id WHERE T2.number_of_compliments = 'High' AND T1.user_yelping_since_year = ( SELECT MIN(user_yelping_since_year) FROM Users )

Database: image_and_language
Question: Give the number of images containing the object sample of "suit".
Evidence: number of images refers to IMG_ID; object sample of "suit" refers to OBJ_CLASS = 'suit'
SQL: SELECT COUNT(T.IMG_ID) FROM ( SELECT T2.IMG_ID FROM OBJ_CLASSES AS T1 INNER JOIN IMG_OBJ AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T1.OBJ_CLASS = 'suit' GROUP BY T2.IMG_ID ) T

Database: authors
Question: How many authors drafted the paper "Subcellular localization of nuclease in barley aleurone"?
Evidence: 'Subcellular localization of nuclease in barley aleurone' is the title of paper
SQL: SELECT COUNT(DISTINCT T2.Name) FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T1.Title = 'Subcellular localization of nuclease in barley aleurone'