List the sum of employees salaries grouped by department. (table EMPL)

Q. List the sum of employees' salaries grouped by department. (table EMPL)

Consider  this table --

You can understand by seeing this video ---

 

 

 

Answer = 

 

SELECT Deptno , SUM(Sal)  FROM EMPL GROUP BY Deptno ;

deptno	Sum(sal)
10	8750
20	10885
30	9400