查询班级表、课程表、学生选课表、学生表、成绩表、15（3+2）计算班的期中成绩（qzcj）

use [Xk-kk]
go
select *
from achievement
go

use [Xk-kk]
go
select *
from Class join Student
on class.ClassNo=Student.ClassNo
join StuCou
on Student.StuNo=stucou.StuNo
join Course
on StuCou.CouNo=Course.CouNo
join achievement
on StuCou.StuNo=achievement.StuNO
where class.ClassName='15计算机(3+2)'
go