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
What is the nationality of the actress ' Christoph Waltz ' ?
assistant
SELECT nationality FROM actor WHERE name = 'Christoph Waltz';
human
What are the series featuring ' Scott Foley ' ?
assistant
SELECT t2.title FROM CAST AS t3 JOIN actor AS t1 ON t3.aid = t1.aid JOIN tv_series AS t2 ON t2.sid = t3.msid WHERE t1.name = 'Scott Foley';
human
Find all the female actors from Austin
assistant
SELECT name FROM actor WHERE birth_city = 'Austin' AND gender = 'female';
human
What is the nationality of ' Kevin Spacey ' ?
assistant
SELECT nationality FROM director WHERE name = 'director_name0';
human
Who is the director of the tv series ' House of Cards ' from 2013 ?
assistant
SELECT t2.name FROM director AS t2 JOIN directed_by AS t1 ON t2.did = t1.did JOIN tv_series AS t3 ON t3.sid = t1.msid WHERE t3.release_year = 2013 AND t3.title = 'House of Cards';
human
Who acts ' Olivia Pope ' in the series Scandal ?
assistant
SELECT t1.name FROM CAST AS t3 JOIN actor AS t1 ON t3.aid = t1.aid JOIN tv_series AS t2 ON t2.sid = t3.msid WHERE t3.role = "Olivia Pope" AND t2.title = "Scandal" ;