总算把这题做出来拉.
select t3.dname,avg(t4.sal),round(t3.sal*100/sum(t4.sal),2)||'%' from (select t1.deptno,t1.sal,t2.dname from emp t1,dept t2 where t1.deptno=t2.deptno and t1.ename='SMITH') t3,emp t4 where t3.deptno=t4.deptno group by t3.dname,t3.sal;
select t3.dname,avg(t4.sal),round(t3.sal*100/sum(t4.sal),2)||'%' from (select t1.deptno,t1.sal,t2.dname from emp t1,dept t2 where t1.deptno=t2.deptno and t1.ename='SMITH') t3,emp t4 where t3.deptno=t4.deptno group by t3.dname,t3.sal;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货