Database: book_publishing_company
Question: Name the title and publisher for title ID BU 2075. Provide all the royalty percentage for all ranges.
Evidence: name the publisher refers to pub_name
SQL: SELECT T1.title, T3.pub_name, T2.lorange, T2.hirange, T2.royalty FROM titles AS T1 INNER JOIN roysched AS T2 ON T1.title_id = T2.title_id INNER JOIN publishers AS T3 ON T1.pub_id = T3.pub_id WHERE T1.title_id = 'BU2075'

Database: student_loan
Question: What is the name of the organization which most of the students are enlisted in?
Evidence: name of the organization refers to organ; organization which most of the students are enlisted in refers to MAX(COUNT(organ));
SQL: SELECT organ FROM ( SELECT organ, COUNT(organ) AS num FROM enlist GROUP BY organ ) T ORDER BY T.num DESC LIMIT 1

Database: craftbeer
Question: What is the average alcohol content per 12-ounce beer bottle produced by Boston Beer Company?
SQL: SELECT AVG(T1.abv) FROM beers AS T1 INNER JOIN breweries AS T2 ON T1.brewery_id = T2.id WHERE T2.name = 'Boston Beer Company' AND T1.ounces = 12

Database: european_football_1
Question: Of all the divisions in the world, what percentage of them belong to England?
Evidence: DIVIDE(COUNT(division where country = 'England'), COUNT(division)) as percentage;
SQL: SELECT CAST(COUNT(CASE WHEN country = 'England' THEN division ELSE NULL END) AS REAL) * 100 / COUNT(division) FROM divisions

Database: beer_factory
Question: On average how many caffeinated root beers are sold a day?
Evidence: average = DIVIDE(COUNT(RootBeerID WHERE Caffeinated = 'TRUE'), COUNT(PurchaseDate)); caffeinated refers to Caffeinated = 'TRUE';
SQL: SELECT CAST(COUNT(T2.RootBeerID) AS REAL) / COUNT(DISTINCT T2.PurchaseDate) FROM rootbeerbrand AS T1 INNER JOIN rootbeer AS T2 ON T1.BrandID = T2.BrandID INNER JOIN `transaction` AS T3 ON T2.RootBeerID = T3.RootBeerID WHERE T1.Caffeinated = 'TRUE'

Database: chicago_crime
Question: List the report number of crimes reported in a community area in the far north side with a population greater than 60,000.
Evidence: report number refers to report_no; the far north side refers to side = 'Far North'; population greater than 60,000 refers to population > '60000'
SQL: SELECT SUM(CASE WHEN T1.population > 60000 THEN 1 ELSE 0 END) FROM Community_Area AS T1 INNER JOIN Crime AS T2 ON T2.community_area_no = T1.community_area_no WHERE T1.side = 'Far North '

Database: legislator
Question: List the IDs and full names of legislators from the Liberal Republican party.
Evidence: full_name refers to first_name, last_name; from the Liberal Republican party refers to party = 'Liberal Republican'
SQL: SELECT T2.bioguide_id, T2.first_name, T2.last_name FROM `historical-terms` AS T1 INNER JOIN historical AS T2 ON T2.bioguide_id = T1.bioguide WHERE T1.party = 'Liberal Republican'

Database: food_inspection_2
Question: Who is the employee that receives 82700 as their salary?
Evidence: employee name refers to first_name, last_name; receives 82700 as salary refers to salary = 82700
SQL: SELECT first_name, last_name FROM employee WHERE salary = 82700

Database: public_review_platform
Question: What is the total number of active business in AZ with a high review count?
Evidence: active business refers to active = 'true'; 'AZ' is the state; high review count refers to review_count = 'High'
SQL: SELECT COUNT(business_id) FROM Business WHERE state LIKE 'AZ' AND review_count LIKE 'High' AND active LIKE 'True'

