user: ### NOW ANSWER:
Question:  who is the runner-up where year is 2004 and champion is North Carolina State
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 "Runner-Up" FROM "Table" WHERE "Year" = '2004' AND "Champion" = 'North Carolina State';