Design a data model and write queries on it to answer questions.
Asked in the onsite stage. Create a model containing users, experiences, and activity sessions, then report engagement for January 2025.
Output
- One row per experience, including experiences with no January sessions.
- Columns:
experience_name, creator_name, active_users, total_minutes, and avg_session_minutes.
- Include distinct active users and ignore sessions outside January 2025. Sort by active users descending, then experience name ascending.