How many captains are in each rank?
CREATE TABLE captain (rank VARCHAR)
SELECT COUNT(*), rank FROM captain GROUP BY rank
### Context: CREATE TABLE captain (rank VARCHAR) ### Question: How many captains are in each rank? ### Answer: SELECT COUNT(*), rank FROM captain GROUP BY rank