头歌实践教学平台!!!数据结构！！！数据库原理！！！树莓专业入

头哥sjjxpt，源代码

 复杂查询

第1关 查询学生平均分

########## 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,a.s_name,0 as avg_score from student a

where a.s_id not in (select distinct s_id from score);

########## End ##########

第2关 查询修课相同学生信息

########## Begin ##########

create view temp as(select s_id,group_conca