Leetcode Problem 1454. Active Users

1454. Active Users

Leetcode Solutions

Use the DENSE_RANK() window function to assign a rank to each login date for each user, ordered by the login date.
Subtract the rank from the login date to create a grouping identifier for consecutive login dates.
Group by the user id and the grouping identifier, and count the number of unique login dates in each group.
Filter the groups to only include those with five or more unique login dates.
Join the filtered result with the Accounts table to get the user names.
Select the distinct user ids and names from the result.
Order the final result by user id.

erDiagram
    Accounts {
        int id PK
        varchar name
    }
    Logins {
        int id FK >- Accounts.id
        date login_date
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen