Database: menu
Question: Please list the names of all the dishes that appeared on the menu "Zentral Theater Terrace".
Evidence: Zentral Theater Terrace is a name of menu;
SQL: SELECT T4.name 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 T3.name = 'Zentral Theater Terrace'

Database: books
Question: How many books by William Shakespeare were published by Penguin Classics?
Evidence: "William Shakespeare" is the author_name; "Penguin Classics" is the publisher_name
SQL: SELECT COUNT(*) 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 INNER JOIN publisher AS T4 ON T4.publisher_id = T1.publisher_id WHERE T3.author_name = 'William Shakespeare' AND T4.publisher_name = 'Penguin Classics'

Database: donor
Question: Which project in Brooklyn that have the highest request of resources? State the the project ID including all of the name of item requested.
Evidence: in Brooklyn refers to school_city = 'Brooklyn'; highest request of resources refers to max(count(T1.item_name))
SQL: SELECT T1.projectid, T1.item_name FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T2.school_city LIKE 'Brooklyn' GROUP BY T1.item_name ORDER BY COUNT(T1.item_name) DESC LIMIT 1

Database: computer_student
Question: Which professor teaches the highest number of professional or master/graduate courses?
Evidence: professor refers to taughtBy.p_id; highest number of professional or master/graduate courses refers to max(count(taughtBy.course_id)) where courseLevel = 'Level_500'
SQL: SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel = 'Level_500' GROUP BY T2.p_id ORDER BY COUNT(T2.course_id) DESC LIMIT 1

Database: video_games
Question: List down the game ID of games with genre ID 2.
Evidence: game ID refers to game.id; genre ID 2 refers to genre_id = 2
SQL: SELECT T.id FROM game AS T WHERE T.genre_id = 2

Database: movie_3
Question: How many different clients have rented materials from Jon Stephens?
Evidence: 'Jon Stephens' is a full name of a customer; full name refers to first_name, last_name;
SQL: SELECT COUNT(T1.customer_id) FROM rental AS T1 INNER JOIN staff AS T2 ON T1.staff_id = T2.staff_id WHERE T2.first_name = 'Jon' AND T2.last_name = 'Stephens'

Database: image_and_language
Question: List all the ID of the images that have an attribute class of "horse".
Evidence: ID of all images refer to IMG_ID; attribute class of "horse" refers to ATT_CLASS = 'horse';
SQL: SELECT T2.IMG_ID FROM ATT_CLASSES AS T1 INNER JOIN IMG_OBJ_ATT AS T2 ON T1.ATT_CLASS_ID = T2.ATT_CLASS_ID WHERE T1.ATT_CLASS = 'horse'

Database: social_media
Question: Tweets posted from which city has a higher number of average likes, Bangkok or Chiang Mai?
Evidence: "Bangkok" and "Chiang Mai" are both City; average number of like = Divide (Sum(Likes), Count(TweetID))
SQL: SELECT SUM(CASE WHEN T2.City = 'Bangkok' THEN Likes ELSE NULL END) / COUNT(CASE WHEN T2.City = 'Bangkok' THEN 1 ELSE 0 END) AS bNum , SUM(CASE WHEN City = 'Chiang Mai' THEN Likes ELSE NULL END) / COUNT(CASE WHEN City = 'Chiang Mai' THEN TweetID ELSE NULL END) AS cNum FROM twitter AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID WHERE T2.City IN ('Bangkok', 'Chiang Mai')

Database: talkingdata
Question: Among the users who use OPPO, calculate the percentage of those who are under 50 years old.
Evidence: OPPO refers to phone_brand = 'OPPO'; percentage = MULTIPLY(DIVIDE(SUM(age < 50), COUNT(device_id)), 1.0); under 50 years old refers to age < 50;
SQL: SELECT SUM(IIF(T1.age < 50, 1, 0)) / COUNT(T1.device_id) AS per FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.phone_brand = 'OPPO'

