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

Find all actors who acted in the same movie as ' Tom Hanks
SELECT ACTOR_0.name FROM actor AS ACTOR_0, actor AS ACTOR_1, cast AS CAST_0, cast AS CAST_1, movie WHERE ACTOR_1.name = 'Tom Hanks' 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 "ACTOR_0"."name" FROM "actor" AS "ACTOR_0" JOIN "actor" AS "ACTOR_1" ON "ACTOR_1"."name" = 'Tom Hanks' 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"