Find the rank of the faculty that the fewest faculties belong to.
CREATE TABLE FACULTY (Rank VARCHAR)
SELECT TOP 1 Rank FROM FACULTY GROUP BY Rank ORDER BY COUNT(*)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE FACULTY (Rank VARCHAR) Question: Find the rank of the faculty that the fewest faculties belong to. [/INST] SELECT TOP 1 Rank FROM FACULTY GROUP BY Rank ORDER BY COUNT(*) </s>