Table: colorado_avalanche_2007_08_2
Columns: date
visitor
score
home
decision
attendance
record

Question: Who was the visitor when phoenix was at home?
SQL: SELECT "visitor" FROM colorado_avalanche_2007_08_2 WHERE "home" = 'phoenix'

Question: What day did philadelphia visit?
SQL: SELECT "date" FROM colorado_avalanche_2007_08_2 WHERE "visitor" = 'philadelphia'