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