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_17 (advertisement_date VARCHAR, block VARCHAR, ensemble_name VARCHAR)
  ### Question:
  What is Ensemble Name Muxco Gloucestershire's Advertisement Date in Block 10C?
  ### Answer:
  SELECT advertisement_date FROM table_name_17 WHERE block = "10c" AND ensemble_name = "muxco gloucestershire"