user: ### NOW ANSWER:
Question: What is the Rank of the Officer with Badge/Serial Number 11755 who died in Gunfire?
Columns: ['Rank', 'Badge/Serial Number', 'Tenure', 'Date of death', 'Cause of death']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['City Marshal', '—', '—', '1853', 'Gunfire']
SQL:

assistant: SELECT "Rank" FROM "Table" WHERE "Cause of death" = 'Gunfire' AND "Badge/Serial Number" = '11755';