GROUP BY + MIN
SELECT player_id, MIN(event_date) AS first_login FROM Activity GROUP BY player_id;
Last updated 3 years ago