CREATE TABLE table_45355 ("Rank" CLOB, "Badge/Serial Number" CLOB, "Tenure" CLOB, "Date of death" CLOB, "Cause of death" CLOB)

What is the Rank of the Officer with Badge/Serial Number 11755 who died in Gunfire?
SELECT "Rank" FROM table_45355 WHERE "Cause of death" = 'gunfire' AND "Badge/Serial Number" = '11755'
SELECT "Rank" FROM "table_45355" WHERE "Badge/Serial Number" = '11755' AND "Cause of death" = 'gunfire'