第1关 统计总成绩
#请在此添加实现代码
########## Begin ##########
select t1.classname,t1.chinese,t2.maths
from(select c.classname classname,sum(s.chinese)chinese from tb_class c,tb_score s
where c.stuname=s.name and s.chinese>=60 group by classname)t1,
(select c.classname classname, sum(s.maths)maths from tb_class c,tb_score s
where c.stuname=s.name and s.maths>=60 group by c.classname)t2
where t1.classname=t2.classname;
########## End ##########
第2关 查询学生平均分
#请在此添加实现代码
########## Begin ##########
select b.s_id,b.s_name,ROUND(AVG(a.s_score),2)as avg_score from student b
inner join score a on b.s_id=a.s_id
group by b.s_id, b.s_name having avg_score<60
union
select a.s_id,