What was the career SR with a value of A in 1980 and F in 1997?
CREATE TABLE table_name_47 (career_sr VARCHAR)
SELECT career_sr FROM table_name_47 WHERE 1989 = "a" AND 1997 = "f"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (career_sr VARCHAR) Question: What was the career SR with a value of A in 1980 and F in 1997? [/INST] SELECT career_sr FROM table_name_47 WHERE 1989 = "a" AND 1997 = "f" </s>