(Choose 1 answer)
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
Exit 28
