__STYLES__

Player Performance and Game Dynamics Analysis Using SQL

Shubham Mataghare Avatar
Shubham Mataghare Avatar
Shubham Mataghare
Cognifyz Technologies
Tools used in this project
Player Performance and Game Dynamics Analysis Using SQL

Additional project images

1. Extract `P_ID`, `Dev_ID`, `PName`, and `Difficulty_level` of all players at Level 0
2. Find the total number of stages crossed at each difficulty level for Level 2 with players
3. Extract `P_ID` and the total number of unique dates for those players who have played games on multiple days
4. Find `P_ID` and levelwise sum of `kill_counts` where `kill_count` is greater than the average kill count for Medium difficulty
5. find `Level` and its corresponding `Level_code`wise sum of lives earned, excluding Level 0. Arrange in ascending order of level
6. Find the top 3 scores based on each `Dev_ID` and rank them in increasing order using `Row_Number`. Display the difficulty as well
Shubham Mataghare Avatar
Shubham Mataghare Avatar
Shubham MataghareCognifyz Technologies

More projects by Shubham

Analysis of Hotel Aggregator Listings Using Power BI
Analysis of Hotel Aggregator Listings Using Power BI
0 Likes
0 Comments
Adventure Works Sales Dashboard
Adventure Works Sales Dashboard
1 Likes
0 Comments
Toy Store Sales Analysis Dashboard Using Power BI
Toy Store Sales Analysis Dashboard Using Power BI
2 Likes
0 Comments
Discussion and feedback(0 comments)
2000 characters remaining
Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.