Database: movie_1
Question: What are the names of the directors who made exactly one movie excluding director NULL?
SQL:
SELECT director FROM Movie WHERE director != "null" GROUP BY director HAVING count(*)  =  1