As a user, I want ranking can be update by match so that I can see the ranking for real time

Acceptance Criteria

• When the user clicks the "Update" button, the system performs a join query to calculate the latest rankings based on match results.
• The updated ranking data is immediately reflected in the UI.
• Rankings are calculated correctly according to the match results.
• The ranking data in the system is consistent with the match results after the update
• The data update operation does not introduce duplicates or incorrect rankings.

Tasks

• Design and implement the SQL join query to calculate rankings based on match results and existing ranking data.
• Create an endpoint that triggers the ranking update process.
• Integrate the join query into the backend logic.
• Add an "Update" button in the UI.
• Implement the logic to call the backend API when the button is clicked.