SQL Engagement Increase Streak | Dataford Interview Questions

Write a SQL query to identify users whose engagement increased month over month for three consecutive months.

Assume three consecutive increases require four consecutive calendar months. Missing months and NULL engagement values do not count as increases. Return only each user's earliest qualifying period.

Output

One row per qualifying user
Columns: user_id, user_name, start_month, end_month, starting_engagement, ending_engagement
Include the four-month period containing three consecutive increases
Order by user_id ascending

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	Display name of the user

engagement_monthly

Column	Type	Description
user_idPK	INT	User associated with the monthly record
engagement_monthPK	DATE	First calendar day of the engagement month
engagement_score	INT	Monthly engagement measurement

Your question is SQL Engagement Increase Streak. Start with the requirements and the two tables 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