m0_59662334: -- 4、查询目前总分最高的院系名称及分数; SELECT * from(select department,sum(mark) sum_mark from athlete s join grade g on s.athlete=g.athlete group by department order by sum_mark desc) where rownum