What is Ensemble Name Muxco Gloucestershire's Advertisement Date in Block 10C?
CREATE TABLE table_name_17 (advertisement_date VARCHAR, block VARCHAR, ensemble_name VARCHAR)
SELECT advertisement_date FROM table_name_17 WHERE block = "10c" AND ensemble_name = "muxco gloucestershire"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: 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? [/INST] SELECT advertisement_date FROM table_name_17 WHERE block = "10c" AND ensemble_name = "muxco gloucestershire" </s>