List the total number of employees in each department, whose salary is more than average salary. code example

Example: display the employees whose salary is less than average salary

select * from EMPLOYEE where sal < (select avg(emp_sal) from EMPLOYEE);