How to calculate the session in SQL without using Window Functions?

I have tried to calculate the session in Druid using the window functions, but apparently Druid does not support Window Functions.

I have user_id and session_timestamp. I need to calculate the session duration and the number of sessions for this user.

Considering that if the user was not active after 30 minutes, the session ends.

Thank you in advance