Question

Given'Employee' table as follows :

Employee_ID	Name	Commission
101	Sabhyata Sharma	Null
102	Divya Arora	8900
103	Faizal Zaldi	Nul1

What values will the following statements return?

SELECT COUNT(*) FROM Employee;

SELECT COUNT(Commission) FROM Employee;

Answer 1

3 Employee;

1 Commission Employee;