Given this table:
CREATE TABLE pokemon (
    pokedex_number INT,
    name TEXT,
    generation INT,
    status TEXT,
    species TEXT,
    type_1 TEXT,
    type_2 TEXT,
    height_m FLOAT,
    weight_kg FLOAT,
    abilities TEXT,
    catch_rate INT,
    base_total INT,
    hp INT,
    attack INT,
    defense INT,
    special_attack INT,
    special_defense INT,
    speed INT
);
Pivot the type_1 column, grouped by generation. Summarize: mean attack, mean defense The letter g should appear at least 5 times.
user