Database: movies_4
Question: What is Walt Disney Pictures' most popular movie?
Evidence: Walt Disney Pictures refers to company_name = 'Walt Disney Pictures'; most popular movie refers to max(popularity)
SQL: SELECT T3.title FROM production_company AS T1 INNER JOIN movie_company AS T2 ON T1.company_id = T2.company_id INNER JOIN movie AS T3 ON T2.movie_id = T3.movie_id WHERE T1.company_name = 'Walt Disney Pictures' ORDER BY T3.popularity DESC LIMIT 1

Database: talkingdata
Question: Mention the group of age of users who use phone brand of LG.
Evidence: group of age refers to group;
SQL: SELECT T1.`group` FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.phone_brand = 'LG'

Database: ice_hockey_draft
Question: How heavy is Matthias Trattnig in kilograms?
Evidence: how heavy in kilograms refers to weight_in_kg;
SQL: SELECT T2.weight_in_kg FROM PlayerInfo AS T1 INNER JOIN weight_info AS T2 ON T1.weight = T2.weight_id WHERE T1.PlayerName = 'Pavel Patera'

Database: books
Question: Which books were released by Orson Scott Card in 2001?
Evidence: "Orson Scott Card" is the author_name; released in 2001 refers to publication_date LIKE '2001%'; books refers to title
SQL: SELECT T1.title 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 WHERE T3.author_name = 'Orson Scott Card' AND STRFTIME('%Y', T1.publication_date) = '2001'

Database: legislator
Question: How many female representatives are there in Michigan?
Evidence: female refers to gender_bio = 'F'; representatives refers to type = 'rep'; Michigan refers to state = 'MI';
SQL: SELECT COUNT(T.bioguide_id) FROM ( SELECT T1.bioguide_id FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.type = 'rep' AND T2.state = 'MI' AND T1.gender_bio = 'F' GROUP BY T1.bioguide_id ) T

Database: beer_factory
Question: For the customer who gave a 3 star rating to Frostie brand on 2014/4/24, did the user permit the company to send regular emails to him/her?
Evidence: 3 star rating refers to StarRating = 3; Frostie refers to  BrandName = 'Frostie'; if SubscribedToEmailList = 'TRUE', it means the user permit the company to send regular emails to him/her; if SubscribedToEmailList = FALSE', it means the user did not permit the company to send regular emails to him/her; rating on 2014/4/24 refers to ReviewDate = '2014-04-24';
SQL: SELECT CASE WHEN T1.SubscribedToEmailList LIKE 'TRUE' THEN 'YES' ELSE 'NO' END AS result FROM customers AS T1 INNER JOIN rootbeerreview AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN rootbeerbrand AS T3 ON T2.BrandID = T3.BrandID WHERE T2.StarRating = 3 AND T3.BrandName = 'Frostie' AND T2.ReviewDate = '2014-04-24'

Database: public_review_platform
Question: List out the user who is an elite user for consecutively 5 years or more and what is the user average star? How many likes does this user gets?
Evidence: elite user for consecutively 5 years or more refers to user_id COUNT(year_id) > 5; Average star = AVG(likes)
SQL: SELECT T2.user_average_stars, COUNT(T3.likes) FROM Elite AS T1 INNER JOIN Users AS T2 ON T1.user_id = T2.user_id INNER JOIN Tips AS T3 ON T3.user_id = T2.user_id GROUP BY T1.user_id HAVING COUNT(T1.user_id) > 5

Database: address
Question: List the area code of the city with the highest Hispanic population.
Evidence: the highest Hispanic population refers to MAX(hispanic_population);
SQL: SELECT T1.area_code FROM area_code AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.hispanic_population = ( SELECT MAX(hispanic_population) FROM zip_data )

