-- Database schema
| Movie : mID [ INT ] primary_key , title [ TEXT ] , year [ INT ] , director [ TEXT ] | Reviewer : rID [ INT ] primary_key , name [ TEXT ] | Rating : rID [ INT ] Rating.rID = Reviewer.rID , mID [ INT ] Rating.mID = Movie.mID , stars [ INT ] , ratingDate [ TEXT ] |
-- -- 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;