The outer question will get the period with the repair service work. The complex subquery calculates the total number of days not looking ahead to components. This can be done by locating the start dates where the vehicle is not awaiting elements, after which you can rely the number of days until it begins to anticipate sections all over again:Like