Table: lapd_officers_killed_in
Columns: rank
badge_serial_number
tenure
date_of_death
cause_of_death

Question: What is the Cause of death of the Officer with a Date of death of 1956-09-07?
SQL: SELECT "cause_of_death" FROM lapd_officers_killed_in WHERE "date_of_death" = '1956-09-07'

Question: What is the Tenure of the Officer who died in a helicopter accident with Badge/Serial Number 16805?
SQL: SELECT "tenure" FROM lapd_officers_killed_in WHERE "cause_of_death" = 'helicopter accident' AND "badge_serial_number" = '16805'

Question: What is the Badge/Serial Number of the Policeman who died in Gunfire on 1919-02-18?
SQL: SELECT "badge_serial_number" FROM lapd_officers_killed_in WHERE "rank" = 'policeman' AND "cause_of_death" = 'gunfire' AND "date_of_death" = '1919-02-18'

Question: What is the Rank of the Officer with Badge/Serial Number 11755 who died in Gunfire?
SQL: SELECT "rank" FROM lapd_officers_killed_in WHERE "cause_of_death" = 'gunfire' AND "badge_serial_number" = '11755'