Database: imdb
Question: How many female actors were born in " New York City " after 1980 ?
SQL:
SELECT COUNT ( DISTINCT name  ) FROM actor WHERE birth_city  =  "New York City" AND birth_year  >  1980 AND gender  =  "female";