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
Investigate this case →