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
directors who made exactly one movie refers to COUNT(*) = 1; excluding director NULL refers to WHERE director != 'null';