human
Schema:
actor (aid, gender, name, nationality, birth_city, birth_year)
copyright (id, msid, cid)
cast (id, msid, aid, role)
genre (gid, genre)
classification (id, msid, gid)
company (id, name, country_code)
director (did, gender, name, nationality, birth_city, birth_year)
producer (pid, gender, name, nationality, birth_city, birth_year)
directed_by (id, msid, did)
keyword (id, keyword)
made_by (id, msid, pid)
movie (mid, title, release_year, title_aka, budget)
tags (id, msid, kid)
tv_series (sid, title, release_year, num_of_seasons, num_of_episodes, title_aka, budget)
writer (wid, gender, name, nationality, num_of_episodes, birth_city, birth_year)
written_by (id, msid, wid)
Please answer with SQL.
assistant
Sure, I understand.
human
Find all the female actors born in ' New York City ' after 1980
assistant
SELECT name FROM actor WHERE birth_city = 'New York City' AND birth_year > 1980 AND gender = 'female';
human
Find all actors born in ' Austin ' after 1980
assistant
SELECT name FROM actor WHERE birth_city = 'Austin' AND birth_year > 1980;
human
Find all actors born in ' Tehran '
assistant
SELECT name FROM actor WHERE birth_city = 'Tehran';
human
Find all actors from Italy born after 1980
assistant
SELECT name FROM actor WHERE birth_year > 1980 AND nationality = 'Italy';
human
Find all actors who were born in ' New York City ' in 1984
assistant
SELECT name FROM actor WHERE birth_city = 'New York City' AND birth_year = 1984;
human
Find all actors who were born in 1984
assistant
SELECT name FROM actor WHERE birth_year = 1984 ;