List the department names and the number of their employees

Q. List the department names and the number of their employees.

Consider this table --

SALARYGRADE ( LOWSAL , HIGHSAL , GRADE )
DEPT(DEPTNO. , DEPTNAME , LOCATION)

You can understand by seeing this video ---

Answer =

SELECT DEPTNAME ,COUNT( EMPL.DEPTNO ) FROM EMPL, DEPT WHERE EMPL.DEPTNO = DEPT.DEPTNO ;