Meta’s Instagram Reels team tracks stickiness using the DAU/MAU ratio. Write a SQL query to compute this ratio for each of the past 30 days using Reels engagement activity.
For this question, define:
dau / mauUse the reels_events table below.
2024-06-30.activity_date, dau, mau, and dau_mau_ratio rounded to 4 decimal places.activity_date ascending.| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Primary key for each Reels event |
| user_id | INT | Meta user identifier |
| event_name | VARCHAR(50) | Type of Instagram Reels event |
| event_time | TIMESTAMP | Timestamp when the event occurred |
| surface | VARCHAR(50) | Meta product surface where the event happened |
| country_code | VARCHAR(2) | Two-letter country code |