Comprehension Passage
Consider the folllowing:
|
Emp No |
Ename |
Salary |
Bonus |
DeptId |
|
101 |
Aaliya |
10000 |
234 |
D02 |
|
102 |
Kritika |
60000 |
123 |
D01 |
|
103 |
Shabbir |
45000 |
566 |
D01 |
|
104 |
Gurpreet |
19000 |
565 |
D04 |
|
105 |
Joseph |
34000 |
875 |
D03 |
|
106 |
Sanya |
48000 |
695 |
D02 |
|
107 |
Vergese |
15000 |
NULL |
D01 |
|
108 |
Nachaobi |
29000 |
NULL |
D05 |
|
109 |
Daribha |
42000 |
NULL |
D04 |
|
110 |
Tanya |
50000 |
467 |
D05 |
SELECT MAX(Salary) FROM EMPLOYEE WHERE Bonus IS NOT NULL AND Deptid IN ('D01', 'D02);
1
48000
2
50000
3
60000
4
45000