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_2140071_7 (external_link VARCHAR, premier_date VARCHAR)
  ### Question:
  How many episodes have a premier date of july 24, 2006
  ### Answer:
  SELECT COUNT(external_link) FROM table_2140071_7 WHERE premier_date = "July 24, 2006"