Which Locomotive Entered Service in November 1984 and has an Operator of Southern Shorthaul Railroad?
CREATE TABLE table_name_59 (locomotive VARCHAR, operator VARCHAR, entered_service VARCHAR)
SELECT locomotive FROM table_name_59 WHERE operator = "southern shorthaul railroad" AND entered_service = "november 1984"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_59 (locomotive VARCHAR, operator VARCHAR, entered_service VARCHAR) Question: Which Locomotive Entered Service in November 1984 and has an Operator of Southern Shorthaul Railroad? [/INST] SELECT locomotive FROM table_name_59 WHERE operator = "southern shorthaul railroad" AND entered_service = "november 1984" </s>