Longest Consecutive Login Streak per User

HardSQL · PostgreSQL

Problem

A social media platform tracks user logins and wants to analyze user engagement. Write a SQL query to find the longest consecutive streak of login days for each user.

Requirements

Identify consecutive login days for each user.
Calculate the length of each streak.
Return each user with their longest streak.

Schema

user_logins

Column	Type	Description
user_id	INT	Unique identifier for the user
login_date	DATE	Date of user login

Tablesuser_logins

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.