Database: books
Question: Who is the author of the book with the biggest page count?
Evidence: author refers to author_name, biggest page count refers to Max(num_pages)
SQL: SELECT T3.author_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 ORDER BY T1.num_pages DESC LIMIT 1

Database: donor
Question: Name all the project titles whereby project materials are intended mainly for literary.
Evidence: intended mainly for literary refers to primary_focus_subject = 'Literacy'
SQL: SELECT T1.title FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T2.primary_focus_subject = 'Literacy'

Database: books
Question: What is the address that received the most orders?
Evidence: address refers to street_name, city; received the most orders refers to Max(count(dest_address_id))
SQL: SELECT T2.street_name, T2.city FROM cust_order AS T1 INNER JOIN address AS T2 ON T1.dest_address_id = T2.address_id GROUP BY T2.street_number, T2.street_name, T2.city ORDER BY COUNT(T1.dest_address_id) DESC LIMIT 1

Database: public_review_platform
Question: How many active businesses from Casa Grande are registered in the database?
Evidence: active business refers to active = 'true'; Casa Grande refers to city = 'Casa Grande'
SQL: SELECT COUNT(business_id) FROM Business WHERE active = 'true' AND city = 'Casa Grande'

Database: world
Question: What is the form of government that the city of Manila has?
Evidence: form of government refers to GovernmentForm;
SQL: SELECT T1.GovernmentForm FROM Country AS T1 INNER JOIN City AS T2 ON T1.Code = T2.CountryCode WHERE T2.Name = 'Manila'

Database: car_retails
Question: Which customer ordered 1939 'Chevrolet Deluxe Coupe' at the highest price?
Evidence: 1939 'Chevrolet Deluxe Coupe' refers to productName; the highest price refers to MAX(priceEach)
SQL: SELECT t4.customerName FROM products AS t1 INNER JOIN orderdetails AS t2 ON t1.productCode = t2.productCode INNER JOIN orders AS t3 ON t2.orderNumber = t3.orderNumber INNER JOIN customers AS t4 ON t3.customerNumber = t4.customerNumber WHERE t1.productName = '1939 Chevrolet Deluxe Coupe' ORDER BY t2.priceEach DESC LIMIT 1

Database: chicago_crime
Question: How many arrests were made in 2018 in an animal hospital under FBI code 08B?
Evidence: arrest refers to arrest = 'TRUE'; in 2018 refers to date LIKE '%2018%'; in an animal hospital refers to location_description = 'ANIMAL HOSPITAL'; FBI code 08B refers to fbi_code_no = '08B'
SQL: SELECT SUM(CASE WHEN arrest = 'TRUE' THEN 1 ELSE 0 END) FROM Crime WHERE date LIKE '%2018%' AND location_description = 'ANIMAL HOSPITAL' AND fbi_code_no = '08B'

Database: movie_3
Question: How many payments were made throughout the month of August 2005?
Evidence: payments made refers to amount; throughout the month of August 2005 refers to payment_date like '2005-08%'
SQL: SELECT SUM(amount) FROM payment WHERE payment_date LIKE '2005-08%'

Database: video_games
Question: In which year did the record ID 19 with game publisher ID 6657 released?
Evidence: which year refers to release_year; record ID 19 refers to game platform.id; id = 19
SQL: SELECT T.release_year FROM game_platform AS T WHERE T.game_publisher_id = 6657 AND T.id = 19

Database: simpson_episodes
Question: What are the top five most popular episodes?
Evidence: most popular episodes refers to MAX(votes)
SQL: SELECT episode_id FROM Episode ORDER BY votes DESC LIMIT 5;

Database: talkingdata
Question: How many times is the number of active apps in the event that happened at 7:50:28 on 2016/5/2 than in the event that happened at 7:41:03 on 2016/5/2?
Evidence: how many times = DIVIDE(SUM(IF(timestamp = '2016/5/2 7:50:28', 1,0)), SUM(IF(timestamp = '2016/5/2 7:41:03',1,0))); active refers to is_active = '1'; at 7:50:28 on 2016/5/2 refers to timestamp = '2016/5/2 7:50:28'; at 7:41:03 on 2016/5/2 refers to timestamp = '2016/5/2 7:41:03';
SQL: SELECT SUM(IIF(timestamp = '2016-05-02 7:50:28', 1, 0)) / SUM(IIF(timestamp = '2016-05-02 7:41:03', 1, 0)) AS num FROM events AS T1 INNER JOIN app_events AS T2 ON T1.event_id = T2.event_id WHERE T2.is_active = '1'

