For each faculty rank, show the number of faculty members who have it.
CREATE TABLE Faculty (rank VARCHAR)
SELECT rank, COUNT(*) FROM Faculty GROUP BY rank
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Faculty (rank VARCHAR) Question: For each faculty rank, show the number of faculty members who have it. [/INST] SELECT rank, COUNT(*) FROM Faculty GROUP BY rank </s>