Name the year for open cup did not qualify and national final
CREATE TABLE table_2553861_1 (year VARCHAR, open_cup VARCHAR, playoffs VARCHAR)
SELECT COUNT(year) FROM table_2553861_1 WHERE open_cup = "Did not qualify" AND playoffs = "National Final"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2553861_1 (year VARCHAR, open_cup VARCHAR, playoffs VARCHAR) Question: Name the year for open cup did not qualify and national final [/INST] SELECT COUNT(year) FROM table_2553861_1 WHERE open_cup = "Did not qualify" AND playoffs = "National Final" </s>