Database: donor
Question: What is the most expensive book item? Please provide a short description of projects related to those.
Evidence: book item refers to project_resource_type = 'Books'; most expensive refers to MAX(item_unit_price)
SQL: SELECT T1.item_name, T2.short_description FROM resources AS T1 INNER JOIN essays AS T2 ON T1.projectid = T2.projectid WHERE T1.project_resource_type = 'Books' ORDER BY T1.item_unit_price DESC LIMIT 1

Database: european_football_1
Question: Please list the home teams in the matches of the Bundesliga division that ended with a home victory in the 2021 season.
Evidence: Bundesliga is the name of division; home victory refers to refer to FTR = 'H', where H stands for home victory;
SQL: SELECT DISTINCT T1.HomeTeam FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T1.season = 2021 AND T1.FTR = 'H' AND T2.name = 'Bundesliga'

Database: legislator
Question: What is the middle name of the legislator whose birthday was on 8/24/1956?
Evidence: birthday was on 8/24/1956 refers to birthday_bio = '1956-08-24'
SQL: SELECT middle_name FROM current WHERE birthday_bio = '1956-08-24'

Database: address
Question: Indicate the name of the country with a population greater than 10000 in 2010.
Evidence: population greater than 10000 in 2010 refers to population_2010 > 10000;
SQL: SELECT DISTINCT T1.county FROM country AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.population_2010 > 10000

Database: olympics
Question: How many people have won the gold medal of the event "Rowing Women's Coxed Eights"?
Evidence: won the gold medal refers to medal_name = 'Gold'; event "Rowing Women's Coxed Eights" refers to event_name = 'Rowing Women''s Coxed Eights';
SQL: SELECT COUNT(T1.competitor_id) FROM competitor_event AS T1 INNER JOIN event AS T2 ON T1.event_id = T2.id INNER JOIN medal AS T3 ON T1.medal_id = T3.id WHERE T2.event_name LIKE 'Rowing Women%s Coxed Eights' AND T3.medal_name = 'Gold'

Database: restaurant
Question: How many restaurants in Broadway, Oakland received a review of no more than 3?
Evidence: Broadway refers to street_name = 'broadway';  Oakland refers to city = 'oakland'; a review of no more than 3 refers to review < 3
SQL: SELECT COUNT(T1.id_restaurant) FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.city = T2.city WHERE T1.street_name = 'broadway' AND T2.review < 3 AND T1.city = 'oakland'

Database: olympics
Question: Tell the host city of the 1968 Winter Olympic Games.
Evidence: host city refers to city_name; the 1968 Winter Olympic Games refer to games_name = '1968 Winter';
SQL: SELECT T2.city_name FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id INNER JOIN games AS T3 ON T1.games_id = T3.id WHERE T3.games_name = '1968 Winter'

Database: food_inspection_2
Question: How much is the total fine given to Ron of Japan Inc in its inspection done on February 2014?
Evidence: total fine = sum(fine); Ron of Japan Inc refers to dba_name = 'RON OF JAPAN INC'; on February 2014 refers to inspection_date like '2014-02%'
SQL: SELECT SUM(T3.fine) FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no INNER JOIN violation AS T3 ON T2.inspection_id = T3.inspection_id WHERE strftime('%Y-%m', T2.inspection_date) = '2014-02' AND T1.dba_name = 'RON OF JAPAN INC'

Database: movie_3
Question: Write down the email addresses of active customers who rented between 5/25/2005 at 7:37:47 PM and 5/26/2005 at 10:06:49 AM.
Evidence: email address refers to email; active refers to active = 1; between 5/25/2005 at 7:37:47 PM and 5/26/2005 at 10:06:49 AM refers to rental_date between '2005-5-25 07:37:47' and '2005-5-26 10:06:49'
SQL: SELECT T2.email FROM rental AS T1 INNER JOIN customer AS T2 ON T1.customer_id = T2.customer_id WHERE T1.rental_date BETWEEN '2005-5-25 07:37:47' AND '2005-5-26 10:06:49' AND T2.active = 1

