<p>EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)</p><p>DEPT (DEPTNO, DNAME, LOC)Display department-wise employee count where job is SALESMAN.</p><p>Display job-wise total commission where commission is NOT NULL.</p>