How many faculty is there in total in the year of 2002?
CREATE TABLE faculty (faculty INTEGER, YEAR VARCHAR)
SELECT SUM(faculty) FROM faculty WHERE YEAR = 2002
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE faculty (faculty INTEGER, YEAR VARCHAR) Question: How many faculty is there in total in the year of 2002? [/INST] SELECT SUM(faculty) FROM faculty WHERE YEAR = 2002 </s>