CREATE TABLE Movie (director VARCHAR2)

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