Show different types of ships and the average tonnage of ships of each type.
CREATE TABLE ship (
    ship_id number,
    name text,
    type text,
    nationality text,
    tonnage number
)

CREATE TABLE mission (
    mission_id number,
    ship_id number,
    code text,
    launched_year number,
    location text,
    speed_knots number,
    fate text
)
SELECT type, AVG(tonnage) 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 average tonnage of ships of each type. ### Input: CREATE TABLE ship (
    ship_id number,
    name text,
    type text,
    nationality text,
    tonnage number
)

CREATE TABLE mission (
    mission_id number,
    ship_id number,
    code text,
    launched_year number,
    location text,
    speed_knots number,
    fate text
) ### Response: SELECT type, AVG(tonnage) FROM ship GROUP BY type