7 lines
310 B
SQL
7 lines
310 B
SQL
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"); |