How many companies that have ever operated a flight for each type? Draw a pie chart.
CREATE TABLE operate_company (
    id int,
    name text,
    Type text,
    Principal_activities text,
    Incorporated_in text,
    Group_Equity_Shareholding real
)

CREATE TABLE airport (
    id int,
    City text,
    Country text,
    IATA text,
    ICAO text,
    name text
)

CREATE TABLE flight (
    id int,
    Vehicle_Flight_number text,
    Date text,
    Pilot text,
    Velocity real,
    Altitude real,
    airport_id int,
    company_id int
)
SELECT Type, COUNT(Type) FROM operate_company AS T1 JOIN flight AS t2 ON T1.id = T2.company_id 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: How many companies that have ever operated a flight for each type? Draw a pie chart. ### Input: CREATE TABLE operate_company (
    id int,
    name text,
    Type text,
    Principal_activities text,
    Incorporated_in text,
    Group_Equity_Shareholding real
)

CREATE TABLE airport (
    id int,
    City text,
    Country text,
    IATA text,
    ICAO text,
    name text
)

CREATE TABLE flight (
    id int,
    Vehicle_Flight_number text,
    Date text,
    Pilot text,
    Velocity real,
    Altitude real,
    airport_id int,
    company_id int
) ### Response: SELECT Type, COUNT(Type) FROM operate_company AS T1 JOIN flight AS t2 ON T1.id = T2.company_id GROUP BY Type