Database: simpson_episodes
Question: In episode nominated in Annie Awards, how many of the episodes have a percent greater than 6?
Evidence: nominated refers to result = 'Nominee'; Annie Awards refers to organization = 'Annie Awards'; percent greater than 6 refers to percent > 6
SQL: SELECT COUNT(*) FROM Award AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T1.organization = 'Annie Awards' AND T1.result = 'Nominee' AND T2.percent > 6;

Database: legislator
Question: What is the twitter name of the legislator whose birthday was on 5/27/1946?
Evidence: birthday on 5/27/1946 refers to birthday_bio = '1946-05-27'
SQL: SELECT T2.twitter FROM current AS T1 INNER JOIN `social-media` AS T2 ON T2.bioguide = T1.bioguide_id WHERE T1.birthday_bio = '1946-05-27'

Database: talkingdata
Question: For the event which happened at 23:55:16 on 2016/5/7, in the location coordinate(113, 28), on what device did it happen? Give the name of the device model.
Evidence: at 23:55:16 on 2016/5/7 refers to timestamp = '2016/5/7 23:55:16'; location coordinate (113, 28) refers to longitude = '113' AND latitude = '28';
SQL: SELECT T1.device_model FROM phone_brand_device_model2 AS T1 INNER JOIN events AS T2 ON T1.device_id = T2.event_id WHERE T2.longitude = '113' AND T2.latitude = '28' AND T2.timestamp = '2016-05-07 23:55:16'

Database: movie_3
Question: State the documentary film titles with longest length.
Evidence: documentary film refers to name = 'documentary'; longest length refers to max(length)
SQL: SELECT T1.title FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T3.category_id = T2.category_id WHERE T3.name = 'documentary' ORDER BY T1.length DESC LIMIT 1

Database: donor
Question: What is the prefix for the teacher who handled the 'Reading About Other Cultures' project?
Evidence: Reading About Other Cultures' project refers to title = 'Reading About Other Cultures'; prefix for the teacher refers to teacher_prefix
SQL: SELECT T2.teacher_prefix FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.title LIKE 'Reading About Other Cultures'

Database: authors
Question: What is the short name and full name of conference uses the homepage "http://www.informatik.uni-trier.de/~ley/db/conf/ices/index.html"?
SQL: SELECT ShortName, FullName FROM Conference WHERE HomePage = 'http://www.informatik.uni-trier.de/~ley/db/conf/ices/index.html'

Database: video_games
Question: What is the name of the company that produced the game titled Adventure Time: Explore the Dungeon Because I Don't Know!?
Evidence: name of the company that produced the game refers to publisher_name; Adventure Time: Explore the Dungeon Because I Don't Know! Refers to game_name = 'Adventure Time: Explore the Dungeon Because I Don''t Know!';
SQL: SELECT T3.publisher_name FROM game AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.game_id INNER JOIN publisher AS T3 ON T2.publisher_id = T3.id WHERE T1.game_name = 'Adventure Time: Explore the Dungeon Because I Don''t Know!'

Database: shooting
Question: What percentage of deaths were caused by rifles?
Evidence: rifle refers to subject_weapon = 'rifles'; death refers to subject_statuses = 'Deceased'; percentage = divide(count(incidents where subject_weapon = 'rifles'), count(incidents)) where subject_statuses = 'Deceased' * 100%
SQL: SELECT CAST(SUM(subject_statuses = 'Deceased') AS REAL) * 100 / COUNT(case_number) FROM incidents WHERE subject_weapon = 'Rifle'

Database: beer_factory
Question: At what latitude is the Thomas Kemper brand beer consumed the most?
Evidence: Thomas Kemper refers to BrandName = 'Thomas Kemper';  latitude the beer is consumed the most refers to MAX(COUNT(Latitude));
SQL: SELECT T3.Latitude FROM rootbeer AS T1 INNER JOIN rootbeerbrand AS T2 ON T1.BrandID = T2.BrandID INNER JOIN geolocation AS T3 ON T1.LocationID = T3.LocationID WHERE T2.BrandName = 'Thomas Kemper' GROUP BY T3.Latitude ORDER BY COUNT(T1.BrandID) DESC LIMIT 1

Database: law_episode
Question: What is the name of the actors born in the USA?
Evidence: born in the USA refers to birth_country = 'USA'
SQL: SELECT name FROM Person WHERE birth_country = 'USA'

Database: olympics
Question: How many Olympic games were held in London?
Evidence: London refers to city_name = 'London';
SQL: SELECT COUNT(T1.games_id) FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id WHERE T2.city_name = 'London'

Database: professional_basketball
Question: From which college was the player who won the most award in 1970.
Evidence: college refers to highSchool; won the most award refers to max(count(award)); in 1970 refers to year = 1970
SQL: SELECT college FROM players WHERE playerID = ( SELECT playerID FROM awards_players WHERE year = 1970 GROUP BY playerID ORDER BY COUNT(award) DESC LIMIT 1 )

Database: retail_world
Question: Which employee handled the most amount of orders in 1996? Give the full name, title, and address of this employee.
Evidence: most amount of orders refers to max(count(OrderID)); in 1996 refers to OrderDate > = '1996-01-01 00:00:00' AND OrderDate < '1997-01-01 00:00:00'; full name refers to FirstName, LastName
SQL: SELECT FirstName, LastName, Title, address FROM Employees WHERE EmployeeID = ( SELECT T1.EmployeeID FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T2.OrderDate BETWEEN '1996-01-01 00:00:00' AND '1997-01-01 00:00:00' GROUP BY T1.EmployeeID ORDER BY COUNT(T2.OrderID) DESC LIMIT 1 )

Database: disney
Question: Give the name of the director of the movie in which Verna Felton was the voice actor for its character "Aunt Sarah".
Evidence: FALSE;
SQL: SELECT T1.director FROM director AS T1 INNER JOIN `voice-actors` AS T2 ON T2.movie = T1.name WHERE T2.character = 'Aunt Sarah' AND T2.`voice-actor` = 'Verna Felton'

Database: movie
Question: What is the MPAA rating and title of the movie starred by Leonardo DiCaprio with highest budget?
Evidence: starred by Leonardo DiCaprio refers to Name = 'Leonardo Dicaprio'; highest budget refers to max(Budget)
SQL: SELECT T1.`MPAA Rating`, T1.Title 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 T3.Name = 'Leonardo DiCaprio' ORDER BY T1.Budget DESC LIMIT 1

Database: simpson_episodes
Question: Please list any three episodes that have an excellent rating.
Evidence: an excellent rating refers to 7 < rating < = 10
SQL: SELECT title FROM Episode WHERE rating BETWEEN 7 AND 10 LIMIT 3;

Database: disney
Question: Provide the names of voice actors for the characters of films directed by Wolfgang Reitherman.
Evidence: Wolfgang Reitherman refers to director = 'Wolfgang Reitherman';
SQL: SELECT T2.hero, T1.`voice-actor` FROM `voice-actors` AS T1 INNER JOIN characters AS T2 ON T1.movie = T2.movie_title INNER JOIN director AS T3 ON T3.name = T2.movie_title WHERE T3.director = 'Wolfgang Reitherman'

Database: movie_platform
Question: List ther users who gave the worst rating for movie 'Love Will Tear Us Apart'.
Evidence: worst rating refers to rating_score = 1;
SQL: SELECT T1.user_id FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Love Will Tear Us Apart' AND T1.rating_score = 1

Database: talkingdata
Question: Which group does age 24 belong to?
SQL: SELECT `group` FROM gender_age WHERE age = '24'