so_data.sql

CREATE OR REPLACE VIEW mytable AS SELECT * FROM
(
    VALUES
        (1, '2018-08-03 05:00:00+00', 100, 10, 1000),
        (2, '2018-08-03 05:00:00+00', 100, 11, 1001),
        (3, '2018-08-03 05:00:00+00', 100, 12, 1002),
        (4, '2018-08-03 05:00:00+00', 100, 13, 1003),
        --
        (5, '2018-08-03 05:01:00+00', 200, 20, 2000),
        (6, '2018-08-03 05:01:00+00', 100, 10, 1000),
        (7, '2018-08-03 05:01:00+00', 100, 11, 1001),
        (8, '2018-08-03 05:01:00+00', 100, 12, 1002),
        (9, '2018-08-03 05:01:00+00', 100, 13, 1003),
        --
        (10, '2018-08-03 05:02:00+00', 100, 11, 1001),
        (11, '2018-08-03 05:02:00+00', 100, 12, 1002),
        (12, '2018-08-03 05:02:00+00', 100, 13, 1003),
        --
        (13, '2018-08-03 05:03:00+00', 100, 11, 1001),
        (14, '2018-08-03 05:03:00+00', 100, 12, 1002)
) AS t (id, ts, stop_sms, service, vehicle_ref);

-- Should return
 id  | stop_sms | service | vehicle_ref |       after_ts
-----+----------+---------+-------------+-----------------------
  5  |      100 |      10 |        1000 | 2018-08-03 05:02:00+00 -- Because not present in group with ts='2018-08-03 05:02:00+00'
  11 |      100 |      13 |        1003 | 2018-08-03 05:03:00+00 -- Because not present in group with ts='2018-08-03 05:03:00+00'

-- after_ts is the first timestamp that did not include the (stop_sms, service, vehicle_ref) combination, it's a nice-to-have