text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE table_name_47 (Id VARCHAR)
  ### Question:
  What is the value in 1987 when it is A in 1999, 1989, and 1997?
  ### Answer:
  SELECT 1987 FROM table_name_47 WHERE 1999 = "a" AND 1989 = "a" AND 1997 = "a"