What were the birth and death years when active service was 1972–1995?
CREATE TABLE table_name_54 (born_died VARCHAR, active_service VARCHAR)
SELECT born_died FROM table_name_54 WHERE active_service = "1972–1995"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_54 (born_died VARCHAR, active_service VARCHAR) Question: What were the birth and death years when active service was 1972–1995? [/INST] SELECT born_died FROM table_name_54 WHERE active_service = "1972–1995" </s>