Thomas Ngo

Thomas Ngo

Software Engineer

SQL problem - Game Play Analysis I

February 2, 2024 less than 1 minute read

ProblemPermalink

QueryPermalink

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

Share on

Twitter Facebook LinkedIn

You may also enjoy

Problem of The Day: Solving Questions With Brainpower

March 31, 2025 1 minute read

Problem Statement

Problem of The Day: Partition Labels

March 30, 2025 1 minute read

Problem Statement

Problem of The Day: Maximum Number of Points From Grid Queries

March 27, 2025 1 minute read

Problem Statement

Problem of The Day: Minimum Operations to Make a Uni-Value Grid

March 25, 2025 3 minute read

Problem Statement