CREATE TABLE table_9580 ("Name" TEXT, "Rank" TEXT, "Tenure" TEXT, "Date of death" TEXT, "Cause of death" TEXT)

What is gunfire victim Maria Cecilia Rosa with 6 years of Tenure Date of Death?
SELECT "Date of death" FROM table_9580 WHERE "Cause of death" = 'gunfire' AND "Tenure" = '6 years' AND "Name" = 'maria cecilia rosa'
SELECT "Date of death" FROM "table_9580" WHERE "Cause of death" = 'gunfire' AND "Name" = 'maria cecilia rosa' AND "Tenure" = '6 years'