The outer question will get the length in the fix work. The complex subquery calculates the total number of days not looking ahead to pieces. That is done by finding the start dates where the vehicle just isn't awaiting areas, and after that depend the number of days until eventually it begins t