Task 2(b) New salary and difference
Task Description:
Given your solution from task (a), add another intermediate column that shows the difference between the original salary and the new salary. The difference must also be returned as integer value.
| Employee |
| ID | name | addresse | job | salary | |
| 212 | Jane Schmidt | Hamm | Steward/-esse | 2650.00 | | 312 | Walter Schmidt | Hamm | Steward/-esse | 2450.00 | | 313 | Gustav Schürmann | Hamm | Pilot | 6450.00 | | 314 | Frank Brallier | Grevenbroich | Pilot | 8450.00 | | 315 | Brandon Clark | Bonn | CEO | 10000.00 | | 325 | Dr. Karla Trinkel | Berlin | Dipl.-Ing. | 13010.00 | | 337 | Jutta Voigt | Bern | Pilot | 22000.00 | | 430 | Bernhard Smith | Wittenberg | Pilot | 9010.00 | | 514 | Blanka Brusel | Gummersbach | Fracht | 6000.00 | | 554 | Dr. Johann Krohn | Bonn | Dipl.-Ing. | 8950.00 | | 657 | Ludger Mirell | Stuttgart | Fracht | 8050.00 | | 712 | Bruno Knoll | Kernten | Steward/-esse | 3300.00 | | 713 | Bernd Kern | Stuttgart | Dipl.-Ing. | 2999.00 |
|
Your Result:
