How many directors are there?
select count ( distinct director ) from movie
How many of them only made one movie?
select count ( * ) from ( select director from movie group by director having count ( * ) = 1 )
What are the names of those directors?
select director from movie group by director having count ( * ) = 1