Show all director names.
select director from movie
Who has a movie in 1999?
select director from movie where year = 1999
Who has a movie in 2000?
select director from movie where year = 2000
Who has movies in both years?
select director from movie where year = 2000 intersect select director from movie where year = 1999