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 other than NULL.
select director from movie where director != "null" group by director having count(*) = 1