-- 총 정리 select deptno, count(empno), sum(sal), avg(sal) from emp where deptno != 10 group by deptno having count(empno) >= 3 order by count(empno) desc delete, update, insert -- delete (데이터 삭제) -- 삭제...