Database: disney
Question: List all the voice actors in the movie directed by Ben Sharpsteen which was released on February 9, 1940.
Evidence: Ben Sharpsteen refers to director = 'Ben Sharpsteen'; released on February 9, 1940 refers to release_date = 'Feb 9, 1940';
SQL: SELECT T2.`voice-actor` FROM director AS T1 INNER JOIN `voice-actors` AS T2 INNER JOIN movies_total_gross AS T3 ON T1.name = T2.movie AND T2.movie = T3.movie_title WHERE T1.director = 'Ben Sharpsteen' AND T3.release_date = 'Feb 9, 1940' AND T2.`voice-actor` != 'None' GROUP BY T2.`voice-actor`

Database: olympics
Question: List the names of the games held in Paris.
Evidence: Paris refers to city_name = 'Paris'; names of games refers to games_name;
SQL: SELECT T3.games_name FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id INNER JOIN games AS T3 ON T1.games_id = T3.id WHERE T2.city_name = 'Paris'

Database: retail_world
Question: How many female employees are in charge of 3 or more territories?
Evidence: female employees refers to TitleOfCourtesy = 'Mrs.' or TitleOfCourtesy = 'Ms.'; in charge of 3 or more territories refers to TerritoryID > = 3;
SQL: SELECT COUNT(EID) FROM ( SELECT T1.EmployeeID AS EID FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T1.TitleOfCourtesy IN ('Ms.' OR 'Mrs.') GROUP BY T1.EmployeeID HAVING COUNT(T2.TerritoryID) >= 3 ) T1

Database: movie_3
Question: Name the cast members of the movie 'African Egg'.
Evidence: cast member name refers to first_name, last_name; 'African Egg' refers to title = 'AFRICAN EGG'
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 = 'AFRICAN EGG'

Database: video_games
Question: What is the genre ID of the game named 25 to Life?
Evidence: the game named 25 to Life refers to game_name = '25 to Life'
SQL: SELECT T.genre_id FROM game AS T WHERE T.game_name = '25 to Life'

Database: movies_4
Question: What is the title of the latest released movie produced by production company "Universal Pictures"?
Evidence: "Universal Pictures" refers to company_name = 'Universal Pictures'; latest released refers to max(release_date)
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 = 'Universal Pictures' ORDER BY T3.release_date DESC LIMIT 1

Database: books
Question: How many books have been published in Japanese?
Evidence: in Japanese refers to language_name = 'Japanese
SQL: SELECT COUNT(*) FROM book_language AS T1 INNER JOIN book AS T2 ON T1.language_id = T2.language_id WHERE T1.language_name = 'Japanese'

Database: movie_3
Question: How many titles did Mary Smith rent in 2005? Determine the percentage of titles rented in June 2005.
Evidence: in June 2005 refers to month(rental_date) = 6 and year(rental_date) = 2005; percentage = divide(count(inventory_id where month(rental_date) = 6 and year(rental_date) = 2005), count(inventory_id)) * 100%
SQL: SELECT COUNT(T2.rental_id) , CAST(SUM(IIF(STRFTIME('%m',T2.rental_date) = '7', 1, 0)) AS REAL) * 100 / COUNT(T2.rental_id) FROM customer AS T1 INNER JOIN rental AS T2 ON T1.customer_id = T2.customer_id WHERE T1.first_name = 'Maria' AND T1.last_name = 'Miller' AND STRFTIME('%Y',T2.rental_date) = '2005'

Database: cars
Question: How much US dollars does a Ford Torino cost?
Evidence: cost refers to price; Ford Torino refers to car_name = 'ford torino'
SQL: SELECT T2.price FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T1.car_name = 'ford torino'

Database: movies_4
Question: Provide the title of the movie that is most-liked by a large number of people.
Evidence: most-liked by a large number of people refers to max(popularity)
SQL: SELECT title FROM movie ORDER BY popularity DESC LIMIT 1

