Interval between different calls

[rotter]

Hi everyone! Can you help me, please?

I have a log table with calls.

Each call has:

• An operator (ID Operator);
• A local (ID Local);
• A protocol (ID Protocol).

Call starts at status 2 and ends on 3 (Status).
All calls follow the order of the date (Date).

I need to create a table with two columns showing the interval between a call and other.
For example (considering only one operator):

In the red square has a interval. The operator 285 ends the protocol 2339169 and then starts the call of protocol 2353897.

I need something like that for each interval, with operator and local, without the interval between one day and other.

I attached the qvd.
Thanks in advance.

[vidyut]

Good Work. There are many ways to solve a problem, and many of us stop when we see a problem that is not straightforward to solve. Instead, thinking about the problem and breaking it down into smaller ones really helps in solving it, as well as pushing yourself to try and think of different approaches. 

I intentionally resisted giving you the code, as that kills the joy of solving the problem. Maybe later when I am doing a session on interesting problems, I will invite you.

Cheers