test.sql

CREATE TABLE events (id INTEGER PRIMARY KEY, timestamp INTEGER, machine STRING);

INSERT INTO events (timestamp, machine) VALUES (123, 'a');
INSERT INTO events (timestamp, machine) VALUES (234, 'a');
INSERT INTO events (timestamp, machine) VALUES (345, 'a');
INSERT INTO events (timestamp, machine) VALUES (456, 'a');

INSERT INTO events (timestamp, machine) VALUES (555, 'b');
INSERT INTO events (timestamp, machine) VALUES (444, 'b');
INSERT INTO events (timestamp, machine) VALUES (333, 'b');
INSERT INTO events (timestamp, machine) VALUES (222, 'b');
INSERT INTO events (timestamp, machine) VALUES (111, 'b');

INSERT INTO events (timestamp, machine) VALUES (900, 'c');

SELECT * FROM (SELECT * FROM events ORDER BY timestamp) GROUP BY machine;