Classify Teams by January Active Users

How would you solve intermediate SQL questions involving an unfamiliar schema under time pressure at Dropbox?

Using the provided Dropbox schema, write one PostgreSQL query that summarizes January 2025 activity for every team. Include teams with no qualifying activity and classify each team based on its number of active users.

Output

1. One row per team with team_name, active_users, uploaded_bytes, latest_event_at, and activity_status
2. Include all teams, including teams with no qualifying events
3. Sort by active_users descending, then team_name ascending

Output details

• Count each user only once when determining active_users.
• Treat January as event_at >= TIMESTAMP '2025-01-01 00:00:00' and event_at < TIMESTAMP '2025-02-01 00:00:00'.
• Sum bytes only for upload events, treating NULL bytes and non-upload events as zero.
• Use 0 for active_users and uploaded_bytes, and NULL for latest_event_at, when a team has no qualifying events.
• Classify teams with at least 2 active users as active; classify all others as low_activity.