Translate the following question to SQL: For each position, what is the average number of points for players in that position?

Schema: CREATE TABLE club (
    Club_ID INT   PRIMARY KEY,
    name TEXT,
    Region TEXT,
    Start_year TEXT,
    UNIQUE (Club_ID)
);

CREATE TABLE club_rank (
    Rank REAL   PRIMARY KEY,
    Club_ID INT   PRIMARY KEY,
    Gold REAL,
    Silver REAL,
    Bronze REAL,
    Total REAL,
    PRIMARY KEY (Rank, Club_ID),
    UNIQUE (Rank, Club_ID),
    FOREIGN KEY (Club_ID) REFERENCES club(Club_ID)
);

CREATE TABLE player (
    Player_ID INT   PRIMARY KEY,
    name TEXT,
    Position TEXT,
    Club_ID INT,
    Apps REAL,
    Tries REAL,
    Goals TEXT,
    Points REAL,
    UNIQUE (Player_ID),
    FOREIGN KEY (Club_ID) REFERENCES club(Club_ID)
);

CREATE TABLE competition (
    Competition_ID INT   PRIMARY KEY,
    Year REAL,
    Competition_type TEXT,
    Country TEXT,
    UNIQUE (Competition_ID)
);

CREATE TABLE competition_result (
    Competition_ID INT   PRIMARY KEY,
    Club_ID_1 INT   PRIMARY KEY,
    Club_ID_2 INT   PRIMARY KEY,
    Score TEXT,
    PRIMARY KEY (Competition_ID, Club_ID_1, Club_ID_2),
    UNIQUE (Competition_ID, Club_ID_1, Club_ID_2),
    FOREIGN KEY (Competition_ID) REFERENCES competition(Competition_ID),
    FOREIGN KEY (Club_ID_2) REFERENCES club(Club_ID),
    FOREIGN KEY (Club_ID_1) REFERENCES club(Club_ID)
);
user
SELECT POSITION ,  avg(Points) FROM player GROUP BY POSITION
assistant