hereStuIdNotINr
SelectStuIdFromtblScorescWherestStuIdscStuIdA
dScore60r
r
10、查询没有学全所有课的同学的学号、姓名；r
SelectStuIdStuNameFromtblStude
tstr
WhereSelectCou
tFromtblScorescWherestStuIdscStuIdr
SelectCou
tFromtblCourser
r
11、查询至少有一门课与学号为“1001”的同学所学相同的同学的学号和姓名；r
运用连接查询r
SelectDistI
ctstStuIdStuNameFromtblStude
tstr
I
erJoi
tblScorescONstStuIdscStuIdr
WherescCourseIdINSelectCourseIdFromtblScoreWhereStuId1001r
嵌套子查询r
SelectStuIdStuNameFromtblStude
tr
WhereStuIdI
r
r
SelectDisti
ctStuIdFromtblScoreWhereCourseIdI
SelectCourseIdFromtblScoreWhereStuId1001r
r
r
12、查询至少学过学号为“1001”同学所有课程的其他同学学号和姓名；r
SelectStuIdStuNameFromtblStude
tr
WhereStuIdI
r
r
SelectDisti
ctStuIdFromtblScoreWhereCourseIdNotI
SelectCourseIdFromtblScoreWhereStuId1001r
r
13、把“SC”表中“叶平”老师教的课的成绩都更改为此课程的平均成绩；从子查询中获取父查询中的表名，这样也行？？？？r
创建测试表tr
SelectI
toScFromtblScorer
gor
r
UpdateScSetScoreSelectAvgScoreFromtblScores1Wheres1CourseIdscCourseIdr
WhereCourseIdINr
SelectCourseIdFromtblCoursecsINNERJOINtblTeachertcONcsTeaIDtcTeaIDWHERETeaName叶平r
r
14、查询和“1002”号的同学学习的课程完全相同的其他同学学号和姓名；tr
SelectStuIDStuNameFromtblStude
tstr
WhereStuId1002r
A
dr
NotExistsSelectFromtblScorescWherescStuIdstStuIdA
dCourseIdNotI
SelectCourseIdFromtblScoreWhereStuId1002tr
A
dr
NotExistsSelectFromtblScoreWhereStuId1002A
dCourseIdNotI
SelectCourseIdFromtblScorescWherescStuIdstStuIdr
r
15、删除学习“叶平”老师课的SC表记录；r
DeleteFromtblScoreWhereCourseIdINr
SelectCourseIdFromtblCoursecsINNERJOINtblTeachertcONcsTeaIdtcTeaIdWheretcTeaName叶平r
r
16、向SC表中插入一些记录，这些记录要求符合以下条件：没有上过编号“003”课程的同学学号、002号课的平均成绩；r
I
sertI
totblScoreStuIdCourseIdScorer
SelectStuId002SelectAvgScoreFromtblScoreWhereCourseId002FromtblScoreWherer
StuIdNotI
SelectStuIdFromtblScoreWhereCourseId003r
r
17、按平均成绩从高到低显示所有学生的“数据库”、“企业管理”、“英语”三门的课程成绩，按如下形式显示：学生ID数据库企业管理英语有效课程数有效平均分r
SelectStuIdr
数据库SelectScoreFromtblScorescI
erJoi
tblCoursecsO
scCourseIdcsCourseIdWhereCourseName数据库A
dscStuIDstStuIdr
r