What is the Rank of the Officer with Badge/Serial Number 11755 who died in Gunfire?
CREATE TABLE table_name_17 (rank VARCHAR, cause_of_death VARCHAR, badge_serial_number VARCHAR)
SELECT rank FROM table_name_17 WHERE cause_of_death = "gunfire" AND badge_serial_number = "11755"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_17 (rank VARCHAR, cause_of_death VARCHAR, badge_serial_number VARCHAR) Question: What is the Rank of the Officer with Badge/Serial Number 11755 who died in Gunfire? [/INST] SELECT rank FROM table_name_17 WHERE cause_of_death = "gunfire" AND badge_serial_number = "11755" </s>