select sid.姓名.部门,cid.课程名,id.sid.cid.成绩,from sid,cid,id,sid,cid
where sid cid id sid cid
select A.sid,A.姓名,A.部门,count(B.cid) from [学生表] A left join [成绩表] B on A.sid = B .sid group by A.sid,A.姓名,A.部门 having count(B.cid)>5
内容全部来源于网络收集，如有侵权，请联系网站删除！
QQ：24596024