Task 2(d) Dream salary
Task Description:
Create a query that returns following string for every employee:
< name > earns < salary > per month, but desires to earn < 3?salary >. Replace all placeholders with the respective data using SQL. The new column is called desired salary.
| 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:
