What is 1986, when 1978 is "A", when 1979 is "A", and when 1980 is "1R"?
CREATE TABLE table_name_99 (Id VARCHAR)
SELECT 1986 FROM table_name_99 WHERE 1978 = "a" AND 1979 = "a" AND 1980 = "1r"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (Id VARCHAR) Question: What is 1986, when 1978 is "A", when 1979 is "A", and when 1980 is "1R"? [/INST] SELECT 1986 FROM table_name_99 WHERE 1978 = "a" AND 1979 = "a" AND 1980 = "1r" </s>