Number of days in random lines

[Anonymous]

I have a SQL table with a history of vehicle movements. Each line is a movement, with movement code, vehicle code, company of origin and destination, initial and final mileage, initial and final date and the vehicle status in that movement (example: leased, under maintenance, washing, etc.) .
I need to count the number of days that a vehicle takes from status x to another status y, and it may or may not pass through other statuses in that interval with varying number of days.
The table is neither separated nor ordered by vehicle.
Any tips where to start?

[Anonymous]

Without seeing a table with the data it's not possible to help you. Sorry.

[Fowmy]

@Anonymous 

Sure we can help you out,

Can you share some sample data and the expected result as data to have a clear understanding of your question?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn