By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 4
| agent | quarter_hour | seconds |
|---|---|---|
| 20024 | 12:00 | 840 |
| 20024 | 12:15 | 900 |
| 20024 | 12:30 | 900 |
| 20024 | 12:45 | 900 |
| 20024 | 13:00 | 90 |
| 20011 | 08:45 | 740 |
| 20011 | 09:00 | 900 |
| 20011 | 09:15 | 900 |
| 20011 | 09:30 | 10 |
| 20010 | 08:45 | 120 |
| 20009 | 08:30 | 80 |
| 20009 | 08:45 | 280 |
SELECT 12