Database: software_company
Question: Calculate the number of customers who did not respond in February of 2007.
Evidence: did not respond refers to RESPONSE = 'false'; February of 2007 refers to REF_DATE BETWEEN '2007-02-01 12:00:00.0'AND '2007-02-28 12:00:00.0';
SQL: SELECT COUNT(REFID) custmoer_number FROM Mailings1_2 WHERE RESPONSE = 'false' AND REF_DATE BETWEEN '2007-02-01' AND '2007-02-28'

Database: citeseer
Question: Name the paper which is cited most times and the paper which is cited least times? Also, find the number of times each one is cited.
SQL: SELECT cited_paper_id, COUNT(cited_paper_id), ( SELECT cited_paper_id FROM cites GROUP BY cited_paper_id ORDER BY COUNT(cited_paper_id) ASC LIMIT 1 ), ( SELECT COUNT(cited_paper_id) FROM cites GROUP BY cited_paper_id ORDER BY COUNT(cited_paper_id) ASC LIMIT 1 ) FROM cites GROUP BY cited_paper_id ORDER BY COUNT(cited_paper_id) DESC LIMIT 1

Database: student_loan
Question: What is the longest students absence duration from school?
Evidence: longest students absence duration MAX(month)
SQL: SELECT name, month FROM longest_absense_from_school WHERE `month` = ( SELECT MAX(month) FROM longest_absense_from_school )

Database: chicago_crime
Question: Among the crimes, what percentage are severe?
Evidence: severe refers to index_code = 'I'; percentage = divide(count(iucr_no where index_code = 'I'), count(iucr_no)) * 100%
SQL: SELECT CAST(COUNT(CASE WHEN index_code = 'I' THEN iucr_no ELSE NULL END) AS REAL) * 100 / COUNT(iucr_no) FROM IUCR

Database: movie_platform
Question: Who is the director of the movie Sex, Drink and Bloodshed?
Evidence: Sex, Drink and Bloodshed refers to movie title = 'Sex, Drink and Bloodshed';
SQL: SELECT director_name FROM movies WHERE movie_title = 'Sex, Drink and Bloodshed'

Database: movie_3
Question: Among all the films starring PENELOPE GUINESS, what is the title of the one with the highest rental price per day?
Evidence: highest rental price per day refers to Max(Divide(rental_rate, rental_duration))
SQL: SELECT T3.title FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T1.first_name = 'PENELOPE' AND T1.last_name = 'GUINESS' ORDER BY T3.rental_rate / T3.rental_duration DESC LIMIT 1

Database: movie_platform
Question: What is the average number of Mubi users who love movies directed by Stanley Kubrick?
Evidence: average = AVG(movie_popularity); number of Mubi users who loves the movie refers to movie_popularity;
SQL: SELECT AVG(movie_popularity) FROM movies WHERE director_name = 'Stanley Kubrick'

Database: movie_platform
Question: How many movies did the director of the highest movie popularity make?
Evidence: highest movie popularity refers to MAX(movie_popularity)
SQL: SELECT COUNT(movie_id) FROM movies WHERE director_id = ( SELECT director_id FROM movies ORDER BY movie_popularity DESC LIMIT 1 )

Database: legislator
Question: How many legislators hold the title "Majority Leader"?
SQL: SELECT COUNT(bioguide) FROM `current-terms` WHERE title = 'Majority Leader'

Database: world_development_indicators
Question: What is the note for Australia on the indicator SP.ADO.TFRT?
Evidence: note refers to Description; for Australia refers to ShortName = 'Australia'; indicator SP.ADO.TFRT refers to Seriescode = 'SP.ADO.TFRT'
SQL: SELECT T2.Description FROM Country AS T1 INNER JOIN CountryNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T2.Seriescode = 'SP.ADO.TFRT' AND T1.ShortName = 'Australia'

Database: chicago_crime
Question: Among the incidents in January, 2018, how many of them were stated "against Property" in the FBI classification?
Evidence: in January 2018 refers to Substr(date, 1, 1) = '1' AND Substr(date, 5, 4) = '2018'; against property refers to crime_against = 'Property'
SQL: SELECT SUM(CASE WHEN SUBSTR(T2.date, 5, 4) = '2018' THEN 1 ELSE 0 END) FROM FBI_Code AS T1 INNER JOIN Crime AS T2 ON T1.fbi_code_no = T2.fbi_code_no WHERE T1.crime_against = 'Property' AND SUBSTR(T2.date, 1, 1) = '1'

