By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| dt | goods | price |
|---|---|---|
| 2020-09-01 | metal | 10.00 |
| 2020-09-01 | plastics | 2.20 |
| 2020-09-01 | paper | 5.10 |
| 2020-09-02 | metal | 12.20 |
| 2020-09-02 | plastics | 3.10 |
| 2020-09-02 | paper | 5.20 |
| 2020-09-03 | metal | 16.30 |
| 2020-09-03 | plastics | 2.90 |
| 2020-09-03 | paper | 7.10 |
| dt | goods | price | rank | TempValue | variance |
|---|---|---|---|---|---|
| 2020-09-01 | metal | 10.00 | 1 | 1.000 | 1 |
| 2020-09-02 | metal | 12.20 | 2 | 6.100 | 6.1 |
| 2020-09-03 | metal | 16.30 | 3 | 8.150 | 49.715 |
| 2020-09-01 | paper | 5.10 | 1 | 1.000 | 1 |
| 2020-09-02 | paper | 5.20 | 2 | 2.600 | 2.6 |
| 2020-09-03 | paper | 7.10 | 3 | 3.550 | 9.23 |
| 2020-09-01 | plastics | 2.20 | 1 | 1.000 | 1 |
| 2020-09-02 | plastics | 3.10 | 2 | 1.550 | 1.55 |
| 2020-09-03 | plastics | 2.90 | 3 | 1.450 | 2.2475 |