drop table jutice_student;
create table jutice_student
as select d.deptno, min(dname),(select count(s.name)
from student s
where d.DEPTNO=S.DEPTNO1) "count",
(select count(p.name)
from professor p
where (d.DEPTNO=p.DEPTNO)
) "count1"
from department d group by d.deptno;
**전자 -> 영업1팀 2300 10명
**반도체 -> 영업1팀 2401 30명
select d.deptno,
(select count(p.name)
from professor p
where (d.DEPTNO=p.DEPTNO) ) "count1"
from department d
group by d.deptno;
select * from jutice_student;