SELECT director FROM Movie GROUP BY director HAVING count(*)  =  1
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 ( * ) = value
What are the names of the directors who made exactly one movie ?