For all directors who have directed more than one movie, what movies have they directed and what are their names?
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
directors who have directed more than one movie refers to the need for grouping movies by director and filtering those with a count greater than 1; movies they directed refers to movie titles; their names refer to director names;