Task 2(a) New Salary for Employees
Task Description:
Determine employee_Id, name and salary of all employees. Add an intermediate column new_salary to the result that shows the current salary increased by 15%. The new salary must 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:
