 who is the runner-up where year is 2004 and champion is north carolina state
CREATE TABLE table_11214772_1 (runner_up VARCHAR, year VARCHAR, champion VARCHAR)
SELECT runner_up FROM table_11214772_1 WHERE year = "2004" AND champion = "North Carolina State"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11214772_1 (runner_up VARCHAR, year VARCHAR, champion VARCHAR) Question:  who is the runner-up where year is 2004 and champion is north carolina state [/INST] SELECT runner_up FROM table_11214772_1 WHERE year = "2004" AND champion = "North Carolina State" </s>