Question 7:
Zoom
FUO
Picture 6.1
Write a query to display all employees whose Salary is greater than Salary of 'Janette King'.
The result includes EmployeeID, FirstName, LastName, Salary
Results
Messages
EmployeeID
First Name
Last Name
Salary
1
100
Steven
King
24000
2
101
Neena
Kochhar
17000
3
102
Lex
De Haan
17000
4
108
Nancy
Greenberg
12000
5
114
Den
Raphaely
11000
6
145
John
Russell
14000
7
146
Karen
Partners
13500
8
147
Alberto
Errazuriz
12000
9
148
Gerald
Cambrault
11000
10
149
Eleni
Zlotkey
10500
11
162
Clara
Vishney
10500
12
168
Lisa
Ozer
11500
13
174
Ellen
Abel
11000
+ 100%
Close
