display the country ID and number of cities for each country.
CREATE TABLE locations (
    country_id VARCHAR
)
SELECT country_id, COUNT(*) FROM locations GROUP BY country_id
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: display the country ID and number of cities for each country. ### Input: CREATE TABLE locations (
    country_id VARCHAR
) ### Response: SELECT country_id, COUNT(*) FROM locations GROUP BY country_id