What were the years of senior status for active service in 1972–1995?
CREATE TABLE table_name_53 (senior_status VARCHAR, active_service VARCHAR)
SELECT senior_status FROM table_name_53 WHERE active_service = "1972–1995"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_53 (senior_status VARCHAR, active_service VARCHAR) Question: What were the years of senior status for active service in 1972–1995? [/INST] SELECT senior_status FROM table_name_53 WHERE active_service = "1972–1995" </s>