Meta's Product Growth team is evaluating early retention for an Instagram Reels feature launch. A user is considered active when they generate any event for the selected launch. Write a PostgreSQL query to find users active during week 1 who were also active during week 4.
Use launch 101, whose launch date is 2025-01-01. Week 1 is the half-open interval from launch date through launch date plus 7 days. Week 4 is the half-open interval from launch date plus 21 days through launch date plus 28 days.
Requirements
- Aggregate each user's event counts for weeks 1 and 4.
- Return only users with at least one event in both weeks.
- Include the user's ID, username, week 1 event count, and week 4 event count.
- Order results by
user_id ascending.