How many movies are in the list?
select count ( * ) from movie
How many directors are on the list?
select count ( director ) from movie
How many of the directors have more than 1 film?
select count ( distinct t1.director ) from movie as t1 join movie as t2 on t1.director = t2.director where t1.title ! = t2.title
What are the titles from those 2 directors?
select t1.title from movie as t1 join movie as t2 on t1.director = t2.director where t1.title ! = t2.title
What are the years each of these movies were produced?
select t1.year from movie as t1 join movie as t2 on t1.director = t2.director where t1.title ! = t2.title