Which active services years ended in death and had senior status in 1972–2005?
CREATE TABLE table_name_72 (active_service VARCHAR, reason_for_termination VARCHAR, senior_status VARCHAR)
SELECT active_service FROM table_name_72 WHERE reason_for_termination = "death" AND senior_status = "1972–2005"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_72 (active_service VARCHAR, reason_for_termination VARCHAR, senior_status VARCHAR) Question: Which active services years ended in death and had senior status in 1972–2005? [/INST] SELECT active_service FROM table_name_72 WHERE reason_for_termination = "death" AND senior_status = "1972–2005" </s>