Database: address
Question: Please list the zip_codes of all the residential areas in Huntingdon county with over 30 employees.
Evidence: over 30 employees refers to employee > 30; 'HUNTINGDON' is the county
SQL: SELECT DISTINCT T1.zip_code FROM zip_data AS T1 INNER JOIN country AS T2 ON T1.zip_code = T2.zip_code WHERE T2.county = 'HUNTINGDON' AND T1.employees > 30

Database: shooting
Question: Among all the male officers, what is the percentage of them are White?
Evidence: male refers to gender = 'M'; white refers to race = 'W'; percentage = divide(count(officers where race = 'W'), count(officers)) where gender = 'M' * 100%
SQL: SELECT CAST(SUM(IIF(race = 'W', 1, 0)) AS REAL) * 100 / COUNT(case_number) FROM officers WHERE gender = 'M'

Database: movie_platform
Question: How many users have rated the most popular movie?
Evidence: most popular refers to Max(movie_popularity);
SQL: SELECT COUNT(rating_id) FROM ratings WHERE movie_id = ( SELECT movie_id FROM movies ORDER BY movie_popularity DESC LIMIT 1 )

Database: chicago_crime
Question: What is the general and specific description of incident 275?
Evidence: incident 275 refers to iucr_no = 275; general description refers to primary_description; specific description refers to secondary_description
SQL: SELECT primary_description, secondary_description FROM IUCR WHERE iucr_no = 275

Database: retails
Question: How much is the total price of all the orders shipped to customers in Argentina?
Evidence: total price = sum(o_totalprice); Argentina refers to n_name = 'Argentina'
SQL: SELECT SUM(T3.o_totalprice) FROM customer AS T1 INNER JOIN nation AS T2 ON T1.c_nationkey = T2.n_nationkey INNER JOIN orders AS T3 ON T1.c_custkey = T3.o_custkey WHERE T2.n_name = 'ARGENTINA'

Database: movie_3
Question: How many id movies have category id 11?
Evidence: id movies refers to film_id
SQL: SELECT COUNT(film_id) FROM film_category WHERE category_id = 11

Database: disney
Question: List the directors of movies that feature a song.
Evidence: movies that feature a song refer to movie_title where song is not NULL;
SQL: SELECT T2.director FROM characters AS T1 INNER JOIN director AS T2 ON T1.movie_title = T2.name WHERE T1.song IS NOT NULL GROUP BY T2.director

Database: movie_3
Question: Among films with a rental rate of 4.99, what is the total number of films starred by Bob Fawcett?
Evidence: Bob Fawcett' is a full name of an actor; full name refers to first_name, last_name
SQL: SELECT COUNT(T1.actor_id) FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T3.rental_rate = 4.99 AND T1.first_name = 'Bob' AND T1.last_name = 'Fawcett'

Database: movie_platform
Question: Was the user who created the list "250 Favourite Films" a trialist when he or she created the list?
Evidence: the user was a trialist when he created the list refers to user_trailist = 1; 250 Favourite Films is list_title;
SQL: SELECT T2.user_trialist FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id AND T1.user_id = T2.user_id WHERE T1.list_title = '250 Favourite Films'

Database: movies_4
Question: List down the tagline of the Polski movies.
Evidence: Polski movies refers to language_name = 'Polski'
SQL: SELECT DISTINCT T1.tagline FROM movie AS T1 INNER JOIN movie_languages AS T2 ON T1.movie_id = T2.movie_id INNER JOIN language AS T3 ON T2.language_id = T3.language_id WHERE T3.language_name = 'Polski'

Database: retail_world
Question: What is the total sales amount of all discontinued products?
Evidence: discontinued products refers to Discontinued = 1; total sales amount refers to SUM(MULTIPLY(UnitPrice, Quantity))
SQL: SELECT SUM(T2.UnitPrice * T2.Quantity) FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T1.Discontinued = 1