62,614
社区成员
发帖
与我相关
我的任务
分享
select ss.*,sc.* from student ss,
(select s.number as number, sum(english+math+java+datestruct) as 'sum',avg(english+math+java+datestruct)/4 as 'avg' from student s,course c where s.number=c.number group by s.number ) sc
where ss.number = sc.number order by sc.sum desc