What ranks do we have for faculty?
CREATE TABLE Faculty (rank VARCHAR)
SELECT DISTINCT rank FROM Faculty
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Faculty (rank VARCHAR) Question: What ranks do we have for faculty? [/INST] SELECT DISTINCT rank FROM Faculty </s>