Database: bike_share_1
Question: What is the mean temperature in Fahrenheit on 8/29/2013 for the area where the zip code is 94107?
Evidence: mean temperature in Fahrenheit refers to mean_temperature_f; on 8/29/2013 refers to date = '8/29/2013';
SQL: SELECT SUM(IIF(zip_code = 94107 AND date = '8/29/2013', mean_temperature_f, 0)) FROM weather

Database: public_review_platform
Question: Find out which business ID are opened all the time.
Evidence: opened all the time refers to Business_Hours where day_id BETWEEN 1 and 7 and opening_time = closing_time;
SQL: SELECT DISTINCT business_id FROM Business_Hours WHERE day_id >= 1 AND day_id < 8 AND opening_time = closing_time

Database: address
Question: Provide the zip code, city, and congress representative's full names of the area which has highest population in 2020.
Evidence: representative's full names refer to first_name, last_name; area which has highest population in 2020 refers to MAX(population_2020);
SQL: SELECT T1.zip_code, T1.city, T3.first_name, T3.last_name 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 GROUP BY T2.district ORDER BY T1.population_2020 DESC LIMIT 1

Database: movie_platform
Question: List all movies rated by user 39115684. State the title, rating date and rating score.
Evidence: user 39115684 refers to user_id = 39115684; title refers to movie_title; rating date refers to rating_timestamp_utc

SQL: SELECT T2.movie_title, T1.rating_timestamp_utc, T1.rating_score FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.user_id = 39115684

Database: movie_3
Question: Provide the full name of all the actors of the film "Ending Crowds".
Evidence: full name refers to first_name, last_name; film "Ending Crowds" refers to title = 'ENDING CROWDS'
SQL: SELECT T2.first_name, T2.last_name FROM film_actor AS T1 INNER JOIN actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T1.film_id = T3.film_id WHERE T3.title = 'ENDING CROWDS'

Database: address
Question: Give at least five alias of cities with a postal point of post office.
Evidence: postal point of post office refers to type = 'Post Office';
SQL: SELECT T1.alias FROM alias AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.type = 'Post Office' LIMIT 5

Database: trains
Question: Which direction do the majority of the trains are running?
Evidence: majority of train refers to MAX(count(id))
SQL: SELECT direction FROM trains GROUP BY direction ORDER BY COUNT(id) DESC

Database: image_and_language
Question: How many images contain 'bridge' as an object element?
Evidence: images refers to IMG_ID; 'bridge' as an object element refers to OBJ_CLASS = 'bridge'
SQL: SELECT COUNT(DISTINCT T1.IMG_ID) FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.OBJ_CLASS = 'bridge'

Database: social_media
Question: List down all of the texts posted on Twitter on Thursday.
Evidence: "Thursday" is the Weekday
SQL: SELECT text FROM twitter WHERE Weekday = 'Thursday'

Database: books
Question: Which language is the rarest among all the books?
Evidence: language written in refers to language_name; rarest refers to Min(Count(book_id))
SQL: SELECT T2.language_name FROM book AS T1 INNER JOIN book_language AS T2 ON T1.language_id = T2.language_id GROUP BY T2.language_name ORDER BY COUNT(T2.language_name) ASC LIMIT 1

Database: books
Question: What is the publication date of the book with the most pages?
Evidence: book with the most pages refers to Max(num_pages)
SQL: SELECT publication_date FROM book ORDER BY num_pages DESC LIMIT 1

Database: regional_sales
Question: Among the orders placed by Pacific Ltd, how many orders have been applied 5% discount ?
Evidence: orders by Pacific Ltd refer to OrderNumber where Customer Names = 'Pacific Ltd'; applied 5% discount refers to Discount Applied = 0.05;
SQL: SELECT SUM(CASE WHEN T1.`Discount Applied` = 0.05 AND T2.`Customer Names` = 'Pacific Ltd' THEN 1 ELSE 0 END) FROM `Sales Orders` AS T1 INNER JOIN Customers AS T2 ON T2.CustomerID = T1._CustomerID

