List the count of employees grouped by deptno. (table EMPL)

Q. List the count of employees grouped by deptno. (table EMPL)

Consider  this table --

You can understand by seeing this video ---

 

Answer=

SELECT Deptno , COUNT(*)  FROM EMPL GROUP BY Deptno ;

Deptno	COUNT(*)
10	3
20	5
30	6