For each director, what are the titles and ratings for all the movies they reviewed?
select t2.title, t1.stars, t2.director, max(t1.stars) from rating as t1 join movie as t2 on t1.mid = t2.mid where director != "null" group by director