1¹ø
SELECT d.dept_name ºÎ¼­¸í, count(s.study_name) ºÎ¼­Àοø FROM study s, dept d WHERE d.dept_no = s.dept_no(+) GROUP BY d.dept_name order by ºÎ¼­Àοø desc; 


2¹ø
SELECT d.dept_name ºÎ¼­¸í, ROUND(AVG(s.pay),0) ºÎ¼­Æò±Õ±Þ¿© FROM study s, dept d WHERE s.dept_no = d.dept_no GROUP BY d.dept_name HAVING AVG(s.pay) > (SELECT AVG(s.pay) FROM study s, dept d WHERE d.dept_name = 'ÀÚ¹Ù' and s.dept_no = d.dept_no);

3¹ø
select d.dept_name ºÎ¼­¸í, s.study_name À̸§, s.pay ±Þ¿© from study s, dept d
where s.dept_no = d.dept_no and (s.dept_no, s.pay) in   
(select dept_no, min(pay) from study group by dept_no)
order by s.pay;

select result.dname ºÎ¼­¸í, emp.ename À̸§, result.minsal ±Þ¿©
from emp, (select dname, emp.deptno, min(sal) minsal
           from emp, dept
           where emp.deptno = dept.deptno
           group by dname, emp.deptno) result
where emp.deptno=result.deptno and emp.sal=result.minsal
order by minsal;

select dname, ename, sal from (select dname, ename, sal from (select dname, min(sal) minsal from em[, dept where emp.deptno = dept.deptno group by dname order by min(sal) temp, emp where temp.minsal = emp.sal;













                                                           - ¼ö°í Çϼ̽À´Ï´Ù -