Quick Overview

Identify dates when every employee is present and compute the longest consecutive streak, treating missing attendance as a gap.

Find the Longest Calendar-Day Streak with All Employees Present

Company: Agoda

Role: Data Engineer

Category: Data Manipulation (SQL/Python)

Difficulty: easy

Interview Round: Technical Screen

Overview: Identify dates when every employee is present and compute the longest consecutive streak, treating missing attendance as a gap.

Read the full Agoda Data Engineer interview experience this question came from

Loading…