By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version() |
|---|
| 10.3.28-MariaDB |
| date | tutor | pupil | hours |
|---|---|---|---|
| 2021-01-01 | 1 | 10 | 1 |
| 2021-01-02 | 1 | 11 | 1 |
| 2021-01-02 | 2 | 13 | 1 |
| 2021-01-04 | 1 | 13 | 1 |
| 2021-01-06 | 2 | 10 | 1 |
| 2021-01-06 | 2 | 11 | 1 |
| date |
|---|
| 2021-01-01 |
| 2021-01-02 |
| 2021-01-03 |
| 2021-01-04 |
| 2021-01-05 |
| 2021-01-06 |
| 2021-01-07 |
| 2021-01-08 |
| 2021-01-09 |
| 2021-01-10 |
| 2021-01-11 |
| 2021-01-12 |
| 2021-01-13 |
| 2021-01-14 |
| 2021-01-15 |
| 2021-01-16 |
| 2021-01-17 |
| 2021-01-18 |
| 2021-01-19 |
| 2021-01-20 |
| 2021-01-21 |
| 2021-01-22 |
| 2021-01-23 |
| 2021-01-24 |
| 2021-01-25 |
| 2021-01-26 |
| 2021-01-27 |
| 2021-01-28 |
| 2021-01-29 |
| 2021-01-30 |
| 2021-01-31 |
| 2021-02-01 |
| 2021-02-02 |
| 2021-02-03 |
| 2021-02-04 |
| 2021-02-05 |
| 2021-02-06 |
| 2021-02-07 |
| 2021-02-08 |
| 2021-02-09 |
| 2021-02-10 |
| 2021-02-11 |
| 2021-02-12 |
| 2021-02-13 |
| 2021-02-14 |
| 2021-02-15 |
| 2021-02-16 |
| 2021-02-17 |
| 2021-02-18 |
| 2021-02-19 |
| 2021-02-20 |
| 2021-02-21 |
| 2021-02-22 |
| 2021-02-23 |
| 2021-02-24 |
| 2021-02-25 |
| 2021-02-26 |
| 2021-02-27 |
| 2021-02-28 |
| 2021-03-01 |
| 2021-03-02 |
| 2021-03-03 |
| 2021-03-04 |
| 2021-03-05 |
| 2021-03-06 |
| 2021-03-07 |
| 2021-03-08 |
| 2021-03-09 |
| 2021-03-10 |
| 2021-03-11 |
| 2021-03-12 |
| 2021-03-13 |
| 2021-03-14 |
| 2021-03-15 |
| 2021-03-16 |
| 2021-03-17 |
| 2021-03-18 |
| 2021-03-19 |
| 2021-03-20 |
| 2021-03-21 |
| 2021-03-22 |
| 2021-03-23 |
| 2021-03-24 |
| 2021-03-25 |
| 2021-03-26 |
| 2021-03-27 |
| 2021-03-28 |
| 2021-03-29 |
| 2021-03-30 |
| 2021-03-31 |
| 2021-04-01 |
| 2021-04-02 |
| 2021-04-03 |
| 2021-04-04 |
| 2021-04-05 |
| 2021-04-06 |
| 2021-04-07 |
| 2021-04-08 |
| 2021-04-09 |
| 2021-04-10 |
| 2021-04-11 |
| 2021-04-12 |
| 2021-04-13 |
| 2021-04-14 |
| 2021-04-15 |
| 2021-04-16 |
| 2021-04-17 |
| 2021-04-18 |
| 2021-04-19 |
| date | tutor | pupil | hours |
|---|---|---|---|
| 2021-01-01 | null | null | null |
| 2021-01-02 | 2 | 13 | 1 |
| 2021-01-03 | null | null | null |
| 2021-01-04 | null | null | null |
| 2021-01-05 | null | null | null |
| 2021-01-06 | 2 | 10 | 1 |
| 2021-01-06 | 2 | 11 | 1 |
| 2021-01-07 | null | null | null |
| 2021-01-08 | null | null | null |
| 2021-01-09 | null | null | null |
| 2021-01-10 | null | null | null |
| 2021-01-11 | null | null | null |
| 2021-01-12 | null | null | null |
| 2021-01-13 | null | null | null |
| 2021-01-14 | null | null | null |
| 2021-01-15 | null | null | null |
| 2021-01-16 | null | null | null |
| 2021-01-17 | null | null | null |
| 2021-01-18 | null | null | null |
| 2021-01-19 | null | null | null |
| 2021-01-20 | null | null | null |
| 2021-01-21 | null | null | null |
| 2021-01-22 | null | null | null |
| 2021-01-23 | null | null | null |
| 2021-01-24 | null | null | null |
| 2021-01-25 | null | null | null |
| 2021-01-26 | null | null | null |
| 2021-01-27 | null | null | null |
| 2021-01-28 | null | null | null |
| 2021-01-29 | null | null | null |
| 2021-01-30 | null | null | null |
| 2021-01-31 | null | null | null |
| 2021-02-01 | null | null | null |
| 2021-02-02 | null | null | null |
| 2021-02-03 | null | null | null |
| 2021-02-04 | null | null | null |
| 2021-02-05 | null | null | null |
| 2021-02-06 | null | null | null |
| 2021-02-07 | null | null | null |
| 2021-02-08 | null | null | null |
| 2021-02-09 | null | null | null |
| 2021-02-10 | null | null | null |
| 2021-02-11 | null | null | null |
| 2021-02-12 | null | null | null |
| 2021-02-13 | null | null | null |
| 2021-02-14 | null | null | null |
| 2021-02-15 | null | null | null |
| 2021-02-16 | null | null | null |
| 2021-02-17 | null | null | null |
| 2021-02-18 | null | null | null |
| 2021-02-19 | null | null | null |
| 2021-02-20 | null | null | null |
| 2021-02-21 | null | null | null |
| 2021-02-22 | null | null | null |
| 2021-02-23 | null | null | null |
| 2021-02-24 | null | null | null |
| 2021-02-25 | null | null | null |
| 2021-02-26 | null | null | null |
| 2021-02-27 | null | null | null |
| 2021-02-28 | null | null | null |
| 2021-03-01 | null | null | null |
| 2021-03-02 | null | null | null |
| 2021-03-03 | null | null | null |
| 2021-03-04 | null | null | null |
| 2021-03-05 | null | null | null |
| 2021-03-06 | null | null | null |
| 2021-03-07 | null | null | null |
| 2021-03-08 | null | null | null |
| 2021-03-09 | null | null | null |
| 2021-03-10 | null | null | null |
| 2021-03-11 | null | null | null |
| 2021-03-12 | null | null | null |
| 2021-03-13 | null | null | null |
| 2021-03-14 | null | null | null |
| 2021-03-15 | null | null | null |
| 2021-03-16 | null | null | null |
| 2021-03-17 | null | null | null |
| 2021-03-18 | null | null | null |
| 2021-03-19 | null | null | null |
| 2021-03-20 | null | null | null |
| 2021-03-21 | null | null | null |
| 2021-03-22 | null | null | null |
| 2021-03-23 | null | null | null |
| 2021-03-24 | null | null | null |
| 2021-03-25 | null | null | null |
| 2021-03-26 | null | null | null |
| 2021-03-27 | null | null | null |
| 2021-03-28 | null | null | null |
| 2021-03-29 | null | null | null |
| 2021-03-30 | null | null | null |
| 2021-03-31 | null | null | null |
| 2021-04-01 | null | null | null |
| 2021-04-02 | null | null | null |
| 2021-04-03 | null | null | null |
| 2021-04-04 | null | null | null |
| 2021-04-05 | null | null | null |
| 2021-04-06 | null | null | null |
| 2021-04-07 | null | null | null |
| 2021-04-08 | null | null | null |
| 2021-04-09 | null | null | null |
| 2021-04-10 | null | null | null |
| 2021-04-11 | null | null | null |
| 2021-04-12 | null | null | null |
| 2021-04-13 | null | null | null |
| 2021-04-14 | null | null | null |
| 2021-04-15 | null | null | null |
| 2021-04-16 | null | null | null |
| 2021-04-17 | null | null | null |
| 2021-04-18 | null | null | null |
| 2021-04-19 | null | null | null |