By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| customer_id | hour |
|---|---|
| X | 2019-04-01 13:00:00 |
| X | 2019-04-01 14:00:00 |
| X | 2019-04-01 15:00:00 |
| X | 2019-04-01 16:00:00 |
| X | 2019-04-01 17:00:00 |
| Y | 2019-04-01 17:00:00 |
| Y | 2019-04-01 18:00:00 |
| Y | 2019-04-01 19:00:00 |