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 book_club (book_club_id NUMBER, year NUMBER, author_or_editor CLOB, book_title CLOB, publisher CLOB, category CLOB, result CLOB)
CREATE TABLE movie (movie_id NUMBER, title CLOB, year NUMBER, director CLOB, budget_million NUMBER, gross_worldwide NUMBER)

What is the title and director for the movie with highest worldwide gross in the year 2000 or before?
SELECT title, director FROM movie WHERE year <= 2000 ORDER BY gross_worldwide DESC LIMIT 1
SELECT "title", "director" FROM "movie" WHERE "year" <= 2000 ORDER BY "gross_worldwide" DESC FETCH FIRST 1 ROWS ONLY