Database: movie_1
Question: For all directors who have directed more than one movie, what movies have they directed and what are their names?
SQL:
SELECT T1.title ,  T1.director FROM Movie AS T1 JOIN Movie AS T2 ON T1.director  =  T2.director WHERE T1.title != T2.title ORDER BY T1.director ,  T1.title