SQLITE Split Datetime to Logon/Logoff

Hy, i want to split the time to 2 columns by Event type.

My Table looks like this:

And i want to split the Time with EventType like this in SQLite:

any ideas?

>Solution :

assuming there is no double logons without logoff, as in your example, you can do this:

select user, 
       logon_time, 
       logoff_time 
  from (select user, 
               time logon_time,
               lead(time) over(partition by user order by time) logoff_time,
               event_type
          from test_table)
 where event_type = 'Logon';

The LEAD function takes value from next line using ordering from "order by" part. In your case a logoff event takes place only after a logon, so it might working

db_fiddle