SQL problem - Game Play Analysis I
Problem
Query
The idea is to GROUP BY
clause to group all player_id
, then apply aggregation function MIN
on event_date
SELECT
player_id, MIN(event_date) AS first_login
FROM
Activity
GROUP BY player_id