Routine~12min

The Missing Audit Log

Nineteen salary adjustments were modified after creation — updated_at is newer than created_at — but none of them have a corresponding entry in the audit_log. An admin script ran while the audit trigger was temporarily disabled for a "performance fix." Find the adjustments that changed without a trace.

Tables you'll query

salary_adjustmentsaudit_log

What you'll learn

JOINsDate & Time Functions
Investigate this case →