Let's say for example you have a table like this:
-------------------------------
Date Name Type
2017-01-01 John 1
2017-01-02 John 1
2017-01-03 Mike 2
2017-01-04 John 1
-------------------------------
I want to be able to group by the type to get a result like the following
-------------------------
Name Type
John 1
Mike 2
John 1
-------------------------
As you can see the first two rows was grouped because there is no different type in between them, like the thing you see in mobile phones call logs.
How can I achieve that in SQLite?