By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 4
| class | start_date | end_date | date |
|---|---|---|---|
| a | 2021-01-01 | 2021-01-04 | 2021-01-01 |
| a | 2021-01-01 | 2021-01-04 | 2021-01-02 |
| a | 2021-01-01 | 2021-01-04 | 2021-01-03 |
| a | 2021-01-01 | 2021-01-04 | 2021-01-04 |
| b | 2021-01-03 | 2021-01-05 | 2021-01-03 |
| b | 2021-01-03 | 2021-01-05 | 2021-01-04 |
| b | 2021-01-03 | 2021-01-05 | 2021-01-05 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-06 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-07 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-08 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-09 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-10 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-11 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-12 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-13 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-14 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-15 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-16 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-17 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-18 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-19 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-20 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-21 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-22 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-23 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-24 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-25 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-26 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-27 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-28 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-29 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-30 |
| c | 2021-01-06 | 2021-02-01 | 2021-01-31 |
| c | 2021-01-06 | 2021-02-01 | 2021-02-01 |
| d | 2021-02-04 | 2021-02-10 | 2021-02-04 |
| d | 2021-02-04 | 2021-02-10 | 2021-02-05 |
| d | 2021-02-04 | 2021-02-10 | 2021-02-06 |
| d | 2021-02-04 | 2021-02-10 | 2021-02-07 |
| d | 2021-02-04 | 2021-02-10 | 2021-02-08 |
| d | 2021-02-04 | 2021-02-10 | 2021-02-09 |
| d | 2021-02-04 | 2021-02-10 | 2021-02-10 |
SELECT 41