What is the value in 1987 when it is A in 1999, 1989, and 1997?
CREATE TABLE table_name_47 (Id VARCHAR)
SELECT 1987 FROM table_name_47 WHERE 1999 = "a" AND 1989 = "a" AND 1997 = "a"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (Id VARCHAR) Question: What is the value in 1987 when it is A in 1999, 1989, and 1997? [/INST] SELECT 1987 FROM table_name_47 WHERE 1999 = "a" AND 1989 = "a" AND 1997 = "a" </s>