CREATE TABLE Rating (mID VARCHAR(255), stars INTEGER); CREATE TABLE Movie (title VARCHAR(255), director VARCHAR(255), mID VARCHAR(255))
What are the titles and directors of the movies whose star is greater than the average stars of the movies directed by James Cameron?
    
SQL: 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")