Database: movie_platform
Question: Among the lists with at least one follower, how many were created by user who was subscriber when created the list?
Evidence: lists with at least one follower refers to list_followers > = 1; was a subscriber refers to user_subscriber = 1
SQL: SELECT COUNT(T1.list_id) FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.list_id = T2.list_id WHERE T2.list_followers >= 1 AND T1.user_subscriber = 1

Database: cs_semester
Question: Describe the full names, emails and intelligence of the students with the highest capability and salary.
Evidence: full names of the students = f_name; l_name; highest capability refers to MAX(capability); highest salary refers to salary = 'high';
SQL: SELECT f_name, l_name, email, intelligence FROM student WHERE student_id IN ( SELECT student_id FROM RA WHERE salary = 'high' AND capability = ( SELECT MAX(capability) FROM RA ) )

Database: mental_health_survey
Question: Please list the IDs of the users who answered "Yes" to the question "Do you think that discussing a physical health issue with your employer would have negative consequences?" in 2014's survey.
Evidence: 2014 refer to SurveyID; Question refer to questiontext; yes refer to AnswerText = 'Yes'


SQL: SELECT T2.UserID FROM Question AS T1 INNER JOIN Answer AS T2 ON T1.questionid = T2.QuestionID WHERE T1.questiontext = 'Do you think that discussing a physical health issue with your employer would have negative consequences?' AND T2.AnswerText LIKE 'Yes' AND T2.SurveyID = 2014

Database: disney
Question: The song "Once Upon a Dream" is associated with the movie directed by whom?
Evidence: directed by whom refers to director; movie refers to movie_title;
SQL: SELECT T2.director FROM characters AS T1 INNER JOIN director AS T2 ON T1.movie_title = T2.name WHERE T1.song = 'Once Upon a Dream'

Database: olympics
Question: What is the average height of male athletes playing basketball sport?
Evidence: AVG(height) where sport_name = 'Basketball' and event_name = 'Basketball Men''s';
SQL: SELECT AVG(T5.height) FROM sport AS T1 INNER JOIN event AS T2 ON T1.id = T2.sport_id INNER JOIN competitor_event AS T3 ON T2.id = T3.event_id INNER JOIN games_competitor AS T4 ON T3.competitor_id = T4.id INNER JOIN person AS T5 ON T4.person_id = T5.id WHERE T1.sport_name = 'Basketball' AND T5.gender = 'M'

Database: disney
Question: Among the movies released from 1991 to 2000, calculate the percentage of comedy movies. Provide any five movie titles and directors.
Evidence: DIVIDE(COUNT(movie_title where genre = 'Comedy'), COUNT(movie_title)) as percentage where substr(release_date, length(release_date) - 3, length(release_date)) between '1991' and '2000';
SQL: SELECT CAST(COUNT(CASE WHEN T1.genre = 'Comedy' THEN T1.movie_title ELSE NULL END) AS REAL) * 100 / COUNT(T1.movie_title), group_concat(T1.movie_title), group_concat(T2.director) FROM movies_total_gross AS T1 INNER JOIN director AS T2 ON T1.movie_title = T2.name WHERE SUBSTR(T1.release_date, LENGTH(T1.release_date) - 3, LENGTH(T1.release_date)) BETWEEN '1991' AND '2000'

Database: public_review_platform
Question: List the active business ID and its stars of the businesses fall under the category of Food.
Evidence: active business ID refers to active = 'true'; category of Food refers to category_name = 'Food'
SQL: SELECT DISTINCT T1.business_id, T1.stars FROM Business AS T1 INNER JOIN Business_Categories AS T2 ON T1.business_id = T2.business_id INNER JOIN Categories AS T3 ON T2.category_id = T3.category_id WHERE T3.category_name = 'Food' AND T1.active = 'true'

Database: menu
Question: Among the menus with over 10 pages, how many of them have over 20 dishes?
Evidence: menus with over 10 pages refers to page_count > 10; over 20 dishes refers to dish_count > 20;
SQL: SELECT COUNT(*) FROM Menu WHERE page_count > 10 AND dish_count > 20