I'm stuck in PSET7 SQL part 1 question 12:
I want to list all movies with 2 people inside.
The JOIN of the 3 table is set, the problem is in my WHERE statement:
WHERE people.name = 'Johnny Depp' AND people.name = 'Helena Bonham Carter'
The output is 0 => should be something like 4 or 5 movies.
I can't find how to do check for 2 conditions in the same table.
Thanks in advance,