What are the names of the directors who made exactly one movie?
CREATE TABLE Movie (director VARCHAR)
SELECT director FROM Movie GROUP BY director HAVING COUNT(*) = 1
### Context: CREATE TABLE Movie (director VARCHAR) ### Question: What are the names of the directors who made exactly one movie? ### Answer: SELECT director FROM Movie GROUP BY director HAVING COUNT(*) = 1