What are the names of all directors who have made one movie except for the director named NULL?
SELECT director FROM Movie WHERE director != "null" GROUP BY director HAVING count(*)  =  1
directors who have made one movie = HAVING COUNT(*) = 1; except for the director named NULL refers to WHERE director != 'null';