1179. Game Play Analysis I
My accepted SQL solution to LeetCode problem 1179, Game Play Analysis I, running in 609ms.
- Difficulty: Easy
- SQL
- Runtime 609ms
- Memory 0.0B
- Updated
Read the problem on LeetCode View on GitHub
The problem statement is LeetCode’s and stays on their site. What follows is my accepted solution.
SQL
Accepted on LeetCode — runtime 609ms, memory 0.0B, accepted 2025-12-28.
# Write your MySQL query statement below
SELECT player_id, MIN(event_date) AS first_login
FROM Activity
GROUP BY player_id;