Database: superstore
Question: For how many times has Aimee Bixby ordered the product Xerox 1952?
Evidence: Xerox 1952 is a "Product Name"; Aimee Bixby ordered refers to "Customer Name" = 'Aimee Bixby';
SQL: SELECT COUNT(DISTINCT T2.`Order ID`) FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T2.`Product ID` WHERE T1.`Customer Name` = 'Aimee Bixby' AND T3.`Product Name` = 'Xerox 1952'

Database: movie_3
Question: What are the ratings of the film featuring behind the scenes?
Evidence: film featuring behind the scenes refers to special_features = 'Behind the Scenes'
SQL: SELECT rating FROM film WHERE special_features LIKE '%Behind the Scenes%'

Database: simpson_episodes
Question: Calculate the difference between the highest votes for episode and the lowest votes for episode.
Evidence: highest vote refers to Max(votes); lowest vote refers to Min(votes); difference = Subtract(Max(votes), Min(votes))
SQL: SELECT MAX(votes) - MIN(votes) FROM Vote;

Database: retail_world
Question: What is the position of Robert King?
Evidence: 'Robert King' is the full name of an employee; full name refers to FirstName, LastName; position refers to Title
SQL: SELECT Title FROM Employees WHERE FirstName = 'Robert' AND LastName = 'King'

Database: books
Question: What is the title of the first book that was written by A.J. Ayer?
Evidence: "A.J. Ayer" is the author_name; first book refers to Min(publication_date)
SQL: SELECT T1.title 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 WHERE T3.author_name = 'A.J. Ayer' ORDER BY T1.publication_date ASC LIMIT 1

Database: synthea
Question: Please give the full names of all the patients who had been prescribed with Acetaminophen.
Evidence: full name refers to first, last; prescribed with Acetaminophen refer to DESCRIPTION like 'Acetaminophen%' from medications;
SQL: SELECT DISTINCT T1.first, T1.last FROM patients AS T1 INNER JOIN medications AS T2 ON T1.patient = T2.PATIENT WHERE T2.description LIKE 'Acetaminophen%'

Database: synthea
Question: How many times did Keven Kuhn receive DTaP immunization?
Evidence: DTaP immunization refers to immunizations where DESCRIPTION = 'DTaP';
SQL: SELECT COUNT(T2.CODE) FROM patients AS T1 INNER JOIN immunizations AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Keven' AND T1.last = 'Kuhn' AND T2.DESCRIPTION = 'DTaP'

Database: law_episode
Question: Who is the winner of the Best Television Episode award for the Edgar category in 2000? Include his or her name and role.
Evidence: the Best Television Episode award refers to award = 'Best Television Episode'; the Edgar category refers to award_category = 'Edgar'; in 2000 refers to year = 2000
SQL: SELECT T1.name, T2.role FROM Person AS T1 INNER JOIN Award AS T2 ON T1.person_id = T2.person_id WHERE T2.year = 2000 AND T2.award_category = 'Edgar' AND T2.award = 'Best Television Episode'

Database: movies_4
Question: How many Indian movies between 1/2/1990 and 12/30/2003 have revenue of more than 75,000,000 and popularity of no less than 20?
Evidence: Indian movies refers to country_name = 'India'; between 1/2/1990 and 12/30/2003 refers to release_date BETWEEN '1990-01-02' AND '2003-12-30'; revenue of more than 75,000,000 refers to revenue > 75000000; popularity of no less than 20 refers to popularity > = 20
SQL: SELECT COUNT(T2.movie_id) FROM movie AS T1 INNER JOIN production_COUNTry AS T2 ON T1.movie_id = T2.movie_id WHERE T1.revenue > 75000000 AND T1.popularity >= 20 AND T1.release_date BETWEEN '1990-01-01' AND '2003-12-31'

Database: professional_basketball
Question: What is the birth date of the player with the most assists during the 1985 All-Star season?
Evidence: most assist refers to Max(assists); in 1985 All Star season refers to season_id = 1985
SQL: SELECT T1.birthDate FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE T2.season_id = 1985 ORDER BY T2.assists DESC LIMIT 1