Table: mls_cup_history
Columns: season
mls_cup_winner
mls_cup_runner_up
mls_supporters_shield_winner
mls_supporters_shield_runner_up

Question: What is the name of the shield winner in which the mls cup winner and mls cup runner up is colorado rapids?
SQL: SELECT "mls_cup_winner" FROM mls_cup_history WHERE "mls_cup_runner_up" = 'Colorado Rapids'

Question: What is the name of the shield winner in which the mls cup winner and mls supporters shield runner up is Chivas usa?
SQL: SELECT "mls_cup_winner" FROM mls_cup_history WHERE "mls_supporters_shield_runner_up" = 'Chivas USA'

Question: who is the of the shield winnerin which the mls cup runner-up and mls cup winner is real salt lake?
SQL: SELECT "mls_cup_runner_up" FROM mls_cup_history WHERE "mls_cup_winner" = 'Real Salt Lake'

Question: Which shield winner has the mls cup runner up and the season is 2000?
SQL: SELECT "mls_cup_runner_up" FROM mls_cup_history WHERE "season" = 2000