How to make a query to get such a table?

Question

MySQL

There is a base with a table (an approximate view of the table on the screen is the upper table)
All data is written to it one after another. eventid 10 is user connection,
eventid 12 is disconnection.
How can I make a correct request to get the disconnect time next to the connection time in the adjacent column? (as in the screenshot - the bottom table)

Answer 1

LAG and LEAD functions

Answer 2

JOIN on itself