Database: books
Question: How many books are in English?
Evidence: books in English refers to language_name = 'English'
SQL: SELECT COUNT(*) FROM book AS T1 INNER JOIN book_language AS T2 ON T1.language_id = T2.language_id WHERE T2.language_name = 'English'

Database: public_review_platform
Question: How many open businesses in the City of Phoenix have users left a long review?
Evidence: open businesses refers to active = 'true'; long review refers to review_length = 'Long'
SQL: SELECT COUNT(DISTINCT T2.business_id) FROM Reviews AS T1 INNER JOIN Business AS T2 ON T1.business_id = T2.business_id WHERE T1.review_length = 'Long' AND T2.active = 'true' AND T2.city = 'Phoenix'

Database: language_corpus
Question: Which word has the most repetitions in the Catalan language? Give the ID of the word.
Evidence: word with the most repetitions refers to MAX(occurrences); ID of the word refers to wid
SQL: SELECT wid FROM langs_words WHERE occurrences = ( SELECT MAX(occurrences) FROM langs_words )

Database: retail_world
Question: List the first names of the employees who take the orders that ship to the city of "Reims".
Evidence: ship to the city of "Reims" refers to ShipCity = Reims';
SQL: SELECT DISTINCT T1.FirstName FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T2.ShipCity = 'Reims'

Database: books
Question: What is the full name of the customers who live in Baiyin city?
Evidence: full name refers to first_name, last_name; 'Baiyin' is the city
SQL: SELECT T3.first_name, T3.last_name FROM address AS T1 INNER JOIN customer_address AS T2 ON T1.address_id = T2.address_id INNER JOIN customer AS T3 ON T3.customer_id = T2.customer_id WHERE T1.city = 'Baiyin'

Database: law_episode
Question: How many people, who were born in Canada, won an award in 1999?
Evidence: born in Canada refers to birth_country = 'Canada'; in 1999 refers to year = 1999
SQL: SELECT COUNT(T1.person_id) FROM Person AS T1 INNER JOIN Award AS T2 ON T1.person_id = T2.person_id WHERE T2.year = 1999 AND T1.birth_country = 'Canada'

Database: disney
Question: What are the total grosses for the movies with Jim Cummings as the voice actor?
Evidence: FALSE;
SQL: SELECT T2.movie_title FROM `voice-actors` AS T1 INNER JOIN movies_total_gross AS T2 ON T2.movie_title = T1.movie WHERE T1.`voice-actor` = 'Jim Cummings' ORDER BY CAST(REPLACE(trim(T2.total_gross, '$'), ',', '') AS REAL) DESC LIMIT 1

Database: soccer_2016
Question: How many matches did Mohammad Hafeez play?
Evidence: Mohammad Hafeez refers to Player_Name = 'Mohammad Hafeez';
SQL: SELECT SUM(CASE WHEN T2.Player_Name = 'Mohammad Hafeez' THEN 1 ELSE 0 END) FROM Player_Match AS T1 INNER JOIN Player AS T2 ON T1.Player_Id = T2.Player_Id

Database: college_completion
Question: Please list the names of the institutes with the percentage of male White students graduating in 2011 within 150 percent of normal/expected time over 20.
Evidence: names of the institutes refers to chronname; male refers to gender = 'M'; white refers to race = 'w'; in 2011 refers to year = 2011; percentage of students graduating within 150 percent of normal/expected time over 20 refers to grad_150>20;
SQL: SELECT T FROM ( SELECT DISTINCT CASE WHEN T2.grad_150 > 20 THEN T1.chronname ELSE NULL END AS T FROM institution_details T1 INNER JOIN institution_grads T2 ON T2.unitid = T1.unitid WHERE T2.year = 2011 AND T2.gender = 'M' AND T2.race = 'W' ) WHERE T IS NOT NULL

Database: donor
Question: When was the project with the highest quantity went live on the site? Indicate the grade level for which the project materials are intended.
Evidence: project with the highest quantity refers to max(item_quantity)
SQL: SELECT T2.date_posted, T2.grade_level FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid ORDER BY T1.item_quantity DESC LIMIT 1

