Given the following table:
| ENO | SALARY |
|---|---|
| A101 | 4000 |
| B109 | NULL |
| C508 | 6000 |
| A305 | 2000 |
State the output of the following query:
SELECT COUNT(SALARY) FROM EMPLOYEE;
| List-I (Aggregate function) | List-II (Description) |
|---|---|
(A) count(marks) | (III) Count all non null values of marks column |
(B) count() | (I) Count all rows |
(C) avg(marks) | (II) Finding average of non null values of marks |
(D) sum(marks) | (IV) Finding sum of all marks |
| List-I | List-II |
|---|---|
| (A) Primary key | (III) Attribute used to uniquely identify a tuple. |
| (B) Degree | (I) Total number of attributes in a table. |
| (C) Foreign key | (II) Attribute used to relate two tables. |
| (D) Constraint | (IV) A restriction on the type of data that can be inserted in a column. |
Rearrange the following parts to form a meaningful and grammatically correct sentence:
P. a healthy diet and regular exercise
Q. are important habits
R. that help maintain good physical and mental health
S. especially in today's busy world