By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
INSERT 0 16
| clientmac | apmac | start_time | dwell_time |
|---|---|---|---|
| 1 | a | 2019-11-01 12:01:00+00 | 00:09:00 |
| 1 | b | 2019-11-01 12:10:00+00 | 00:15:00 |
| 1 | a | 2019-11-01 12:25:00+00 | 02:10:00 |
| 2 | a | 2019-11-01 12:20:00+00 | 00:02:00 |
SELECT 4