Calculation of a status life duration

  
id
message
status_code
stamp

1
1
1
0
10.01.2019 16:24:35

2
2
2
0
10.01.2019 16:24:35

3
3
3
0
10.01.2019 16:24:35

4
4
4
0
10.01.2019 16:24:35

5
5
5
0
10.01.2019 16:24:35

6
6
1
1
10.01.2019 16:24:36

7
7
2
1
10.01.2019 16:24:36

8
8
2
3
10.01.2019 16:24:37

9
9
3
3
10.01.2019 16:24:37

10
10
5
3
10.01.2019 16:24:37

11
11
1
4
10.01.2019 16:24:38

12
12
2
4
10.01.2019 16:24:38

13
13
3
4
10.01.2019 16:24:38

14
14
5
3
10.01.2019 16:24:38


  
message
status_code
duration

1
1
0
1

2
1
1
2

3
1
4
0

4
2
0
1

5
2
1
1

6
2
3
1

7
2
4
0

8
3
0
2

9
3
3
1

10
3
4
0

11
4
0
3

12
5
0
2

13
5
3
1

14
5
3
0