user: ### NOW ANSWER:
Question: what is the total number of semi-finalist #2 where runner-up is East Carolina
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 COUNT("Semi-Finalist #2") FROM "Table" WHERE "Runner-Up" = 'East Carolina';