Premier League Table Ranking

Premier League Table Ranking - Problem

Database Unknown

You are given a table TeamStats containing information about football teams including their wins, draws, and losses.

Your task: Calculate the points and rank for each team in the Premier League. The scoring system is:

Win: 3 points
Draw: 1 point
Loss: 0 points

Important: Teams with the same points must be assigned the same rank.

Return the result ordered by points in descending order, then by team name in ascending order.

Table Schema

TeamStats

Column Name	Type	Description
`team_id` PK	int	Unique identifier for each team
`team_name`	varchar	Name of the football team
`matches_played`	int	Total number of matches played
`wins`	int	Number of matches won
`draws`	int	Number of matches drawn
`losses`	int	Number of matches lost

Primary Key: team_id

Note: Each row represents one team's season statistics

Input & Output

Example 1 — Standard League Table

Input Table:

team_id	team_name	matches_played	wins	draws	losses
1	Arsenal	38	25	8	5
2	Chelsea	38	20	10	8
3	Liverpool	38	22	6	10

Output:

team_name	points	rank
Arsenal	83	1
Liverpool	72	2
Chelsea	70	3

💡 Note:

Arsenal: 25 wins × 3 + 8 draws × 1 = 83 points (Rank 1)
Liverpool: 22 wins × 3 + 6 draws × 1 = 72 points (Rank 2)
Chelsea: 20 wins × 3 + 10 draws × 1 = 70 points (Rank 3)

Example 2 — Teams with Same Points

Input Table:

team_id	team_name	matches_played	wins	draws	losses
1	Manchester City	38	28	5	5
2	Arsenal	38	26	6	6
3	Barcelona	38	26	6	6

Output:

team_name	points	rank
Manchester City	89	1
Arsenal	84	2
Barcelona	84	2

💡 Note:

Manchester City leads with 89 points (Rank 1). Both Arsenal and Barcelona have 84 points, so they both get Rank 2. Note that Arsenal comes first alphabetically in the output.

Constraints

1 ≤ team_id ≤ 1000
1 ≤ team_name.length ≤ 50
0 ≤ wins, draws, losses ≤ 50
matches_played = wins + draws + losses

Visualization

Tap to expand

Asked in

E ESPN 12 S Sky Sports 8 F FanDuel 15

Use window function RANK() to calculate league standings. Compute points as wins * 3 + draws * 1, then apply RANK() OVER (ORDER BY points DESC) to handle ties correctly.

Table Schema

TeamStats

Column Name	Type	Description
`team_id` PK	int	Unique identifier for each team
`team_name`	varchar	Name of the football team
`matches_played`	int	Total number of matches played
`wins`	int	Number of matches won
`draws`	int	Number of matches drawn
`losses`	int	Number of matches lost

Primary Key: team_id

Note: Each row represents one team's season statistics

Common Approaches

✓ Window Function with RANK

⏱️ Time: O(n log n) Space: O(n)

First calculate total points using the formula (wins * 3 + draws * 1). Then use RANK() window function to assign rankings, which automatically handles ties by giving the same rank to teams with equal points.

Window Function with RANK — Algorithm Steps

Step 1: Calculate total points as (wins * 3 + draws * 1 + losses * 0)
Step 2: Use RANK() OVER to assign rankings based on points descending
Step 3: Order final results by points desc, then team_name asc

Visualization

Tap to expand

Step-by-Step Walkthrough

Calculate Points

wins * 3 + draws * 1

Apply RANK()

Assign rankings with ties

Order Results

Sort by points, then name

Code -

solution.c — C

Time & Space Complexity

Time Complexity

⏱️

O(n log n)

Sorting required for ranking and final ordering

⚡ Linearithmic

Space Complexity

O(n)

Storage for calculated points and rankings

⚡ Linearithmic Space

23.4K Views

Medium Frequency

~12 min Avg. Time

892 Likes

Ln 1, Col 1

Smart Actions

💡 Explanation

AI Ready

💡 Suggestion Tab to accept Esc to dismiss

// Output will appear here after running code

Code Editor Closed

Click the red button to reopen

Table Schema

Input & Output

Constraints

Visualization

Related Problems

Table Schema

Common Approaches

Window Function with RANK — Algorithm Steps

Visualization

Code -

Time & Space Complexity

Select Compiler