What is the Rank of the Officer with Badge/Serial Number 11755 who died in Gunfire?
CREATE TABLE "officers" (
  "rank" text,
  "badge_serial_number" text,
  "tenure" text,
  "date_of_death" text,
  "cause_of_death" text
);
SELECT "rank" FROM "officers" WHERE "cause_of_death"='gunfire' AND "badge_serial_number"='11755';