Database: public_review_platform
Question: What is the attribute of the business with highest star rating?
Evidence: highest star rating Max(stars); attribute of business refers to attribute_name
SQL: SELECT T3.attribute_name 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 ORDER BY T1.stars DESC LIMIT 1

Database: cars
Question: Calculate the average production rate per year from 1971 to 1980. Among them, name the cars with a weight of fewer than 1800 lbs.
Evidence: from 1971 to 1980 refers to model_year between 1971 and 1980; average production rate per year = divide(count(ID where model_year between 1971 and 1980), 9); car's name refers to car_name; a weight of fewer than 1800 lbs refers to weight < 1800
SQL: SELECT CAST(COUNT(T1.ID) AS REAL) / 9 FROM production AS T1 INNER JOIN data AS T2 ON T2.ID = T1.ID WHERE T1.model_year BETWEEN 1971 AND 1980 UNION ALL SELECT DISTINCT T2.car_name FROM production AS T1 INNER JOIN data AS T2 ON T2.ID = T1.ID WHERE T1.model_year BETWEEN 1971 AND 1980 AND T2.weight < 1800

Database: app_store
Question: What is the rating for "Draw A Stickman"?
Evidence: Draw A Stickman refers to App = 'Draw A Stickman';
SQL: SELECT Rating FROM playstore WHERE APP = 'Draw A Stickman'

Database: simpson_episodes
Question: Which character won the Outstanding Voice-Over Performance award in 2009?
Evidence: won refers to result = 'Winner'
SQL: SELECT DISTINCT T1.character FROM Character_Award AS T1 INNER JOIN Award AS T2 ON T1.award_id = T2.award_id WHERE T2.award = 'Outstanding Voice-Over Performance' AND T2.year = 2009 AND T2.result = 'Winner';

Database: regional_sales
Question: In the Northeast region, what is the average household income for each city located in the state with the highest number of stores?
Evidence: average household income = Divide (Sum(Household Income), Count(City Name)); highest number of store refers to Max(Count(StoreID))
SQL: SELECT AVG(T2.`Household Income`) FROM Regions AS T1 INNER JOIN `Store Locations` AS T2 ON T2.StateCode = T1.StateCode WHERE T1.Region = 'Northeast' GROUP BY T2.State ORDER BY COUNT(T2.StoreID) DESC LIMIT 1

Database: shakespeare
Question: Give the title of the work that contains the character "Shylock".
Evidence: character "Shylock" refers to CharName = 'Shylock'
SQL: SELECT DISTINCT T1.Title FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id INNER JOIN paragraphs AS T3 ON T2.id = T3.chapter_id INNER JOIN characters AS T4 ON T3.character_id = T4.id WHERE T4.CharName = 'Shylock'

Database: authors
Question: Provide the average number of papers that are published in the journal named 'Information Sciences' annually.
Evidence: 'Information Sciences' is the FullName of journal; average = DIVIDE(COUNT(JournalId = 48), COUNT(Years))
SQL: SELECT CAST(COUNT(T2.JournalId) AS REAL) / COUNT(DISTINCT T2.Year) FROM Journal AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.JournalId WHERE T1.FullName = 'Information Sciences'

Database: chicago_crime
Question: What is the FBI description of the crime for report number 23778?
Evidence: "23778" is the report_no; FBI description refers to description
SQL: SELECT T1.description FROM FBI_Code AS T1 INNER JOIN Crime AS T2 ON T1.fbi_code_no = T2.fbi_code_no WHERE T2.report_no = 23843

Database: student_loan
Question: List any five female students' names who enlisted for the air force.
Evidence: female students refers to enlist.name who are NOT in male.name; air force refers to organ = 'air_force';
SQL: SELECT T1.name FROM enlist AS T1 LEFT JOIN male AS T2 ON T2.name = T1.name WHERE T2.name IS NULL AND T1.organ = 'air_force' LIMIT 5