我正在学习sql（lite3），在其中一个练习中，我需要检查imdb数据库中johnny depp和helena bonham carter主演的电影。
我得出了以下结论：

SELECT title 
FROM movies
WHERE movies.id IN (SELECT movies.id  
                    FROM movies
                    JOIN stars ON movies.id = stars.movie_id
                    JOIN people ON people.id = stars.person_id
                    WHERE name = "Jhonny Depp")
  AND movies.id IN (SELECT movies.id 
                    FROM movies
                    JOIN stars ON movies.id = stars.movie_id
                    JOIN people ON people.id = stars.person_id
                    WHERE name = "Helena Bonham Carter");

控制台正在返回
错误：靠近第1行：不明确的列名：id .schema 显示

CREATE TABLE movies 
(
    id INTEGER,
    title TEXT NOT NULL,
    year NUMERIC,
    PRIMARY KEY(id)
);
CREATE TABLE stars 
(
    movie_id INTEGER NOT NULL,
    person_id INTEGER NOT NULL,
    FOREIGN KEY(movie_id) REFERENCES movies(id),
    FOREIGN KEY(person_id) REFERENCES people(id)
);
CREATE TABLE directors 
(
    movie_id INTEGER NOT NULL,
    person_id INTEGER NOT NULL,
    FOREIGN KEY(movie_id) REFERENCES movies(id),
    FOREIGN KEY(person_id) REFERENCES people(id)
);
CREATE TABLE ratings 
(
    movie_id INTEGER NOT NULL,
    rating REAL NOT NULL,
    votes INTEGER NOT NULL,
    FOREIGN KEY(movie_id) REFERENCES movies(id)
);
CREATE TABLE people 
(
    id INTEGER,
    name TEXT NOT NULL,
    birth NUMERIC,
    PRIMARY KEY(id)
);

我不明白为什么它模棱两可。如果你能含糊其辞地把我推向正确的方向，我将不胜感激。提前谢谢！