CREATE TABLE competition_result (competition_id NUMBER, club_id_1 NUMBER, club_id_2 NUMBER, score CLOB)
CREATE TABLE club_rank (rank NUMBER, club_id NUMBER, gold NUMBER, silver NUMBER, bronze NUMBER, total NUMBER)
CREATE TABLE player (player_id NUMBER, name CLOB, position CLOB, club_id NUMBER, apps NUMBER, tries NUMBER, goals CLOB, points NUMBER)
CREATE TABLE club (club_id NUMBER, name CLOB, region CLOB, start_year CLOB)
CREATE TABLE competition (competition_id NUMBER, year NUMBER, competition_type CLOB, country CLOB)

For each position, what is the average number of points for players in that position?
SELECT position, AVG(points) FROM player GROUP BY position
SELECT "position", AVG("points") FROM "player" GROUP BY "position"