CREATE TABLE rating (rid DECIMAL, mid DECIMAL, stars DECIMAL, ratingdate TIME)
CREATE TABLE movie (mid DECIMAL, title TEXT, year DECIMAL, director TEXT)
CREATE TABLE reviewer (rid DECIMAL, name TEXT)

What are the titles and directors of the movies whose star is greater than the average stars of the movies directed by James Cameron?
SELECT T2.title, T2.director FROM rating AS T1 JOIN movie AS T2 ON T1.mid = T2.mid WHERE T1.stars > (SELECT AVG(T1.stars) FROM rating AS T1 JOIN movie AS T2 ON T1.mid = T2.mid WHERE T2.director = "James Cameron")
WITH "_u_0" AS (SELECT AVG("T1"."stars"), "T2"."director" AS "_u_1" FROM "rating" AS "T1" JOIN "movie" AS "T2" ON "T1"."mid" = "T2"."mid" GROUP BY "T2"."director") SELECT "T2"."title", "T2"."director" FROM "rating" AS "T1" LEFT JOIN "_u_0" AS "_u_0" ON "James Cameron" = "_u_0"."_u_1" JOIN "movie" AS "T2" ON "T1"."mid" = "T2"."mid" WHERE "T1"."stars" > "_u_0".""