sql - #sql 查找出演过所有科恩电影的演员

Question

答案应该是 McDormand 这里是电影桌

这是行为表

标签： sqlrdbms

Answer 1

你可以试试下面的 - DEMO Here

SELECT a.actor
FROM movies m
    INNER JOIN actors a ON a.title = m.title
WHERE m.director = 'Coen'
group by a.actor
having count(*)=(select count(distinct title) from movies where director = 'Coen')