-- 1. 조인 후 그룹바이 -- SELECT d.dname AS "부서명" , MAX(e.sal) AS "최대급여" , MIN(e.sal) AS "최소급여" FROM emp e INNER JOIN dept d ON e.deptno = d.deptno GROUP BY e.deptno, d.dname HAVING MAX(e.sal) > 500 ; -- 2. 그룹바이 후 인라인뷰를 이용한 조인 SELECT d.dname AS 부서명 , e.최대급여 , e.최소급여 FROM (SELECT deptno , MAX(sal) AS 최대급여 , MIN(sal) AS 최소급여 FROM emp GROUP BY deptno HAVING MAX(sal) > 500 ) e INNER JOIN dept d ON e.deptno = d.deptno ; -- 3. 스칼라 서브쿼리를 이용한 조인 SELECT (SELECT d.dname FROM dept d WHERE d.deptno = e.deptno) AS 부서명 , MAX(sal) AS 최대급여 , MIN(sal) AS 최소급여 FROM emp e GROUP BY deptno HAVING MAX(sal) > 500 ;