SELECT  *,

 RANK() OVER(
  
  ORDER BY total_score DESC
  )AS ranking
  
  FROM  total_scores
  ORDER BY 
  
   ranking ASC;