By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| hour | subscriptions | unsubscriptions |
|---|---|---|
| 2025-05-19 22:00:00+01 | 0 | 1 |
| 2025-05-19 23:00:00+01 | 0 | 0 |
| 2025-05-20 00:00:00+01 | 0 | 0 |
| 2025-05-20 01:00:00+01 | 1 | 1 |
| 2025-05-20 02:00:00+01 | 0 | 0 |
| 2025-05-20 03:00:00+01 | 0 | 1 |
| 2025-05-20 04:00:00+01 | 0 | 0 |
| 2025-05-20 05:00:00+01 | 0 | 0 |
| 2025-05-20 06:00:00+01 | 1 | 0 |
SELECT 9