What year was The Horn Blows at Midnight, directed by Raoul Walsh?
CREATE TABLE table_name_96 (year INTEGER, director VARCHAR, title VARCHAR)
SELECT AVG(year) FROM table_name_96 WHERE director = "raoul walsh" AND title = "the horn blows at midnight"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_96 (year INTEGER, director VARCHAR, title VARCHAR) Question: What year was The Horn Blows at Midnight, directed by Raoul Walsh? [/INST] SELECT AVG(year) FROM table_name_96 WHERE director = "raoul walsh" AND title = "the horn blows at midnight" </s>