By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
292 rows affected
| DAY | NAME | COUNT_PERSON |
|---|---|---|
| 01-MAY-20 | person_1 | 0 |
| 02-MAY-20 | person_1 | 0 |
| 03-MAY-20 | person_1 | 0 |
| 04-MAY-20 | person_1 | 220 |
| 05-MAY-20 | person_1 | 220 |
| 06-MAY-20 | person_1 | 30 |
| 07-MAY-20 | person_1 | 30 |
| 08-MAY-20 | person_1 | 30 |
| 09-MAY-20 | person_1 | 30 |
| 10-MAY-20 | person_1 | 30 |
| 11-MAY-20 | person_1 | 30 |
| 12-MAY-20 | person_1 | 30 |
| 13-MAY-20 | person_1 | 30 |
| 14-MAY-20 | person_1 | 30 |
| 15-MAY-20 | person_1 | 12 |
| 16-MAY-20 | person_1 | 12 |
| 17-MAY-20 | person_1 | 12 |
| 18-MAY-20 | person_1 | 12 |
| 19-MAY-20 | person_1 | 12 |
| 20-MAY-20 | person_1 | 12 |
| 21-MAY-20 | person_1 | 12 |
| 22-MAY-20 | person_1 | 12 |
| 23-MAY-20 | person_1 | 12 |
| 24-MAY-20 | person_1 | 12 |
| 25-MAY-20 | person_1 | 12 |
| 26-MAY-20 | person_1 | 12 |
| 27-MAY-20 | person_1 | 12 |
| 28-MAY-20 | person_1 | 12 |
| 29-MAY-20 | person_1 | 12 |
| 30-MAY-20 | person_1 | 12 |
| 31-MAY-20 | person_1 | 30 |