for type diesel-mechanical and configuration b-b, what is the status?
CREATE TABLE table_name_4 (status VARCHAR, configuration VARCHAR, type VARCHAR)
SELECT status FROM table_name_4 WHERE configuration = "b-b" AND type = "diesel-mechanical"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_4 (status VARCHAR, configuration VARCHAR, type VARCHAR) Question: for type diesel-mechanical and configuration b-b, what is the status? [/INST] SELECT status FROM table_name_4 WHERE configuration = "b-b" AND type = "diesel-mechanical" </s>