Game Play Analysis II
ASKED IN INTERVIEWEpic Games
Problem Statement
Epic Games tracks player logins across multiple platforms. You need to write a query that reports the device_id for the first login date of every player.
Rules:
- The "first login date" is the earliest event_date recorded for a specific player_id.
- Output columns: player_id, device_id.
- Results must be sorted by player_id in ascending order.
Tests your understanding of
Window Functions, Subqueries and Grouping
Input Tables
Activity
| player_id(INTEGER) | device_id(INTEGER) | event_date(DATE) | games_played(INTEGER) |
|---|---|---|---|
| 1 | 2 | 2026-02-01 | 5 |
| 1 | 3 | 2026-02-02 | 0 |
| 2 | 3 | 2026-01-25 | 1 |
| 3 | 1 | 2026-02-01 | 0 |
| 3 | 4 | 2025-12-30 | 5 |
Devices
| device_id(INTEGER) | device_type(VARCHAR) |
|---|---|
| 1 | PC |
| 2 | PS5 |
| 3 | Xbox |
| 4 | Mobile |
Players
| player_id(INTEGER) | player_name(VARCHAR) |
|---|---|
| 1 | Ninja |
| 2 | SypherPK |
| 3 | Lupo |
Expected Output
| player_id(INTEGER) | device_id(INTEGER) |
|---|---|
| 1 | 2 |
| 2 | 3 |
| 3 | 4 |
Tags
EasyASKED IN INTERVIEWWindow FunctionsSubqueriesGrouping
10-15 min
62%