Name the award for candida scott knight
CREATE TABLE table_name_78 (award VARCHAR, director_s_ VARCHAR)
SELECT award FROM table_name_78 WHERE director_s_ = "candida scott knight"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_78 (award VARCHAR, director_s_ VARCHAR) Question: Name the award for candida scott knight [/INST] SELECT award FROM table_name_78 WHERE director_s_ = "candida scott knight" </s>