Salary Per Department

select	dname			as "Department"
,	count(empno)		as "#Employees"
,	sum(ifnull(sal,0))	as "Total Salary"
,	avg(ifnull(sal,0))	as "Average Salary"
from emp right join dept on emp.deptno = dept.deptno
group by dname
order by dname