-- Database schema
| Movie : mID [ INT ] primary_key , title [ TEXT ] , year [ INT ] , director [ TEXT ] | Reviewer : rID [ INT ] primary_key , name [ TEXT ] | Rating : rID [ INT ] Rating.rID = Reviewer.rID , mID [ INT ] Rating.mID = Movie.mID , stars [ INT ] , ratingDate [ 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");