user: ### NOW ANSWER:
Question: Which team was the second semi finalist in 2007?
Columns: ['Year', 'Champion', 'Score', 'Runner-Up', 'Location', 'Semi-Finalist #1', 'Semi-Finalist #2']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [2004.0, 'Duke', '6-5', 'Elon', 'Morrisville, NC', 'Western Carolina', 'Clemson']
SQL:

assistant: SELECT "Semi-Finalist #2" FROM "Table" WHERE "Year" = 2007.0;