By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 7 Duplicates: 0 Warnings: 0
| Student | Time_ | expected_count |
|---|---|---|
| A | 05:00:00 | 1 |
| B | 07:00:00 | 2 |
| A | 08:00:00 | 2 |
| C | 09:00:00 | 3 |
| D | 10:00:00 | 4 |
| E | 11:00:00 | 5 |
| D | 12:00:00 | 5 |