What year was the team 8th in the season and made it to the 3rd round in Open Cup?
CREATE TABLE table_name_21 (year VARCHAR, reg_season VARCHAR, open_cup VARCHAR)
SELECT year FROM table_name_21 WHERE reg_season = "8th" AND open_cup = "3rd round"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_21 (year VARCHAR, reg_season VARCHAR, open_cup VARCHAR) Question: What year was the team 8th in the season and made it to the 3rd round in Open Cup? [/INST] SELECT year FROM table_name_21 WHERE reg_season = "8th" AND open_cup = "3rd round" </s>