Database: movie_1
Question: For each director, what are the titles and ratings for all the movies they reviewed?
SQL:
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