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