Who directs before 1948 with linda darnell, titled blood and sand?
CREATE TABLE table_name_55 (director VARCHAR, title VARCHAR, year VARCHAR, leading_lady VARCHAR)
SELECT director FROM table_name_55 WHERE year < 1948 AND leading_lady = "linda darnell" AND title = "blood and sand"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_55 (director VARCHAR, title VARCHAR, year VARCHAR, leading_lady VARCHAR) Question: Who directs before 1948 with linda darnell, titled blood and sand? [/INST] SELECT director FROM table_name_55 WHERE year < 1948 AND leading_lady = "linda darnell" AND title = "blood and sand" </s>