First Login Date per Player
Easy
Interview Classics
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.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.