By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
dateOfCheckup | duration | minutes | total | monthOfCheckup |
---|---|---|---|---|
2020-05-28 | 30 min | 30 | 30 | 2020-05 |
2020-05-29 | 30 min | 30 | 60 | 2020-05 |
2020-05-30 | 2 hour | 120 | 180 | 2020-05 |
2020-06-03 | 1 hour 30 min | 90 | 90 | 2020-06 |
2020-06-05 | 30 min | 30 | 120 | 2020-06 |
2020-07-21 | 1 hour 30 min | 90 | 90 | 2020-07 |
2020-07-22 | 30 min | 30 | 120 | 2020-07 |
2020-07-28 | 1 hour 30 min | 90 | 210 | 2020-07 |
dateOfCheckup | duration | minutes | 99457Elig | 99458Elig | monthOfCheckup | total |
---|---|---|---|---|---|---|
2020-05-28 | 30 min | 30 | 1 | 0 | 2020-05 | 30 |
2020-05-29 | 30 min | 30 | 0 | 1 | 2020-05 | 60 |
2020-05-30 | 2 hour | 120 | 0 | 0 | 2020-05 | 180 |
2020-06-03 | 1 hour 30 min | 90 | 1 | 1 | 2020-06 | 90 |
2020-06-05 | 30 min | 30 | 0 | 0 | 2020-06 | 120 |
2020-07-21 | 1 hour 30 min | 90 | 1 | 1 | 2020-07 | 90 |
2020-07-22 | 30 min | 30 | 0 | 0 | 2020-07 | 120 |
2020-07-28 | 1 hour 30 min | 90 | 0 | 0 | 2020-07 | 210 |