-- WHERE CLAUSE -- Display deptno, total sal and number of employees related to deptno 20 SELECT DEPTNO, SUM(SAL) AS TOTAL_SAL, COUNT(*) AS NO_OF_EMPLOYEES FROM EMP WHERE DEPTNO = 20 GROUP BY DEPTNO; ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback