What was the year opened for North Carolina with a smaller than 21,500 capacity?
CREATE TABLE table_name_50 (year_opened VARCHAR, state VARCHAR, capacity VARCHAR)
SELECT year_opened FROM table_name_50 WHERE state = "north carolina" AND capacity < 21 OFFSET 500 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (year_opened VARCHAR, state VARCHAR, capacity VARCHAR) Question: What was the year opened for North Carolina with a smaller than 21,500 capacity? [/INST] SELECT year_opened FROM table_name_50 WHERE state = "north carolina" AND capacity < 21 OFFSET 500 ROWS </s>