SCHEMA:
CREATE TABLE Movie (director VARCHAR)
USER:
What are the names of the directors who made exactly one movie excluding director NULL?

QUERY:
SELECT director FROM Movie WHERE director <> "null" GROUP BY director HAVING COUNT(*) = 1