How many captains are in each rank?
CREATE TABLE captain (rank VARCHAR)
SELECT COUNT(*), rank FROM captain GROUP BY rank
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE captain (rank VARCHAR) Question: How many captains are in each rank? [/INST] SELECT COUNT(*), rank FROM captain GROUP BY rank </s>