7 lines
310 B
MySQL
7 lines
310 B
MySQL
|
select title from movies
|
||
|
join stars on people.id = stars.person_id
|
||
|
join people on stars.movie_id = movies.id
|
||
|
where people.name = "Johnny Depp" and title in (select title from movies
|
||
|
join stars on people.id = stars.person_id
|
||
|
join people on stars.movie_id = movies.id
|
||
|
where people.name = "Helena Bonham Carter");
|