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