Tricky~22min

The Pilot Over the Duty Limit

5 pilots logged over 15 hours of actual flight duty in a single day — past the 14-hour regulatory limit. Several more pilots also show over 14 total hours logged that day, but that total mixes in reserve/standby time, which doesn't count toward the flight-duty limit at all.

Tables you'll query

pilotsduty_logs

What you'll learn

Aggregations & GROUP BY
Investigate this case →