By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 30 Duplicates: 0 Warnings: 0
| LocationID | EventTime | Temp | SystemStatus |
|---|---|---|---|
| 99999999 | 1 | 75.87 | System On |
| 99999999 | 2 | 80.71 | System On |
| 99999999 | 3 | 83.00 | System On |
| 99999999 | 4 | 89.00 | System On |
| 99999999 | 5 | 91.00 | System On |
| 99999999 | 6 | 95.00 | System Off |
| 99999999 | 7 | 82.00 | System Off |
| 99999999 | 8 | 80.00 | System Off |
| 99999999 | 9 | 73.00 | System On |
| 99999999 | 10 | 74.00 | System On |
| 99999999 | 11 | 75.00 | System On |
| 99999999 | 12 | 75.00 | System On |
| 99999999 | 13 | 75.00 | System On |
| 99999999 | 14 | 76.00 | System On |
| 99999999 | 15 | 76.00 | System On |
| 99999999 | 16 | 77.00 | System On |
| 99999999 | 17 | 80.00 | System On |
| 99999999 | 18 | 81.00 | System On |
| 99999999 | 19 | 82.00 | System On |
| 99999999 | 20 | 82.00 | System On |
| 99999999 | 21 | 83.00 | System On |
| 99999999 | 22 | 87.00 | System On |
| 99999999 | 23 | 87.00 | System On |
| 99999999 | 24 | 91.00 | System On |
| 99999999 | 25 | 91.00 | System On |
| 99999999 | 26 | 96.00 | System Off |
| 99999999 | 27 | 66.00 | System On |
| 99999999 | 28 | 58.00 | System On |
| 99999999 | 29 | 58.00 | System On |
| 99999999 | 30 | 65.00 | System On |