Leetcode Problem 2688. Find Active Users

2688. Find Active Users

Leetcode Solutions

Use a CTE to select user_id, created_at, and the date of the next purchase using the LEAD window function.
Partition the data by user_id and order by created_at to ensure the next purchase is for the same user and follows the current purchase chronologically.
Calculate the date 7 days after each purchase using the DATE_ADD function.
In the final SELECT statement, filter for rows where the next purchase date is on or after the current purchase date and on or before the date 7 days later.
Select distinct user_ids that meet the active user criteria.


erDiagram
    Users {
        int user_id
        varchar item
        datetime created_at
        int amount
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen