Using SQL or PL/SQL How do I sum up 5 minute intervals to 15 minute where the start of the interval is not midnight?
For example below the start of the interval is 00:05, 00:20, 00:35, and 00:50
Given these intervals and their values:
| Interval | Value |
|---|---|
| 00:05 | 2 |
| 00:10 | 3 |
| 00:15 | 7 |
| 00:20 | 1 |
| 00:25 | 7 |
| 00:30 | 8 |
| 00:35 | 9 |
| 00:40 | 10 |
| 00:45 | 3 |
| 00:50 | 1 |
| 00:55 | 2 |
| 00:00 | 3 |
The desired result:
| Interval | Values |
|---|---|
| 00:15 | 12 |
| 00:30 | 16 |
| 00:45 | 22 |
| 00:00 | 6 |