user: Question: Who directs before 1948 with Linda Darnell, titled Blood and Sand?
Columns: ['Year', 'Title', 'Role', 'Leading Lady', 'Director']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [1940.0, 'Johnny Apollo', 'Bob Cain (Johnny Apollo)', 'Dorothy Lamour', 'Henry Hathaway']
SQL:

assistant: SELECT "Director" FROM "Table" WHERE "Year" < 1948.0 AND "Leading Lady" = 'Linda Darnell' AND "Title" = 'Blood and Sand';