Sum Employee Working Time from Ordered Check-In and Check-Out Events
Company: Agoda
Role: Data Engineer
Category: Data Manipulation (SQL/Python)
Difficulty: easy
Interview Round: Technical Screen
Overview: Pair ordered employee attendance events and total working seconds, including multiple shifts and intervals crossing midnight.
Read the full Agoda Data Engineer interview experience this question came from