Routine~10min

The Double Salary

Two months in a row, one employee's salary was paid twice — once by the regular payroll run and once via a manual "correction" entry. Net overpayment: ₹2,14,000. Find who, when, and confirm another payment that looks suspicious but is actually legitimate.

Tables you'll query

employeespayroll

What you'll learn

Aggregations & GROUP BYJOINs
Investigate this case →