• As mentioned in the comments above please do not use images for input and output data,rather use sample input and output in tabular markdown format. Also I am not sure whether you want mysql or oracle since both are tagged, I have used mysql as an example.

• As you want to apply lag on a team ranking but in your final table you have multiple columns of same team rank. To achieve this I have created a cte with team_ranking and price_money, used lag to get the desired result and joined it back to the final table

Fiddle

with distinct_team_ranking_money as
  (
select 
  Team_Ranking, 
   LAG(Price_Money, 1, 0) OVER (ORDER BY Team_Ranking desc) AS price_money
from 
(SELECT 
   distinct 
    Team_Ranking, 
   price_money from test
  ) as  T
  )

select test.player_id, test.team_ranking, distinct_team_ranking_money.price_money
from 
test
  
left join distinct_team_ranking_money
  on distinct_team_ranking_money.Team_Ranking = test.Team_Ranking ; 

Output