By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| DateTime | TagName | Value |
|---|---|---|
| 2021-11-09 00:00:00.000 | AAA | -1.00000 |
| 2021-11-09 00:01:00.000 | AAA | 5.00000 |
| 2021-11-09 00:02:00.000 | AAA | 12.00000 |
| 2021-11-09 00:03:00.000 | AAA | 6.00000 |
| 2021-11-09 00:04:00.000 | AAA | 0.00000 |
| 2021-11-09 01:00:00.000 | AAA | 2.00000 |
| 2021-11-09 01:02:00.000 | AAA | 5.00000 |
| 2021-11-09 01:04:00.000 | AAA | 0.00000 |
| 2021-11-09 01:58:00.000 | AAA | 9.00000 |
| 2021-11-09 01:59:00.000 | AAA | 22.00000 |
| OnHour | value | 工作時間 |
|---|---|---|
| 0 | 7.666666 | 3 |
| 1 | 9.500000 | 4 |