Show different types of ships and the number of ships of each type.
CREATE TABLE ship (
    TYPE VARCHAR
)
SELECT TYPE, COUNT(*) FROM ship GROUP BY TYPE
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: Show different types of ships and the number of ships of each type. ### Input: CREATE TABLE ship (
    TYPE VARCHAR
) ### Response: SELECT TYPE, COUNT(*) FROM ship GROUP BY TYPE