Last updated on October 10th, 2024 at 12:26 am

This Leetcode problem Game Play Analysis II LeetCode Solution is done in SQL.

List of all LeetCode Solution

Game Play Analysis II LeetCode Solution

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:

1. Game Play Analysis II LeetCode Solution 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
  );