CREATE TABLE culture_company (company_name CLOB, type CLOB, incorporated_in CLOB, group_equity_shareholding NUMBER, book_club_id CLOB, movie_id CLOB)
CREATE TABLE movie (movie_id NUMBER, title CLOB, year NUMBER, director CLOB, budget_million NUMBER, gross_worldwide NUMBER)
CREATE TABLE book_club (book_club_id NUMBER, year NUMBER, author_or_editor CLOB, book_title CLOB, publisher CLOB, category CLOB, result CLOB)

Show all director names who have a movie in both year 1999 and 2000.
SELECT director FROM movie WHERE year = 2000 INTERSECT SELECT director FROM movie WHERE year = 1999
SELECT "director" FROM "movie" WHERE "year" = 2000 INTERSECT SELECT "director" FROM "movie" WHERE "year" = 1999