Task: Text to Code
Input (English): SQL: SELECT title , title FROM Movie GROUP BY director HAVING Count ( * ) > 1
Feedback: Replace second title with director , make sure to order by director name then movie title
Output (English): 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