Which locomotive type has a status in static display
CREATE TABLE table_15827397_1 (locomotive_type VARCHAR, status VARCHAR)
SELECT locomotive_type FROM table_15827397_1 WHERE status = "Static display"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_15827397_1 (locomotive_type VARCHAR, status VARCHAR) Question: Which locomotive type has a status in static display [/INST] SELECT locomotive_type FROM table_15827397_1 WHERE status = "Static display" </s>