What are the names of the directors who made exactly one movie excluding director NULL?
create table movie (director varchar, PRIMARY KEY (director))
select director from movie where director <> "null" group by director having count(*) = 1