Leetcode Problem 511. Game Play Analysis I

511. Game Play Analysis I

Leetcode Solutions

Approach: Grouping and Extracting the Minimum

Use the SELECT statement to specify the columns we are interested in: player_id and the minimum event_date.
Use the FROM clause to specify the Activity table as the data source.
Apply the GROUP BY clause to group the results by player_id.
Use the MIN() aggregate function to find the earliest event_date for each group.
Alias the result of the MIN() function as first_login to match the expected output column name.

erDiagram
    Activity {
        int player_id
        int device_id
        date event_date
        int games_played
        player_id --|| event_date : is
    }

Approach: Using Window Functions

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Loading...

Suggested Answer

Answer

Full Screen

Copy Answer Code

Loading...

OR