SQLeasyRanking~12m

A mobile gaming company wants to identify the top 3 most active players for each...

Problem

A mobile gaming company wants to identify the top 3 most active players for each game title based on total playtime hours. Players who haven't played at least 10 hours total should be excluded. When players have the same playtime, rank them by their earliest first_played_date (earlier dates rank higher).

Examples

Example 1

Example 2

Constraints

›Return columns: game_title, username, total_hours, rank
›Only include players with at least 10 total hours per game
›Show top 3 players per game title
›Break ties by earliest first_played_date
›Order results by game_title, then by rank

Reference solution

Reference solution available after you attempt the question.

Ready to solve it?

Start a session on Mockbit #45. Write your SQL, run it against real data, and get graded on correctness, efficiency, query structure, and business understanding.