Routine~13min

The Leave-Day Clockin

HR noticed some employees have attendance records on dates they had approved leave. Either leave was cancelled without updating the system, or payroll is about to pay them twice. Find everyone who clocked in on an approved leave day.

Tables you'll query

employeesleave_requestsattendance

What you'll learn

JOINs
Investigate this case →