This Leetcode problem Game Play Analysis II LeetCode Solution is done in SQL.
List of all LeetCode Solution
![Game Play Analysis II LeetCode Solution](https://i0.wp.com/totheinnovation.com/wp-content/uploads/2024/02/LeetCode-Problem-Solution.png?resize=200%2C200&ssl=1)
Game Play Analysis II LeetCode Solution
Table of Contents
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 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_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 |
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
);
Code language: SQL (Structured Query Language) (sql)