By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 9 Duplicates: 0 Warnings: 0
| name | speed | timestamp |
|---|---|---|
| yellow | 100 | 1707532681 |
| yellow | 110 | 1707532661 |
| yellow | 120 | 1707532621 |
| yellow | 110 | 1707532631 |
| yellow | 140 | 1707532681 |
| red | 100 | 1707432681 |
| red | 120 | 1707332681 |
| red | 150 | 1707232681 |
| red | 170 | 1707532681 |
| name | speed | timestamp | avg_byColumn_Name | avg_byColumn_Name&TimeStamp |
|---|---|---|---|---|
| red | 150 | 1707232681 | 135.00 | 150.00 |
| red | 120 | 1707332681 | 135.00 | 135.00 |
| red | 100 | 1707432681 | 135.00 | 123.33 |
| red | 170 | 1707532681 | 135.00 | 135.00 |
| yellow | 120 | 1707532621 | 116.00 | 120.00 |
| yellow | 110 | 1707532631 | 116.00 | 115.00 |
| yellow | 110 | 1707532661 | 116.00 | 113.33 |
| yellow | 100 | 1707532681 | 116.00 | 116.00 |
| yellow | 140 | 1707532681 | 116.00 | 116.00 |