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
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
[{'title': 'Avatar', 'stars': 5, 'director': 'James Cameron', 'max(T1.stars)': 5}, {'title': 'The Sound of Music', 'stars': 3, 'director': 'Robert Wise', 'max(T1.stars)': 3}, {'title': 'Raiders of the Lost Ark', 'stars': 4, 'director': 'Steven Spielberg', 'max(T1.stars)': 4}, {'title': 'Gone with the Wind', 'stars': 4, 'director': 'Victor Fleming', 'max(T1.stars)': 4}]