Interview Guides
You are given user signups and activity events. Write a PostgreSQL query that calculates month-1 retention for users who signed up in January versus February. Return one row per signup month with the cohort size, retained users, and retention rate.
Count a user as retained only if they had at least one activity event in the next calendar month after signup. Use the signup month to define the cohort and do not hardcode the retention denominator.
