Last updated on January 21st, 2025 at 11:00 pm

Here, we see the Game Play Analysis II LeetCode Solution. This Leetcode problem is solved using MySQL and Pandas.

List of all LeetCode Solution

Game Play Analysis II LeetCode Solution

1. Problem Statement

(player_id, event_date) is the primary key of this table. This table shows the activity of players of some games. Each row is a record of a player who logged in and played a number of games (possibly 0) before logging out on some day using some device.

Write an SQL query that reports the device that is first logged in for each player.
The query result format is in the following example :

Example 1:
Input:

Output:

2. Code Implementation in Different Languages

2.1 Game Play Analysis II MySQL

select 
  player_id, 
  device_id 
from 
  Activity 
where 
  (player_id, event_date) in (
    select 
      player_id, 
      min(event_date) 
    from 
      Activity 
    group by 
      player_id
  );