CREATE TABLE film_market_estimation (market_id VARCHAR2)
CREATE TABLE film (title VARCHAR2, director VARCHAR2, film_id VARCHAR2, country VARCHAR2)
CREATE TABLE market (Market_ID VARCHAR2)

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')