example_2.txt

Task Overview:
You are a data science expert. Below, you are provided with a database schema and a natural language question. Your task is to understand the schema and generate a valid SQL query to answer the question.

Database Engine:
SQLite

Database Schema:
CREATE TABLE continents (
    ContId number, -- example: [1, 2]
    Continent text, -- example: ['america', 'europe']
    PRIMARY KEY (ContId)
);

CREATE TABLE countries (
    CountryId number, -- example: [1, 2]
    CountryName text, -- example: ['usa', 'germany']
    Continent number, -- example: [1, 2]
    PRIMARY KEY (CountryId),
    CONSTRAINT fk_countries_continent FOREIGN KEY (Continent) REFERENCES continents (ContId)
);

CREATE TABLE car_makers (
    Id number, -- example: [1, 2]
    Maker text, -- example: ['amc', 'volkswagen']
    FullName text, -- example: ['American Motor Company', 'Volkswagen']
    Country text, -- example: ['1', '2']
    PRIMARY KEY (Id),
    CONSTRAINT fk_car_makers_country FOREIGN KEY (Country) REFERENCES countries (CountryId)
);

CREATE TABLE model_list (
    ModelId number, -- example: [1, 2]
    Maker number, -- example: [1, 2]
    Model text, -- example: ['amc', 'audi']
    PRIMARY KEY (ModelId),
    CONSTRAINT fk_model_list_maker FOREIGN KEY (Maker) REFERENCES car_makers (Id)
);

CREATE TABLE car_names (
    MakeId number, -- example: [1, 2]
    Model text, -- example: ['chevrolet', 'buick']
    Make text, -- example: ['chevrolet chevelle malibu', 'buick skylark 320']
    PRIMARY KEY (MakeId),
    CONSTRAINT fk_car_names_model FOREIGN KEY (Model) REFERENCES model_list (Model)
);

CREATE TABLE cars_data (
    Id number, -- example: [1, 2]
    MPG text, -- example: ['18', '15']
    Cylinders number, -- example: [8, 4]
    Edispl number, -- example: [307.0, 350.0]
    Horsepower text, -- example: ['130', '165']
    Weight number, -- example: [3504, 3693]
    Accelerate number, -- example: [12.0, 11.5]
    `Year` number, -- example: [1970, 1971]
    PRIMARY KEY (Id),
    CONSTRAINT fk_cars_data_id FOREIGN KEY (Id) REFERENCES car_names (MakeId)
);
This schema describes the database's structure, including tables, columns, primary keys, foreign keys, and any relevant relationships or constraints.

Question:
How many car makers are there in each continents? List the continent name and the count.

Instructions:
- Make sure you only output the information that is asked in the question. If the question asks for a specific column, make sure to only include that column in the SELECT clause, nothing more.
- The generated query should return all of the information asked in the question without any missing or extra information.
- Before generating the final SQL query, please think through the steps of how to write the query.

Output Format:
In your answer, please enclose the generated SQL query in a code block:
```sql
-- Your SQL query
```

Take a deep breath and think step by step to find the correct SQL query.