Game Play Analysis II LeetCode Solution

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

Level of Question

Easy

Game Play Analysis II LeetCode Solution

Game Play Analysis II LeetCode Solution

Problem Statement

Column NameType
player_idint
device_idint
event_datedate
games_playedint
Table: Activity

(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:

player_iddevice_idevent_dategames_played
122016-03-015
122016-05-026
232017-06-251
312016-03-020
342018-07-035
Activity table:

Output:

player_idfirst_login
12016-03-01
22017-06-25
32016-03-02
Result table:

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
  );
Scroll to Top