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")