CREATE TABLE table_name_59 (semi_finalist__number2 VARCHAR2, year VARCHAR2)

Who was the Semi-Finalist #2 in 2007?
SELECT semi_finalist__number2 FROM table_name_59 WHERE year = "2007"
SELECT "semi_finalist__number2" FROM "table_name_59" WHERE "2007" = "year"