Hello!  Can you show me a list of all director names who have directed more than one movie?
select distinct t1.director from movie as t1 join movie as t2 on t1.director = t2.director where t1.title ! = t2.title
This is great!  Can you please update the list to show each of the films directed by each director and keep the director names in the list?
select t1.director, t1.title from movie as t1 join movie as t2 on t1.director = t2.director where t1.title ! = t2.title
Wonderful!  Can you please sort this list by the director name, and then sort by movie title?
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
Excellent!  Would you be able to update that list to also include the year each film was released?
select t1.title, t1.director, t1.year from movie as t1 join movie as t2 on t1.director = t2.director where t1.title ! = t2.title order by t1.director, t1.title