CREATE TABLE genre (gid NUMBER, genre CLOB)
CREATE TABLE actor (aid NUMBER, gender CLOB, name CLOB, nationality CLOB, birth_city CLOB, birth_year NUMBER)
CREATE TABLE writer (wid NUMBER, gender CLOB, name CLOB, nationality CLOB, birth_city CLOB, birth_year NUMBER)
CREATE TABLE classification (id NUMBER, msid NUMBER, gid NUMBER)
CREATE TABLE company (id NUMBER, name CLOB, country_code VARCHAR2)
CREATE TABLE keyword (id NUMBER, keyword 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 cast (id NUMBER, msid NUMBER, aid NUMBER, role CLOB)
CREATE TABLE director (did NUMBER, gender CLOB, name CLOB, nationality CLOB, birth_city CLOB, birth_year NUMBER)
CREATE TABLE directed_by (id NUMBER, msid NUMBER, did NUMBER)
CREATE TABLE producer (pid NUMBER, gender CLOB, name CLOB, nationality CLOB, birth_city CLOB, birth_year NUMBER)
CREATE TABLE tags (id NUMBER, msid NUMBER, kid NUMBER)
CREATE TABLE copyright (id NUMBER, msid NUMBER, cid NUMBER)
CREATE TABLE made_by (id NUMBER, msid NUMBER, pid NUMBER)
CREATE TABLE movie (mid NUMBER, title CLOB, release_year NUMBER, title_aka CLOB, budget CLOB)
CREATE TABLE written_by (id NUMBER, msid NUMBER, wid NUMBER)

Find all movies featuring both ' Matt Damon ' and ' Ben Affleck
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 = 'Matt Damon' AND ACTOR_1.name = 'Ben Affleck' 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" = 'Ben Affleck' 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" = 'Matt Damon'