Database: student_loan
Question: Calculate the average number of female students who are disabled and who joined Foreign Legion organization.
Evidence: average = DIVIDE(COUNT(disabled.name who are not in male.name WHERE organ = 'foreign_legion'), COUNT(disabled.name)); female students who are disabled refers to disabled.name who are NOT in male.name; organization refers to organ; organ = 'Foreign Legion';
SQL: SELECT CAST(SUM(IIF(T3.name IS NULL, 1, 0)) AS REAL) / COUNT(T1.name) FROM disabled AS T1 INNER JOIN enlist AS T2 ON T1.name = T2.name LEFT JOIN male AS T3 ON T2.name = T3.name WHERE T2.organ = 'foreign_legion'

Database: retail_complains
Question: How many clients have an email account other than gmail.com?
Evidence: email account other than gmail.com refers to email not like '%@gmail.com';
SQL: SELECT COUNT(email) FROM client WHERE email NOT LIKE '%@gmail.com'

Database: beer_factory
Question: What is the amount difference between the bottles of root beer sold from Louisiana and Missouri?
Evidence: difference = SUBTRACT(COUNT(ContainerType = 'Bottle' WHERE State = 'LA'), COUNT(ContainerType = 'Bottle' State = 'MO')); bottles refers to ContainerType = 'Bottle'; Louisiana refers to State = 'LA'; Missouri refers to State = 'MO';
SQL: SELECT ( SELECT COUNT(T1.BrandID) FROM rootbeer AS T1 INNER JOIN rootbeerbrand AS T2 ON T1.BrandID = T2.BrandID WHERE T2.State = 'LA' AND T1.ContainerType = 'Bottle' ) - ( SELECT COUNT(T3.BrandID) FROM rootbeer AS T3 INNER JOIN rootbeerbrand AS T4 ON T3.BrandID = T4.BrandID WHERE T4.State = 'MO' AND T3.ContainerType = 'Bottle' ) AS DIFFERENCE

Database: address
Question: Provide the congress representatives' IDs of the postal points in East Springfield.
Evidence: congress representatives' IDs refer to CID; East Springfield is the city;
SQL: SELECT T2.district FROM zip_data AS T1 INNER JOIN zip_congress AS T2 ON T1.zip_code = T2.zip_code WHERE T1.city = 'East Springfield'

Database: beer_factory
Question: For the root beer brand with the most 5 star ratings, what is the name of the brewery?
Evidence: most 5 star ratings refers to MAX(COUNT(StarRating = 5)); name of the brewery refers to BreweryName;
SQL: SELECT T1.BreweryName FROM rootbeerbrand AS T1 INNER JOIN rootbeerreview AS T2 ON T1.BrandID = T2.BrandID WHERE T2.StarRating = 5 GROUP BY T1.BrandID ORDER BY COUNT(T2.StarRating) DESC LIMIT 1

Database: beer_factory
Question: Please list the names of all the root beer brands that are advertised on facebook.
Evidence: name of the root beer brand refers to BrandName; advertised on facebook refers to FacebookPage IS not NULL;
SQL: SELECT BrandName FROM rootbeerbrand WHERE FacebookPage IS NOT NULL

Database: movie_platform
Question: From all the movies that got more than 13000 popularity number, which one had the least ratings.
Evidence: more than 13000 popularity number refers to movie_popularity > 13000; least ratings refers to MIN(rating_score)
SQL: SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_popularity > 13000 ORDER BY T1.rating_score LIMIT 1

Database: synthea
Question: List down the address of patients who have billable period in 2010.
SQL: SELECT DISTINCT T1.address FROM patients AS T1 INNER JOIN claims AS T2 ON T1.patient = T2.PATIENT WHERE T2.BILLABLEPERIOD LIKE '2010%'

Database: movies_4
Question: Give the name of the movie with a revenue of 559852396.
Evidence: name of the movie refers to title; revenue of 559852396 refers to revenue = '559852396'
SQL: SELECT title FROM movie WHERE revenue = 559852396

Database: simpson_episodes
Question: What is the birth name of the person who voiced 'Helen Lovejoy?'
Evidence: voiced refers to role; role = 'Helen Lovejoy"
SQL: SELECT DISTINCT T1.birth_name FROM Person AS T1 INNER JOIN Credit AS T2 ON T1.name = T2.person WHERE T2.role = 'Helen Lovejoy';