what is the total number of semi-finalist #2 where runner-up is east carolina
CREATE TABLE table_11214772_1 (semi_finalist__number2 VARCHAR, runner_up VARCHAR)
SELECT COUNT(semi_finalist__number2) FROM table_11214772_1 WHERE runner_up = "East Carolina"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11214772_1 (semi_finalist__number2 VARCHAR, runner_up VARCHAR) Question: what is the total number of semi-finalist #2 where runner-up is east carolina [/INST] SELECT COUNT(semi_finalist__number2) FROM table_11214772_1 WHERE runner_up = "East Carolina" </s>