What are the titles and directors of all movies that have a rating higher than the average James Cameron film rating?
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")
titles and directors of movies = SELECT title, director; movies that have a rating higher than = WHERE stars >; average film rating of a specific director (James Cameron) = (SELECT AVG(stars) ... WHERE director = 'James Cameron');