Database: soccer_2016
Question: How many players were born before 10/16/1975, and have a bowling skill of less than 3?
Evidence: born before 10/16/1975 refers to DOB < 1975-10-16; bowling skill of less than 3 refers to Bowling_skill < 3
SQL: SELECT COUNT(*) FROM Player WHERE DOB < '1975-10-16' AND Bowling_skill < 3

Database: retail_world
Question: What are the total products value shipped to Brazil by Speedy Express Company?
Evidence: shipped to Brazil refers to ShipCountry = 'Brazil'; by Speedy Express Company refers to CompanyName = 'Speedy Express'; total products value refers to sum(MULTIPLY(UnitPrice, Quantity))
SQL: SELECT SUM(T2.Quantity * T2.UnitPrice) FROM Orders AS T1 INNER JOIN `Order Details` AS T2 ON T1.OrderID = T2.OrderID INNER JOIN Shippers AS T3 ON T1.ShipVia = T3.ShipperID WHERE T3.CompanyName = 'Speedy Express' AND T1.ShipCountry = 'Brazil'

Database: menu
Question: Among the menus in which the dish "Clear green turtle" had appeared, how many of them used the dollar as their currency?
Evidence: Clear green turtle is a name of dish; dollar as currency refers to currency = 'Dollars';
SQL: SELECT SUM(CASE WHEN T3.currency = 'Dollars' THEN 1 ELSE 0 END) FROM MenuItem AS T1 INNER JOIN MenuPage AS T2 ON T1.menu_page_id = T2.id INNER JOIN Menu AS T3 ON T2.menu_id = T3.id INNER JOIN Dish AS T4 ON T1.dish_id = T4.id WHERE T4.name = 'Clear green turtle'

Database: retail_world
Question: How many orders were shipped by Federal Shipping?
Evidence: Federal Shipping refers to CompanyName = 'Federal Shipping'
SQL: SELECT COUNT(T1.OrderID) FROM Orders AS T1 INNER JOIN Shippers AS T2 ON T1.ShipVia = T2.ShipperID WHERE T2.CompanyName = 'Federal Shipping'

Database: codebase_comments
Question: What is the full comment on the method whose solution path is "bmatzelle_nini\Source\Nini.sln" with a tokenized name of "alias text add alias"?
SQL: SELECT T2.FullComment FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T1.Path = 'bmatzelle_niniSourceNini.sln' AND T2.NameTokenized = 'alias text add alias'

Database: language_corpus
Question: Which word has the most appearances in the Wikipedia page with the title of "Agricultura"? Give the word ID.
Evidence: Agricultura refers to title = 'Agricultura'; the most appearances is MAX(pages_words_sampling.occurrences)
SQL: SELECT T2.wid FROM pages AS T1 INNER JOIN pages_words AS T2 ON T1.pid = T2.pid WHERE T1.title = 'Agricultura' ORDER BY T2.occurrences DESC LIMIT 1

Database: shakespeare
Question: Which character was mentioned in the paragraph "Would he do so, I'ld beg your precious mistress, Which he counts but a trifle."? Give the character name.
Evidence: paragraph "Would he do so, I'ld beg your precious mistress, Which he counts but a trifle."  refers to PlainText = 'Would he do so, I'ld beg your precious mistress, Which he counts but a trifle.'
SQL: SELECT T1.CharName FROM characters AS T1 INNER JOIN paragraphs AS T2 ON T1.id = T2.character_id WHERE T2.PlainText = 'Would he do so, I''ld beg your precious mistress,Which he counts but a trifle.'

Database: student_loan
Question: List at least 5 students who have payment due and are enlisted in Peace Corps organization?
Evidence: have payment due refers to bool = 'pos'; organization refers to organ; organ = 'Peace Corps';
SQL: SELECT T1.name FROM no_payment_due AS T1 INNER JOIN enlist AS T2 ON T2.name = T1.name WHERE T2.organ = 'peace_corps' AND T1.bool = 'pos' LIMIT 5

Database: legislator
Question: List out the first name of legislators who are senior Senator.
Evidence: senior refers to state_rank = 'senior'; only senator has this value 'senior'
SQL: SELECT T1.first_name FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.state_rank = 'senior' GROUP BY T1.first_name