Database: soccer_2016
Question: Among the players from South Africa, provide the players' names who were born in 1984.
Evidence: from South Africa refers to Country_Name = 'South Africa'; born in 1984 refers to DOB like '1984%';
SQL: SELECT T1.Player_Name FROM Player AS T1 INNER JOIN Country AS T2 ON T1.Country_Name = T2.Country_Id WHERE T2.Country_Name = 'South Africa' AND T1.DOB LIKE '1984%'

Database: simpson_episodes
Question: List down the episode ID of episodes aired in 2008 with 5 stars and below.
Evidence: aired in 2008 refers to air_date LIKE '2008%'; 5 stars and below refers to stars < 5
SQL: SELECT DISTINCT T1.episode_id FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE SUBSTR(T1.air_date, 1, 4) = '2008' AND T2.stars < 5;

Database: authors
Question: State the title of papers published in the Ibm Journal of Research and Development.
Evidence: Ibm Journal of Research and Development refer to FullName

'Ibm Journal of Research and Development' is the full name of paper
SQL: SELECT T2.Title FROM Journal AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.JournalId WHERE T1.FullName = 'Ibm Journal of Research and Development'

Database: menu
Question: List down the name of dishes from menu created in April.
Evidence: created in April refers to SUBSTR(created_at, 7, 1) = '4';
SQL: SELECT T2.name FROM MenuItem AS T1 INNER JOIN Dish AS T2 ON T2.id = T1.dish_id WHERE SUBSTR(T1.created_at, 7, 1) = '4'

Database: food_inspection
Question: List the tax code and inspection type of the business named "Rue Lepic".
Evidence: "Rue Lepic" is the name of the business;
SQL: SELECT DISTINCT T3.tax_code, T2.type FROM violations AS T1 INNER JOIN inspections AS T2 ON T1.business_id = T2.business_id INNER JOIN businesses AS T3 ON T2.business_id = T3.business_id WHERE T3.name = 'Rue Lepic'

Database: software_company
Question: What is the number of inhabitants of the place the most customers are from?
Evidence: the most customers are from refers to GEOID where MAX(COUNT(ID)); number of inhabitants refers to INHABITANTS_K;
SQL: SELECT DISTINCT T2.INHABITANTS_K FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID ORDER BY T2.INHABITANTS_K DESC

Database: ice_hockey_draft
Question: Who among the players drafted by Arizona Coyotes in 2000 has committed the highest rule violations?
Evidence: who refers to PlayerName; drafted by Arizona Coyotes refers to overallby = 'Arizona Coyotes'; committed the highest rule violations refers to MAX(PIM); in 2000 refers to draftyear = 2000;
SQL: SELECT T2.PlayerName FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.overallby = 'Arizona Coyotes' AND T2.draftyear = 2000 ORDER BY T1.PIM DESC LIMIT 1

Database: menu
Question: Among the menu pages on which the dish "Paysanne Soup" had appeared, how many of them had a stable price for the dish?
Evidence: Paysanne Soup is a name of dish; stable price refers to highest_price is null;
SQL: SELECT SUM(CASE WHEN T1.name = 'Paysanne Soup' THEN 1 ELSE 0 END) FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id WHERE T1.highest_price IS NULL

Database: car_retails
Question: Determine the email and Code of employee who are working at United State, state CA
Evidence: United States of America refers to country = 'USA'; code of employee refers to employeeNumber;
SQL: SELECT T1.email, T1.employeeNumber FROM employees AS T1 INNER JOIN offices AS T2 ON T1.officeCode = T2.officeCode WHERE T2.country = 'USA' AND T2.state = 'CA' GROUP BY T1.email, T1.officeCode

Database: movies_4
Question: How many movies have made at least 1 Billion at the box office?
Evidence: have made at least 1 Billion at the box office refers to revenue > 1000000000
SQL: SELECT COUNT(movie_id) FROM movie WHERE revenue > 1000000000

Database: talkingdata
Question: What is the brand of the youngest user's device?
Evidence: brand of the device refers to phone_brand; youngest user refers to MIN(age);
SQL: SELECT device_model FROM phone_brand_device_model2 WHERE device_id IN ( SELECT device_id FROM gender_age WHERE age = ( SELECT MIN(age) FROM gender_age ) )