Game Play Analysis I
Epic Games
Problem Statement
Game designers at Epic Games need to calculate player retention. The first step is to establish a "baseline" for every player by finding the date they first logged into the system.
Write an SQL query to report the first login date for each player.
Rules:
- The result should include every player_id that has at least one record in the Activity table.
- Return the player_id and their corresponding first_login date.
- Results must be sorted by player_id in ascending order.
Tests your understanding of
Basic SQL, Aggregation, MIN and Grouping
Input Tables
activity
| player_id(INTEGER) | device_id(INTEGER) | event_date(DATE) | games_played(INTEGER) |
|---|---|---|---|
| 1 | 2 | 2024-03-01 | 5 |
| 1 | 2 | 2024-03-02 | 6 |
| 2 | 3 | 2024-06-25 | 1 |
| 3 | 1 | 2024-03-02 | 0 |
| 3 | 4 | 2024-07-03 | 5 |
Expected Output
| player_id(INTEGER) | first_login(DATE) |
|---|---|
| 1 | 2024-03-01 |
| 2 | 2024-06-25 |
| 3 | 2024-03-02 |
Tags
EasyBasic SQLAggregationMINGrouping
5-10 min
75%