What is the Bulgarian Commander in Autumn 1040 at the Battle of Thessalonica?
CREATE TABLE table_name_41 (bulgarian_commander VARCHAR, battle VARCHAR, date VARCHAR)
SELECT bulgarian_commander FROM table_name_41 WHERE battle = "battle of thessalonica" AND date = "autumn 1040"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_41 (bulgarian_commander VARCHAR, battle VARCHAR, date VARCHAR) Question: What is the Bulgarian Commander in Autumn 1040 at the Battle of Thessalonica? [/INST] SELECT bulgarian_commander FROM table_name_41 WHERE battle = "battle of thessalonica" AND date = "autumn 1040" </s>