Database: legislator
Question: What are the full names of the non-google female entity legislators that have not been registered in Federal Election Commission data?
Evidence: full names = first_name, last_name; non-google entity refers to google_entity_id_id is null; female refers to gender_bio = 'F'; have not been registered in Federal Election Commission data refers to fec_id is null;
SQL: SELECT first_name, last_name FROM historical WHERE gender_bio = 'F' AND google_entity_id_id IS NULL AND fec_id IS NULL

Database: retail_world
Question: List all the product names and categories of the highest reorder level.
Evidence: Highest reorder level refers to Max(ReorderLevel)
SQL: SELECT T2.ProductName, T1.CategoryName FROM Categories AS T1 INNER JOIN Products AS T2 ON T1.CategoryID = T2.CategoryID ORDER BY T2.ReorderLevel DESC LIMIT 1

Database: simpson_episodes
Question: Please provide any two episodes' names that have the same keyword of "1930s to 2020s".
SQL: SELECT T1.title FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id WHERE T2.keyword = '1930s to 2020s' LIMIT 2;

Database: food_inspection
Question: Please list the descriptions of all the high risk violations of Tiramisu Kitchen.
Evidence: Tiramisu Kitchen is the name of the business; high risk violations refer to risk_category = 'High Risk';
SQL: SELECT DISTINCT T1.description FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.risk_category = 'High Risk' AND T2.name = 'Tiramisu Kitchen'

Database: shakespeare
Question: Please name the latest historical work.
Evidence: name refers to LongTitle; latest historical work refers to GenreType = 'History' and max(Date)
SQL: SELECT LongTitle FROM works WHERE GenreType = 'History' ORDER BY Date DESC LIMIT 1

Database: world
Question: What is the local name of the country where "The Valley" city belongs?
SQL: SELECT T2.LocalName FROM City AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.Code WHERE T1.Name = 'The Valley'

Database: soccer_2016
Question: In how many games in which the batting team was the Delhi Daredevils were no runs scored?
Evidence: batting team was the Delhi Daredevils refers to Team_Name = 'Delhi Daredevils' and Team_1 = Team_Id where Team_Batting = 1 or Team_2 = Team_Id where Team_Batting = 2; no runs scored refers to Runs_Scored = 0
SQL: SELECT COUNT(T1.Runs_Scored) FROM Batsman_Scored AS T1 INNER JOIN Ball_by_Ball AS T2 ON T1.Match_Id = T2.Match_Id INNER JOIN Match AS T3 ON T2.Match_Id = T3.Match_Id INNER JOIN Team AS T4 ON T3.Team_1 = T4.Team_Id WHERE T2.Team_Batting = 1 OR T2.Team_Batting = 2 AND T4.Team_Name = 'Delhi Daredevils'

Database: video_games
Question: What publishers have the word 'Entertainment' in their name?
Evidence: publishers that have the word 'Entertainment' in their name refers to publisher_name LIKE '%Entertainment%';
SQL: SELECT T.publisher_name FROM publisher AS T WHERE T.publisher_name LIKE '%Entertainment%'

Database: computer_student
Question: Which course has more teachers, course no.16 or course no.18?
Evidence: teachers refers to taughtBy.p_id; course no.16 refers to course_id = 16; course no.18 refers to course_id = 18
SQL: SELECT course_id FROM taughtBy WHERE course_id = 11 OR course_id = 18 GROUP BY course_id ORDER BY COUNT(course_id) DESC LIMIT 1

Database: address
Question: List all representatives of districts which have more than 30 000 population in 2020.
Evidence: more than 30000 population in 2020 refers to population_2020 > 30000; representative refers to first_name, last_name
SQL: SELECT 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 WHERE T1.population_2020 > 30000 GROUP BY T3.first_name, T3.last_name

Database: video_games
Question: In 2010, how many PS3 games were released?
Evidence: in 2010 refers to release_year = 2010; PS3 refers to platform_name = 'PS3';
SQL: SELECT COUNT(T3.game_id) FROM platform AS T1 INNER JOIN game_platform AS T2 ON T1.id = T2.platform_id INNER JOIN game_publisher AS T3 ON T2.game_publisher_id = T3.id WHERE T1.platform_name = 'PS3' AND T2.release_year = 2010

Database: public_review_platform
Question: What percentage more for the "Women's Clothing" Yelp businesses to "Men's Clothing"?
Evidence: Women's clothing refers to category_name = 'Women''s Clothing'; Men's clothing refers to category_name = 'Men''s Clothing'; percentage more = MULTIPLY(DIVIDE(SUBTRACT(SUM(category_name = 'Women''s Clothing'), SUM(category_name = 'Men''s Clothing')), COUNT(business_id)), 1.0);
SQL: SELECT CAST(SUM(CASE WHEN T2.category_name LIKE 'Women''s Clothing' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.business_id) - CAST(SUM(CASE WHEN T2.category_name LIKE 'Men''s Clothing' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.business_id) AS "more percentage" FROM Business_Categories AS T1 INNER JOIN Categories AS T2 ON T1.category_id = T2.category_id

Database: world
Question: What is the average surface area of all countries?
Evidence: average surface area = AVG(SurfaceArea);
SQL: SELECT AVG(SurfaceArea) FROM Country

Database: movie_platform
Question: What is the URL to the movie director page on Mubi of the director whose movie was critic by user 2452551 and was given 39 likes?
Evidence: URL to the movie director page on Mubi refers to director_url; likes refers to critic_likes; critic_likes = 39;
SQL: SELECT T2.director_url FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.user_id = 2452551 AND T1.critic_likes = 39

Database: social_media
Question: Among all the tweets that are reshared, how many of them are posted by a user in Buenos Aires?
Evidence: reshared refers to Isreshare = 'TRUE'; 'Buenos Aires' is the City
SQL: SELECT COUNT(T1.TweetID) FROM twitter AS T1 INNER JOIN location AS T2 ON T2.LocationID = T1.LocationID WHERE T2.City = 'Buenos Aires' AND T1.IsReshare = 'TRUE'

Database: university
Question: Among all universities, how many female students were there in 2011?
Evidence: in 2011 refers to year = 2011; female students refers to SUM(DIVIDE(MULTIPLY(num_students, pct_female_students), 100))
SQL: SELECT SUM(CAST(num_students * pct_female_students AS REAL) / 100) FROM university_year WHERE year = 2011

Database: retail_complains
Question: What was the phone of number of the client who made the complaint call "CR0100432" ？
Evidence: complaint call refers to Complaint ID;
SQL: SELECT T1.phone FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.`Complaint ID` = 'CR0100432'

Database: cars
Question: Which country produced the car with the lowest mileage per gallon?
Evidence: the lowest mileage per gallon refers to min(mpg)
SQL: SELECT T3.country FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country ORDER BY T1.mpg ASC LIMIT 1

Database: beer_factory
Question: Which location sold more bottles of beer?
Evidence: location refers to LocationName; bottle of beer refers to ContainerType = 'Bottle'; location that sold more bottles of beer refers to MAX(COUNT(LocationID WHERE ContainerType = 'Bottle'));
SQL: SELECT T2.LocationName FROM rootbeer AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID WHERE T1.ContainerType = 'Bottle' GROUP BY T2.LocationID ORDER BY COUNT(T1.LocationID) DESC LIMIT 1

Database: movies_4
Question: How many times did Bob Peterson appear in the movie credits?
SQL: SELECT COUNT(T2.movie_id) FROM person AS T1 INNER JOIN movie_cast AS T2 ON T1.person_id = T2.person_id WHERE T1.person_name = 'Bob Peterson'