Database: shakespeare
Question: In "Florence. Without the walls. A tucket afar off", what is the id of the character that was mentioned in "His name, I pray you."?
Evidence: "Florence. Without the walls. A tucket afar off" refers to chapters.Description = 'Florence. Without the walls. A tucket afar off.'; "His name, I pray you." refers to PlainText = 'His name, I pray you.'
SQL: SELECT T1.character_id FROM paragraphs AS T1 INNER JOIN chapters AS T2 ON T1.chapter_id = T2.id WHERE T1.PlainText = 'His name, I pray you.' AND T2.Description = 'Florence. Without the walls. A tucket afar off.'

Database: image_and_language
Question: What is the object class of the image with a bounding box of 0, 0, 135, 212?
Evidence: object class of the image refers to OBJ_CLASS; bounding box of 0, 0, 135, 212 refers to X = 0 AND Y = 0 AND W = 135 AND H = 212
SQL: SELECT T1.OBJ_CLASS FROM OBJ_CLASSES AS T1 INNER JOIN IMG_OBJ AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.X = 0 AND T2.Y = 0 AND T2.W = 135 AND T2.H = 212

Database: talkingdata
Question: Among all the devices with event no.2 happening, what is the percentage of the device being a vivo phone?
Evidence: event no. refers to event_id; event_id = '2'; percentage = SUM(IF(phone_brand = 'vivo',1,0)), COUNT(device_id) WHERE event_id = '2'; vivo phone refers to phone_brand = 'vivo';
SQL: SELECT SUM(IIF(T2.phone_brand = 'vivo', 1, 0)) / COUNT(T1.device_id) AS per FROM events AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.event_id = T2.device_id WHERE T1.event_id = '2'

Database: mental_health_survey
Question: How many people wrote comments for the question "Any additional notes or comments."?
Evidence: question refers to questiontext; wrote comments refers to AnswerText(QuestionID = 103) ! = -1
SQL: SELECT COUNT(T1.UserID) FROM Answer AS T1 INNER JOIN Question AS T2 ON T1.QuestionID = T2.questionid WHERE T2.questiontext LIKE 'Any additional notes or comments' AND T1.AnswerText IS NOT NULL

Database: software_company
Question: What is the geographic identifier and income of the oldest customer?
Evidence: the oldest customer refers to MAX(age); geographic identifier refers to GEOID; income refers to INCOME_K;
SQL: SELECT T1.GEOID, T2.INCOME_K FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID ORDER BY T1.age DESC LIMIT 1

Database: retail_world
Question: Provide the number of orders that were handled by Michael Suyama.
SQL: SELECT COUNT(T2.OrderID) FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T1.FirstName = 'Michael' AND T1.LastName = 'Suyama'

Database: codebase_comments
Question: List all the ids of repositories for solutions with "ro" methods.
Evidence: ids of repositories refers to RepoId; ro refers to lang = 'ro';
SQL: SELECT DISTINCT T1.RepoId FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.Lang = 'ro'

Database: public_review_platform
Question: How many users have no followers in 2014?
Evidence: in 2004 refers to user_yelping_since_year = 2004; no follower refers to user_fans = 'None'
SQL: SELECT COUNT(user_id) FROM Users WHERE user_yelping_since_year = 2004 AND user_fans LIKE 'None'

Database: language_corpus
Question: How many pages of Wikipedia are there in total on the Catalan language?
Evidence: Catalan language refers to lang = 'ca';
SQL: SELECT pages FROM langs WHERE lang = 'ca'

Database: college_completion
Question: Among the public institutes in the state of Alabama, how many of them have over 30 students who graduated within 100 percent of normal/expected time in 2011?
Evidence: public refers to control = 'Public'; over 30 students who graduated within 100 percent of normal/expected time refers to grad_100 > 30; in 2011 refers to year = 2011;
SQL: SELECT COUNT(T1.chronname) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T1.state = 'Alabama' AND T1.control = 'Public' AND T2.year = 2011 AND T2.grad_100 > 30

Database: video_games
Question: What is the name of the genre with the most number of video games?
Evidence: name of the genre refers to genre_name; genre with the most number of video games refers to MAX(COUNT(genre_name));
SQL: SELECT T2.genre_name FROM game AS T1 INNER JOIN genre AS T2 ON T2.id = T1.genre_id GROUP BY T2.genre_name ORDER BY COUNT(T1.genre_id) DESC LIMIT 1

Database: books
Question: List all the order dates for the customer named "Adrian Kunzelmann".
SQL: SELECT T3.order_date FROM book AS T1 INNER JOIN order_line AS T2 ON T1.book_id = T2.book_id INNER JOIN cust_order AS T3 ON T3.order_id = T2.order_id INNER JOIN customer AS T4 ON T4.customer_id = T3.customer_id WHERE T4.first_name = 'Adrian' AND T4.last_name = 'Kunzelmann'

Database: cs_semester
Question: Please list the names of the courses that are less important than Machine Learning Theory.
Evidence: lower credit means less important;
SQL: SELECT name FROM course WHERE credit < ( SELECT credit FROM course WHERE name = 'Machine Learning Theory' )

Database: movielens
Question: How many directors with average revenue of 4 have made either action or adventure films?
SQL: SELECT COUNT(T1.directorid) FROM directors AS T1 INNER JOIN movies2directors AS T2 ON T1.directorid = T2.directorid WHERE T1.avg_revenue = 4 AND (T2.genre = 'Adventure' OR T2.genre = 'Action')

Database: retails
Question: What is the total price and the order priority of order number 33?
Evidence: total price refers to o_totalprice; order priority refers to o_orderpriority; order number 33 refers to o_orderkey = 33
SQL: SELECT o_totalprice, o_orderpriority FROM orders WHERE o_orderkey = 33

Database: retail_complains
Question: State the full name of clients with server time of 20 minutes and above.
Evidence: full name refers to first, middle, last; server time of 20 minutes and above refers to ser_time > '00:20:00'
SQL: SELECT T1.first, T1.middle, T1.last FROM client AS T1 INNER JOIN callcenterlogs AS T2 ON T1.client_id = T2.`rand client` WHERE strftime('%M', T2.ser_time) > '20'

Database: cars
Question: What was the origin country of the car model ford torino produced in 1970?
Evidence: origin country refers to country; Ford Torino refers to car_name = 'ford torino'; produced in 1970 refers to model_year = 1970
SQL: SELECT T3.country FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country WHERE T1.car_name = 'ford torino' AND T2.model_year = 1970

Database: books
Question: List the title of books published by AK Press.
Evidence: "AK Press" is the publisher_name
SQL: SELECT T1.title FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id WHERE T2.publisher_name = 'AK Press'

Database: software_company
Question: Point out the greater one between the number of actual responding and not responding to mailing.
Evidence: COUNT(REFID where RESPONSE = 'true')>or<COUNT(REFID where RESPONSE = 'false');
SQL: SELECT RESPONSE FROM Mailings1_2 GROUP BY RESPONSE ORDER BY COUNT(RESPONSE) DESC LIMIT 1

Database: car_retails
Question: Among the German customers, how many of the them has credit limit of zero?
Evidence: German is a nationality of country = 'Germany'; CREDITLIMIT = 0
SQL: SELECT COUNT(customerNumber) FROM customers WHERE creditLimit = 0 AND country = 'Germany'