SELECT A.SID AS 学号,A.NAME AS 姓名,B.CNO AS 课程号,B.COURSE AS 课程名称
FROM U_STUDENTS A ,U_COURSES B,U_SCORES C WHERE A.SID =C.STUDENT_ID AND B.CNO =C.COURSE_ID AND C.SCORE<60
select student.sno,sname,course.cname,sc.grade from student join sc on
student.sno=sc.sno join course on course.cno=sc.cno where grade<60
where条件后面加group by 选课.学号,姓名
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024