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

find the number of actors from Iran who played in ' Jim Jarmusch ' movies
SELECT COUNT(DISTINCT (actor.name)) FROM actor, cast, directed_by, director, movie WHERE actor.nationality = 'Iran' AND cast.aid = actor.aid AND director.did = directed_by.did AND director.name = 'Jim Jarmusch' AND movie.mid = cast.msid AND movie.mid = directed_by.msid
SELECT COUNT(DISTINCT "actor"."name") FROM "actor" JOIN "cast" ON "actor"."aid" = "cast"."aid" JOIN "movie" ON "cast"."msid" = "movie"."mid" JOIN "directed_by" ON "directed_by"."msid" = "movie"."mid" JOIN "director" ON "directed_by"."did" = "director"."did" AND "director"."name" = 'Jim Jarmusch' WHERE "actor"."nationality" = 'Iran'