CREATE TEMPORARY TABLE user_sessions(session TEXT, "user" TEXT, event TEXT, time TIMESTAMP);

INSERT INTO user_sessions (session, "user", event, time)
VALUES ('B','Alice','login','2020-07-02T12:00:12'),
       ('A','Bob','logout','2020-07-02T12:01:11'),
       ('B','Eve','publish','2020-07-02T12:02:22'),
       ('B','Alice','publish','2020-07-02T12:11:00'),
       ('C','Mallory','login','2020-07-02T12:12:20'),
       ('A','Bob','publish','2020-07-02T12:12:21'),
       ('B','Alice','publish','2020-07-02T12:20:12'),
       ('B','Alice','logout','2020-07-02T12:22:20')
