Who was the director for To Have and Have Not, earlier than 1945 with WB studio?
CREATE TABLE table_name_61 (director VARCHAR, title VARCHAR, studio VARCHAR, year VARCHAR)
SELECT director FROM table_name_61 WHERE studio = "wb" AND year < 1945 AND title = "to have and have not"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_61 (director VARCHAR, title VARCHAR, studio VARCHAR, year VARCHAR) Question: Who was the director for To Have and Have Not, earlier than 1945 with WB studio? [/INST] SELECT director FROM table_name_61 WHERE studio = "wb" AND year < 1945 AND title = "to have and have not" </s>