How many captains are in each rank?
CREATE TABLE captain (
    rank VARCHAR
)
SELECT COUNT(*), rank FROM captain GROUP BY rank
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many captains are in each rank? ### Input: CREATE TABLE captain (
    rank VARCHAR
) ### Response: SELECT COUNT(*), rank FROM captain GROUP BY rank