with summary as (select dname,sum(Score) as dept_total from stu,dept where stu.deptno=dept.deptno group by dname )
select dname,dept_total from summary where dept_total> (select sum(dept_total)*1/3 from summary );
1min目标场景问卷
立即参与
