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_23927423_4 (promoted_from_league VARCHAR, relegated_to_league VARCHAR)
  ### Question:
  How many were promoted from the league when Esher was relegated to the league?
  ### Answer:
  SELECT COUNT(promoted_from_league) FROM table_23927423_4 WHERE relegated_to_league = "Esher"