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 COUNTf) FROM Employee
[B]
SELECT DepartmentNo. COUNT(*) FROM Employee GROUP BY DepartmentNo
[C]
SELECT DepartmentNo. COUNT(*) FROM Employee
[D]
None of the others
Answer: B