CREATE TABLE written_by (id INT, msid INT, wid INT)
CREATE TABLE keyword (id INT, keyword TEXT)
CREATE TABLE cast (id INT, msid INT, aid INT, role TEXT)
CREATE TABLE actor (aid INT, gender TEXT, name TEXT, nationality TEXT, birth_city TEXT, birth_year INT)
CREATE TABLE company (id INT, name TEXT, country_code VARCHAR)
CREATE TABLE writer (wid INT, gender TEXT, name TEXT, nationality TEXT, birth_city TEXT, birth_year INT)
CREATE TABLE tv_series (sid INT, title TEXT, release_year INT, num_of_seasons INT, num_of_episodes INT, title_aka TEXT, budget TEXT)
CREATE TABLE directed_by (id INT, msid INT, did INT)
CREATE TABLE made_by (id INT, msid INT, pid INT)
CREATE TABLE movie (mid INT, title TEXT, release_year INT, title_aka TEXT, budget TEXT)
CREATE TABLE classification (id INT, msid INT, gid INT)
CREATE TABLE tags (id INT, msid INT, kid INT)
CREATE TABLE producer (pid INT, gender TEXT, name TEXT, nationality TEXT, birth_city TEXT, birth_year INT)
CREATE TABLE genre (gid INT, genre TEXT)
CREATE TABLE copyright (id INT, msid INT, cid INT)
CREATE TABLE director (did INT, gender TEXT, name TEXT, nationality TEXT, birth_city TEXT, birth_year INT)

Find all movies featuring ' Benedict Cumberbatch ' and ' Keira Knightley
SELECT movie.title FROM actor AS ACTOR_0, actor AS ACTOR_1, cast AS CAST_0, cast AS CAST_1, movie WHERE ACTOR_0.name = 'Benedict Cumberbatch' AND ACTOR_1.name = 'Keira Knightley' AND CAST_0.aid = ACTOR_0.aid AND CAST_1.aid = ACTOR_1.aid AND movie.mid = CAST_0.msid AND movie.mid = CAST_1.msid
SELECT "movie"."title" FROM "actor" AS "ACTOR_0" JOIN "actor" AS "ACTOR_1" ON "ACTOR_1"."name" = 'Keira Knightley' JOIN "cast" AS "CAST_0" ON "ACTOR_0"."aid" = "CAST_0"."aid" JOIN "cast" AS "CAST_1" ON "ACTOR_1"."aid" = "CAST_1"."aid" JOIN "movie" ON "CAST_0"."msid" = "movie"."mid" AND "CAST_1"."msid" = "movie"."mid" WHERE "ACTOR_0"."name" = 'Benedict Cumberbatch'