Solution 1

GROUP BY + MIN

SELECT player_id, MIN(event_date) AS first_login
FROM Activity
GROUP BY player_id;

Last updated