Group by ships by flag, and return number of ships that have each flag.
CREATE TABLE ship (
    flag VARCHAR
)
SELECT COUNT(*), flag FROM ship GROUP BY flag
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: Group by ships by flag, and return number of ships that have each flag. ### Input: CREATE TABLE ship (
    flag VARCHAR
) ### Response: SELECT COUNT(*), flag FROM ship GROUP BY flag