Table: officers_killed_in_duty
Columns: name
rank
tenure
date_of_death
cause_of_death

Question: What is the Tenure of the Officer with a Date of death of 2001-08-31?
SQL: SELECT "tenure" FROM officers_killed_in_duty WHERE "date_of_death" = '2001-08-31'

Question: What is Detective Donald William Schneider's Cause of death?
SQL: SELECT "cause_of_death" FROM officers_killed_in_duty WHERE "rank" = 'detective' AND "name" = 'donald william schneider'

Question: What is Gary David Saunders' Tenure?
SQL: SELECT "tenure" FROM officers_killed_in_duty WHERE "name" = 'gary david saunders'

Question: What is gunfire victim Maria Cecilia Rosa with 6 years of Tenure Date of Death?
SQL: SELECT "date_of_death" FROM officers_killed_in_duty WHERE "cause_of_death" = 'gunfire' AND "tenure" = '6 years' AND "name" = 'maria cecilia rosa'