CREATE TABLE table_name_47 (date_of_death VARCHAR2, name VARCHAR2, cause_of_death VARCHAR2, tenure VARCHAR2)

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