find perfomance index in sql

PHOTO EMBED

Thu Apr 21 2022 03:58:04 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

select *,
point_total/games_played as point_per_game,
sum(point_total)over()/sum(games_played)over() as point_per_game_league,
round((point_total/games_played)/(sum(point_total)over()/sum(games_played::numeric)over()),2) as perfomanceindex
from game_csv as gc 
content_copyCOPY