How to Write HQL/SQL to Solve Consecutive Timestamp Differences in a Dataset

Hibernate HQL Sum Case When Then Else End Clause in Java Problem