By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| origin | desti | yr | mt | q |
|---|---|---|---|---|
| toto | coucou | 2019 | 1 | 1.4 |
| toto | coucou | 2019 | 2 | 2.5 |
| toto | coucou | 2019 | 3 | 1.2 |
| tata | yoyo | 2018 | 11 | 5.4 |
| tata | yoyo | 2018 | 12 | 5.5 |
| tata | yoyo | 2019 | 1 | 5.2 |
| origin | desti | yr | mt | q | ?column? | sum |
|---|---|---|---|---|---|---|
| tata | yoyo | 2018 | 11 | 5.4 | 0.0 | -5.4 |
| tata | yoyo | 2018 | 12 | 5.5 | -5.4 | -10.9 |
| tata | yoyo | 2019 | 1 | 5.2 | -10.9 | -16.1 |
| toto | coucou | 2019 | 1 | 1.4 | 0.0 | -1.4 |
| toto | coucou | 2019 | 2 | 2.5 | -1.4 | -3.9 |
| toto | coucou | 2019 | 3 | 1.2 | -3.9 | -5.1 |