What are the names of the directors who made exactly one movie excluding director NULL?
select director from movie where director != "null" group by director having count(*) = 1