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