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