Given the relation Employee(SSN, FNAME, LNAME, SALARY, DepartmentNo). Select the right query below to count the number of employees in each department.
a. SELECT COUNT(*) FROM Employee
b. SELECT DepartmentNo, COUNT(*) FROM Employee GROUP BY DepartmentNo
c. SELECT DepartmentNo, COUNT(*) FROM Employee
d. None of the others
Answer: B