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

What movies have the same director as the movie ' Revolutionary Road ' ?
SELECT MOVIE_1.title FROM directed_by AS DIRECTED_BY_0, directed_by AS DIRECTED_BY_1, director, movie AS MOVIE_0, movie AS MOVIE_1 WHERE director.did = DIRECTED_BY_0.did AND director.did = DIRECTED_BY_1.did AND MOVIE_0.mid = DIRECTED_BY_0.msid AND MOVIE_0.title = 'Revolutionary Road' AND MOVIE_1.mid = DIRECTED_BY_1.msid
SELECT "MOVIE_1"."title" FROM "directed_by" "DIRECTED_BY_0" JOIN "movie" "MOVIE_0" ON "DIRECTED_BY_0"."msid" = "MOVIE_0"."mid" AND "MOVIE_0"."title" = 'Revolutionary Road' JOIN "director" ON "DIRECTED_BY_0"."did" = "director"."did" JOIN "directed_by" "DIRECTED_BY_1" ON "DIRECTED_BY_1"."did" = "director"."did" JOIN "movie" "MOVIE_1" ON "DIRECTED_BY_1"."msid" = "MOVIE_1"."mid"