Task 4.5a SQL Abfragen
Task Description:
Output the name and salary (Gehalt) of the employees (table Angestellter), whose salary is bigger than 4.000!
| Angestellter |
| AngNr | AName | AAdresse | Beruf | Gehalt | |
| 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:
