What are the names of the directors who made exactly one movie excluding director NULL?
CREATE TABLE Movie (director VARCHAR)
SELECT director FROM Movie WHERE director <> "null" GROUP BY director HAVING COUNT(*) = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Movie (director VARCHAR) Question: What are the names of the directors who made exactly one movie excluding director NULL? [/INST] SELECT director FROM Movie WHERE director <> "null" GROUP BY director HAVING COUNT(*) = 1 </s>