By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| id | name | datetime | cnt |
|---|---|---|---|
| 44 | once | 2022-11-22 15:41:00.000 | 3 |
| 44 | once | 2022-11-22 15:42:00.000 | 3 |
| 44 | once | 2022-11-22 15:43:00.000 | 3 |
| 44 | once | 2022-11-22 16:41:00.000 | 1 |
| 44 | twice | 2022-11-22 15:44:00.000 | 1 |
| 55 | once | 2022-11-22 17:47:00.000 | 2 |
| 55 | once | 2022-11-22 17:51:00.000 | 2 |
| 55 | thrice | 2022-11-22 17:44:00.000 | 2 |
| 55 | thrice | 2022-11-22 17:46:00.000 | 2 |
| 55 | thrice | 2022-11-22 18:51:00.000 | 1 |
| 55 | twice | 2022-11-22 18:41:00.000 | 1 |