What are all the directors?
select distinct director from movie
How many movies did each of them direct?
select count(*), director from movie group by director
Show me those who directed exactly one movie.
select director from movie group by director having count(*) = 1