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 |
What will be the output of the SQL query based on above EMPLOYEE table.
SELECT COUNT(*) FROM EMPLOYEE WHERE BONUS IS NULL;
1
2
2
3
3
4
4
5