Translate the following question to SQL: Show different types of ships and the number of ships of each type.

Schema: CREATE TABLE mission (
    Mission_ID INT   PRIMARY KEY,
    Ship_ID INT,
    Code TEXT,
    Launched_Year INT,
    Location TEXT,
    Speed_knots INT,
    Fate TEXT,
    UNIQUE (Mission_ID),
    FOREIGN KEY (Ship_ID) REFERENCES ship(Ship_ID)
);

CREATE TABLE ship (
    Ship_ID INT   PRIMARY KEY,
    Name TEXT,
    Type TEXT,
    Nationality TEXT,
    Tonnage INT,
    UNIQUE (Ship_ID)
);
user
SELECT TYPE ,  COUNT(*) FROM ship GROUP BY TYPE
assistant