CREATE TABLE table_11214772_2 (semi_finalist__number2 VARCHAR, year VARCHAR)

Which team was the second semi finalist in 2007?
SELECT semi_finalist__number2 FROM table_11214772_2 WHERE year = 2007
SELECT "semi_finalist__number2" FROM "table_11214772_2" WHERE "year" = 2007