DBI202Xuất hiện trong 1 đề thi
Given the relation Employee(SSN, FNAME, LNAME, SALARY, DepartmentNo). Select the right query below to count the number of employees in each department.
Các lựa chọn
A```sql
SELECT COUNT(*) FROM Employee
```
B```sql
SELECT DepartmentNo, COUNT(*) FROM Employee GROUP BY DepartmentNo
```
C```sql
SELECT DepartmentNo, COUNT(*) FROM Employee
```
DNone of the others