Cold Case~56min
The Near-Miss Reports That Stopped Coming From One Shift
Shift C's near-miss reports dropped to zero right after a new supervisor took over — but workers'-comp claims for Shift C stayed exactly as frequent as before. If safety had improved, claims should have dropped too. Nearly every missing report would have named EQUIPMENT-42, which the new supervisor also controls the maintenance budget for. Shift A also saw reports drop, but its claims dropped too — a real improvement.
Tables you'll query
shiftsnear_miss_reportsworkers_comp_claims
What you'll learn
JOINsDate & Time FunctionsAggregations & GROUP BY