user: ### NOW ANSWER:
Question: Who was the Semi-Finalist #2 in 2007?
Columns: ['Year', 'Champion', 'Score', 'Runner-Up', 'Location', 'Semi-Finalist #1', 'Semi-Finalist #2']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['2000', 'Elon University', '5-4OT', 'North Carolina State', 'Durham, NC', 'NA', 'NA']
SQL:

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