Database: social_media
Question: Please list the texts of all the tweets posted from Buenos Aires with a positive sentiment.
Evidence: "Buenos Aires" is the City; positive sentiment refers to Sentiment > 0
SQL: SELECT T1.text FROM twitter AS T1 INNER JOIN location AS T2 ON T2.LocationID = T1.LocationID WHERE T1.Sentiment > 0 AND T2.City = 'Buenos Aires'

Database: shakespeare
Question: List the scene numbers involving the character named Sir Toby Belch in the Twelfth Night.
Evidence: scene numbers refers to Scene; character named Sir Toby Belch refers to CharName = 'Sir Toby Belch'; in the Twelfth Night refers to Title = 'Twelfth Night'
SQL: SELECT DISTINCT T2.Scene 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 T1.Title = 'Twelfth Night' AND T4.CharName = 'Sir Toby Belch'

Database: beer_factory
Question: How many breweries are there in Australia?
Evidence: Australia refers to Country = 'Australia';
SQL: SELECT COUNT(BreweryName) FROM rootbeerbrand WHERE Country = 'Australia'

Database: restaurant
Question: Among the listed winery, what is the street number of the winery named "Tulocay Winery"?
Evidence: winery refers to food_type = 'winery'; street number refers to street_num; "Tulocay Winery" refers to label = 'Tulocay winery'
SQL: SELECT T1.street_num FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T2.label = 'Tulocay winery' AND T2.food_type = 'winery'

Database: talkingdata
Question: What is the age of the youngest female user of the app?
Evidence: youngest user refers to MIN(age); female refers to gender = 'F';
SQL: SELECT MIN(age) FROM gender_age WHERE gender = 'F'

Database: ice_hockey_draft
Question: How many right-shooted players have a height of 5'7''?
Evidence: right-shooted players refers to shoots = 'R'; height of 5'7'' refers to height_in_inch = '5''7"';
SQL: SELECT COUNT(T1.ELITEID) FROM PlayerInfo AS T1 INNER JOIN height_info AS T2 ON T1.height = T2.height_id WHERE T2.height_in_inch = '5''7"' AND T1.shoots = 'R'

Database: address
Question: How many cities does congressman Pierluisi Pedro represent?
SQL: SELECT COUNT(DISTINCT T1.city) FROM zip_data AS T1 INNER JOIN zip_congress AS T2 ON T1.zip_code = T2.zip_code INNER JOIN congress AS T3 ON T2.district = T3.cognress_rep_id WHERE T3.first_name = 'Pierluisi' AND T3.last_name = 'Pedro'

Database: movie
Question: Who played the No.1 character in the credit list of the movie which was released on "2015/10/26"?
Evidence: No.1 character refers to creditOrder = '1'; released on "2015/10/26" refers to Release Date = '2015-10-26'
SQL: SELECT T3.Name 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 T1.`Release Date` = '2015-10-26' AND T2.creditOrder = '1'

Database: social_media
Question: How many more tweets with a positive sentiment than the tweets with a neutral sentiment were posted by male users?
Evidence: positive sentiment tweet refers to Sentiment > 0; neutral sentiment refers to Sentiment = 0; male user refers to Gender = 'Male'; difference = Subtract (Count (TweetID where Sentiment > 0), Count (TweetID where Sentiment = 0))
SQL: SELECT SUM(CASE WHEN T1.Sentiment > 0 THEN 1 ELSE 0 END) - SUM(CASE WHEN T1.Sentiment = 0 THEN 1 ELSE 0 END) AS diff FROM twitter AS T1 INNER JOIN user AS T2 ON T1.UserID = T2.UserID WHERE T2.Gender = 'Male'