Database: retail_world
Question: Name the products where the suppliers come from Finland.
Evidence: 'Finland' is a Country; product refers to ProductName; suppliers refers to SupplierID
SQL: SELECT T1.ProductName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.Country = 'Finland'

Database: car_retails
Question: Which is the most ordered quantity product? What is its expected profit margin per piece?
Evidence: The most ordered quantity product refers to productName where Max(quantityOrdered); SUBTRACT(MSRP, buyPrice);
SQL: SELECT productName, MSRP - buyPrice FROM products WHERE productCode = ( SELECT productCode FROM orderdetails ORDER BY quantityOrdered DESC LIMIT 1 )

Database: authors
Question: How many times more for the papers that were presented at the "International Conference on Thermoelectrics" conference than "International Conference on Wireless Networks, Communications and Mobile Computing“ conference?
Evidence: 'International Conference on Thermoelectrics' AND 'International Conference on Wireless Networks, Communications and Mobile Computing' are the FullName of the conference; Papers refers to Paper.Id; Calculation = SUBTRACT(SUM(Paper.Id where FullName = 'International Conference on Thermoelectrics'), SUM(Paper.Id where FullName = 'International Conference on Wireless Networks, Communications and Mobile Computing'))
SQL: SELECT CAST(SUM(CASE WHEN T2.FullName = 'International Conference on Thermoelectrics' THEN 1 ELSE 0 END) AS REAL) / SUM(CASE WHEN T2.FullName = 'International Conference on Wireless Networks, Communications and Mobile Computing' THEN 1 ELSE 0 END) FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id

Database: donor
Question: Please provide the type of resource that donation "b39547f29dfc25fb13c6e9e8d940dc43" contain.
Evidence: donation "b39547f29dfc25fb13c6e9e8d940dc43" refers to donationid = 'b39547f29dfc25fb13c6e9e8d940dc43'; type of resource refers to project_resource_type;
SQL: SELECT DISTINCT T1.project_resource_type FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid INNER JOIN donations AS T3 ON T2.projectid = T3.projectid WHERE T3.donationid LIKE 'b39547f29dfc25fb13c6e9e8d940dc43'

Database: music_tracker
Question: Name all the release titles of the "ep's" under the alternative tag.
Evidence: release titles of the "ep's" refer to groupName where releaseType = 'ep';
SQL: SELECT T1.groupName FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T2.tag LIKE 'alternative' AND T1.releaseType = 'ep'

Database: coinmarketcap
Question: List the names of coins that cannot be traded in 2014.
Evidence: cannot be tracked refers to status = 'untracked'; in 2014 refers to year(date_added) = '2014'
SQL: SELECT name FROM coins WHERE date_added LIKE '2014%' AND status = 'untracked'

Database: retail_complains
Question: Calculate the average age of clients whose response is "Closed with relief".
Evidence: average age = avg(age where Company response to consumer = 'Closed with relief'); response "Closed with relief" refers to Company response to consumer = 'Closed with relief'
SQL: SELECT AVG(T1.age) FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.`Company response to consumer` = 'Closed with relief'

Database: college_completion
Question: How many institutes are private and not-for profit?
Evidence: private and not for profit refers to control = 'Private not-for-profit';
SQL: SELECT COUNT(*) FROM institution_details WHERE control = 'Private not-for-profit'

Database: student_loan
Question: List the names of the disabled students who were absent from school for more than 5 months.
Evidence: absent for more than 5 months refers to month > 5;
SQL: SELECT T1.name FROM longest_absense_from_school AS T1 INNER JOIN disabled AS T2 ON T1.name = T2.name WHERE T1.month > 5

Database: movie_platform
Question: How many critics of the movie "Imitation of Life" got more than 1 like?
Evidence: Imitation of Life refers to movie_title; critics got more than 1 like refers to critic_likes >1;
SQL: SELECT COUNT(*) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Imitation of Life' AND T1.critic_likes > 1