名；SelectStuIdStuNameFromtblStude
tstWhereSelectCou
tFromtblScorescWherestStuIdscStuIdSelectCou
tFromtblCourse11、查询至少有一门课与学号为“1001”的同学所学相同的同学的学号和姓名；运用连接查询SelectDistI
ctstStuIdStuNameFromtblStude
tstI
erJoi
tblScorescONstStuIdscStuIdWherescCourseIdINSelectCourseIdFromtblScoreWhereStuId1001嵌套子查询SelectStuIdStuNameFromtblStude
t
fWhereStuIdI
SelectDisti
ctStuIdFromtblScoreWhereCourseIdI
SelectCourseIdFromtblScoreWhereStuId100112、查询至少学过学号为“1001”同学所有课程的其他同学学号和姓名；SelectStuIdStuNameFromtblStude
tWhereStuIdI
SelectDisti
ctStuIdFromtblScoreWhereCourseIdNotI
SelectCourseIdFromtblScoreWhereStuId100113、把“SC”表中“叶平”老师教的课的成绩都更改为此课程的平均成绩；从子查询中获取父查询中的表名，这样也行？？？？创建测试表SelectI
toScFromtblScoregoUpdateScSetScoreSelectAvgScoreFromtblScores1Wheres1CourseIdscCourseIdWhereCourseIdINSelectCourseIdFromtblCoursecsINNERJOINtblTeachertcONcsTeaIDtcTeaIDWHERETeaName叶平14、查询和“1002”号的同学学习的课程完全相同的其他同学学号和姓名；SelectStuIDStuNameFromtblStude
tstWhereStuId1002A
dNotExistsSelectFromtblScorescWherescStuIdstStuIdA
dCourseIdNotI
SelectCourseIdFromtblScoreWhereStuId1002A
dNotExistsSelectFromtblScoreWhereStuId1002A
dCourseIdNotI
SelectCourseIdFromtblScorescWherescStuIdstStuId15、删除学习“叶平”老师课的SC表记录；DeleteFromtblScoreWhereCourseIdINSelectCourseIdFromtblCoursecsINNERJOINtblTeachertcONcsTeaIdtcTeaIdWheretcTeaName叶平16、SC表中插入一些记录，向这些记录要求符合以下条件：没有上过编号“003”课程的同学学号、002号课的平均成绩；I
sertI
totblScoreStuIdCourseIdScore
fSelectStuId002SelectAvgScoreFromtblScoreWhereCourseId002FromtblScoreWhereStuIdNotI
SelectStuIdFromtblScoreWhereCourseId00317、按平均成绩从高到低显示所有学生的“数据库”、“企业管理”、“英语”三门的课程成绩，按如下形式显示：学生ID数据库企业管理英语有效课程数有效平均分SelectStuId数据库SelectScoreFromtblScorescI
erJoi
tblCoursecsO
scCourseIdcsCourseIdWhereCourseName数据库A
dscStuIDstStuId企业管理SelectScoreFromtblScorescI
erJoi
tblCoursecsO
scCourseIdcsCourseIdWhereCourseName企业管理A
dscStuIDstStuId英语SelectScoreFromtblScorescI
erJoi
tblCoursecsO
scCourseIdcsCourseIdWhereCourseName英语A
dscr