Total listener time per live audio room from an event log
A time-ordered log records rooms being created and users joining and leaving them. Compute the total user-time spent in each room, handling users who never leave and rooms that end. Follow-ups slice the same totals other ways.
No answer yet. Write the first one; the best answer gets endorsed.