Days Since Last Activity — Solution & ExplanationProblems / Days Since Last Activity / EditorialApproach

Find last activity: MAX(action_date) grouped by user_id gives each user's most recent action date.

Compute gap: DATEDIFF('day', last_activity_date, DATE '2024-04-01') gives the number of inactive days relative to the reference date.

Order: Sort by days_inactive descending to surface the most inactive users first.

Key ConceptThis pattern is used to identify churning or at-risk users in product analytics. Computing days since last activity is a common feature in engagement scoring and user segmentation.Hints

MAX(action_date) per user gives the most recent activity.

Use DATEDIFF with a fixed reference date of 2024-04-01.

Order by days_inactive descending to highlight the most inactive users.

Solve Days Since Last Activity yourself →