Tricky~22min

The Driver Logged Hours During Maintenance

8 trucks have driving hours logged while an out_of_service maintenance ticket was open — the truck should have been grounded. 12 more trucks also logged driving hours during an open ticket, but its severity was cosmetic — a minor issue that never took the truck off the road.

Tables you'll query

trucksmaintenance_ticketshours_of_service

What you'll learn

JOINsDate & Time Functions
Investigate this case →