Pro exercise

Payroll hours per team

Turn raw timesheet entries into payroll hours per team: resolve each employee's team, validate the day and the hours, keep only the latest resubmission for each employee and day, and only then total. Every rejected row carries one reason.

pipelines
lookups
duplicates
aggregation