SQL Engagement Increase Streak

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

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

Output details

• Return month values as dates representing the first day of each calendar month, such as 2024-01-01.
• Preserve engagement values exactly without rounding or numeric conversion.
• Treat zero engagement values as ordinary numeric values in comparisons.
• Do not deduplicate rows sharing the same user and engagement month.