Database: imdb
Question: Find all the female actors born in " New York City " after 1980
SQL:
SELECT name FROM actor WHERE birth_city  =  "New York City" AND birth_year  >  1980 AND gender  =  "female";