Last updated on March 10th, 2025 at 11:15 pm

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

List of all LeetCode Solution

Level of Question

Easy

Game Play Analysis I LeetCode Solution

1. Problem Statement

Column Name	Type
player_id	int
device_id	int
event_date	date
games_played	int

(player_id, event_date) is the primary key (combination of columns with unique values) 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 someday using some device.

Write a solution to find the first login date for each player. Return the result table in any order.
The result format is in the following example.

Example 1:
Input:

player_id	device_id	event_date	games_played
1	2	2016-03-01	5
1	2	2016-05-02	6
2	3	2017-06-25	1
3	1	2016-03-02	0
3	4	2018-07-03	5

Output:

player_id	first_login
1	2016-03-01
2	2017-06-25
3	2016-03-02

2. Code Implementation in Different Languages

2.1 Game Play Analysis I MySQL

select 
  player_id, 
  min(event_date) as first_login 
from 
  Activity 
group by 
  player_id 
order by 
  player_id;