How can I Insert all the data from score_table to viewing_table? i can’t find any solution to my problem. is it possible?

INSERT INTO viewing_table (student_number, Running1, Running2, Running3, Swimming1, Swimming2, Swimming3)

SELECT DISTINCT student_number,

(SELECT score FROM score_table WHERE item = 'Running' AND item_id = '1' AND student_number = student_number),

(SELECT score FROM score_table WHERE item = 'Running' AND item_id = '2' AND student_number = student_number),

,
(SELECT score FROM score_table WHERE item = ‘Running’ AND item_id = ‘3’ AND student_number = student_number),

(SELECT score FROM score_table WHERE item = 'Swimming' AND item_id = '1' AND student_number = student_number), 

(SELECT score FROM score_table WHERE item = 'Swimming' AND item_id = '2' AND student_number = student_number), 

(SELECT score FROM score_table WHERE item = 'Swimming' AND item_id = '3' AND student_number = student_number), 

    

FROM score_table

i’m using pgAdmin 4 Query Editor