What is the name of the shield winner in which the mls cup winner and mls cup runner up is colorado rapids?
CREATE TABLE table_11148572_1 (mls_cup_winner VARCHAR, mls_cup_runner_up VARCHAR)
SELECT mls_cup_winner FROM table_11148572_1 WHERE mls_cup_runner_up = "Colorado Rapids"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11148572_1 (mls_cup_winner VARCHAR, mls_cup_runner_up VARCHAR) Question: What is the name of the shield winner in which the mls cup winner and mls cup runner up is colorado rapids? [/INST] SELECT mls_cup_winner FROM table_11148572_1 WHERE mls_cup_runner_up = "Colorado Rapids" </s>