CREATE TABLE market (market_id NUMBER, country CLOB, number_cities NUMBER)
CREATE TABLE film_market_estimation (estimation_id NUMBER, low_estimate NUMBER, high_estimate NUMBER, film_id NUMBER, type CLOB, market_id NUMBER, year NUMBER)
CREATE TABLE film (film_id NUMBER, title CLOB, studio CLOB, director CLOB, gross_in_dollar NUMBER)

What are the titles and directors of the films were never presented in China?
SELECT title, director FROM film WHERE NOT film_id IN (SELECT film_id FROM film_market_estimation AS T1 JOIN market AS T2 ON T1.market_id = T2.market_id WHERE country = 'China')
SELECT "title", "director" FROM "film" WHERE NOT "film_id" IN (SELECT "film_id" FROM "film_market_estimation" "T1" JOIN "market" "T2" ON "T1"."market_id" = "T2"."market_id" WHERE "country" = 'China')