What are the names of the directors who made exactly one movie excluding director NULL?
CREATE TABLE Movie (director VARCHAR)
[SQL] SELECT director FROM Movie WHERE director <> "null" GROUP BY director HAVING COUNT(*) = 1 [/SQL]