Routine~12min
The Employee Paid Twice For The Same Pay Period
A failed payroll batch on May 15th got re-run without anyone rolling back the first attempt. Finance just noticed 4 employees have two separate "regular" deposits for the exact same May 31st pay period — same amount, same period, paid out twice. A few employees also show a second May payment, but that's their quarterly bonus, not a duplicate — don't flag those.
Tables you'll query
employeespayroll_deposits
What you'll learn
Aggregations & GROUP BY