How to get how much time a row was in the same state

[gudns]

So, my problem is:

I have a bunch of equal IDs, and I want to check when a value is changed in another column. When changed, I need to return how much time the value was the same before changing and say what it was and what it became:

Each ID appears for the same amount, and each one have a status column, here's an example with one of the IDs:

id	status	date_check
1135381099869705	x	a
1135381099869705	x	b
1135381099869705	x	c
1135381099869705	x	d
1135381099869705	y	e
1135381099869705	y	f
1135381099869705	y	g
1135381099869705	z	h
1135381099869705	z	i
1135381099869705	z	j
1135381099869705	z	k
1135381099869705	z	l
1135381099869705	z	m

Basically, I need to check when X became Y, then return the difference of dates e and a (I already have these dates). The same for when Y becomes Z.