Longest Consecutive Login Streak per User | Dataford Interview Questions

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

Your question is Longest Consecutive Login Streak per User. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

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

Your question is Longest Consecutive Login Streak per User. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.