What are the titles and directors of the movies whose star is greater than the average stars of the movies directed by James Cameron?
CREATE TABLE Rating (
    mID VARCHAR,
    stars INTEGER
)

CREATE TABLE Movie (
    title VARCHAR,
    director VARCHAR,
    mID VARCHAR
)
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")
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the titles and directors of the movies whose star is greater than the average stars of the movies directed by James Cameron? ### Input: CREATE TABLE Rating (
    mID VARCHAR,
    stars INTEGER
)

CREATE TABLE Movie (
    title VARCHAR,
    director VARCHAR,
    mID VARCHAR
) ### Response: 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")