What is the position of the player from the college of North Carolina with an overall less than 100?
CREATE TABLE table_name_47 (position VARCHAR, overall VARCHAR, college VARCHAR)
SELECT position FROM table_name_47 WHERE overall < 100 AND college = "north carolina"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (position VARCHAR, overall VARCHAR, college VARCHAR) Question: What is the position of the player from the college of North Carolina with an overall less than 100? [/INST] SELECT position FROM table_name_47 WHERE overall < 100 AND college = "north carolina" </s>