Monthly User Engagement Trend Analysis

StreamWave wants to analyze how user behavior changes over time. Write a PostgreSQL query to summarize monthly user activity for each signup cohort month.

Your query should focus on users who signed up in January or February 2024 and measure their behavior during the first 3 calendar months starting from their signup month.

Requirements

1. Return one row per signup_month and activity_month.
2. Count:
   • total users in the cohort
   • active users in that month (users with at least one event)
   • total events in that month
3. Add an engagement_status column:
   • high if average events per active user is at least 2
   • low otherwise
4. Order results by signup_month, then activity_month.

Table Definitions

users

events

subscriptions