What are the names of the directors who made exactly one movie?
SELECT director FROM Movie GROUP BY director HAVING count(*)  =  1
directors who made exactly one movie refers to COUNT(*) = 1; names of the directors refers to SELECT director;