CREATE TABLE keyword (id INT, keyword TEXT)
CREATE TABLE producer (pid INT, gender TEXT, name TEXT, nationality TEXT, birth_city TEXT, birth_year INT)
CREATE TABLE writer (wid INT, gender TEXT, name TEXT, nationality TEXT, birth_city TEXT, birth_year INT)
CREATE TABLE actor (aid INT, gender TEXT, name TEXT, nationality TEXT, birth_city TEXT, birth_year INT)
CREATE TABLE genre (gid INT, genre TEXT)
CREATE TABLE tv_series (sid INT, title TEXT, release_year INT, num_of_seasons INT, num_of_episodes INT, title_aka TEXT, budget TEXT)
CREATE TABLE copyright (id INT, msid INT, cid INT)
CREATE TABLE company (id INT, name TEXT, country_code VARCHAR)
CREATE TABLE written_by (id INT, msid INT, wid INT)
CREATE TABLE movie (mid INT, title TEXT, release_year INT, title_aka TEXT, budget TEXT)
CREATE TABLE classification (id INT, msid INT, gid INT)
CREATE TABLE tags (id INT, msid INT, kid INT)
CREATE TABLE director (did INT, gender TEXT, name TEXT, nationality TEXT, birth_city TEXT, birth_year INT)
CREATE TABLE made_by (id INT, msid INT, pid INT)
CREATE TABLE cast (id INT, msid INT, aid INT, role TEXT)
CREATE TABLE directed_by (id INT, msid INT, did INT)

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