CREATE TABLE table_name_41 (bulgarian_commander VARCHAR2, battle VARCHAR2, date VARCHAR2)

What is the Bulgarian Commander in Autumn 1040 at the Battle of Thessalonica?
SELECT bulgarian_commander FROM table_name_41 WHERE battle = "battle of thessalonica" AND date = "autumn 1040"
SELECT "bulgarian_commander" FROM "table_name_41" WHERE "autumn 1040" = "date" AND "battle of thessalonica" = "battle"