Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

First Login Date per Player

Return each player's first login date as first_login. Order by player_id.

Table schema

Activity(player_id INT, device_id INT, event_date DATE, games_played INT)

Sample data

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

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.