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

Find all movies that star both ' Angelina Jolie ' and ' Brad Pitt
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 = 'Angelina Jolie' AND ACTOR_1.name = 'Brad Pitt' 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" "ACTOR_0" JOIN "actor" "ACTOR_1" ON "ACTOR_1"."name" = 'Brad Pitt' JOIN "cast" "CAST_0" ON "ACTOR_0"."aid" = "CAST_0"."aid" JOIN "cast" "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" = 'Angelina Jolie'