最近在学习SQL嘛所以各个地方找题目来练手毕竟现在能离得开数据库么
Stude
tSS
ameSageSsex学生表CourseCC
ameT课程表SCSCscore成绩表TeacherTT
ame教师表问题：1、查询“001”课程比“002”课程成绩高的所有学生的学号；selectaSfromselectsscorefromSCwhereC001aselectsscorefromSCwhereC002bwhereascorebscorea
dasbs2、查询平均成绩大于60分的同学的学号和平均成绩；selectSavgscorefromscgroupbyShavi
gavgscore603、查询所有同学的学号、姓名、选课数、总成绩；selectStude
tSStude
tS
amecou
tSCCsumscorefromStude
tleftOuterjoi
SCo
Stude
tSSCSgroupbyStude
tSS
ame4、查询姓“李”的老师的个数；selectcou
tdisti
ctT
amefromTeacherwhereT
amelike李5、查询没学过“叶平”老师课的同学的学号、姓名；Stude
tSStude
tS
amefromStude
twhereS
oti
selectdisti
ctSCSfromSCCourseTeacherwhereSCCCourseCa
dTeacherTCourseTa
dTeacherT
ame叶平6、查询学过“001”并且也学过编号“002”课程的同学的学号、姓名；selectStude
tSStude
tS
amefromStude
tSCwhereStude
tSSCSa
dSCC001a
dexistsSelectfromSCasSC_2whereSC_2SSCSa
dSC_2C0027、查询学过“叶平”老师所教的所有课的同学的学号、姓名；selectSS
amefromStude
twhereSi
selectSfromSCCourseTeacherwhereSCCCourseCa
dTeacherTCourseTa
dTeacherT
ame叶平groupbyShavi
gcou
tSCCselectcou
tCfromCourseTeacherwhereTeacherTCourseTa
dT
ame叶平8、查询课程编号“002”的成绩比课程编号“001”课程低的所有同学的学号、姓名；SelectSS
amefromselectStude
tSStude
tS
amescoreselectscorefromSCSC_2whereSC_2SStude
tSa
dSC_2C002score2fromStude
tSCwhereStude
tSSCSa
dC001S_2wherescore2score9、查询所有课程成绩小于60分的同学的学号、姓名；
fselectSS
amefromStude
twhereS
oti
selectStude
tSfromStude
tSCwhereSSSCSa
dscore6010、查询没有学全所有课的同学的学号、姓名；selectStude
tSStude
tS
amefromStude
tSCwhereStude
tSSCSgroupbyStude
tSStude
tS
amehavi
gcou
tCselectcou
tCfromCourse11、查询至少有一门课与学号为“1001”的同学所学相同的同学的学号和姓名；selectSS
amefromStude
tSCwhereStude
tSSCSa
dCi
selectCfromSCwhereS100112、查询至少学过学号为“001”同学所有一门课的其他同学学号和姓名；selectdisti
ctSCSS
amefromStude
tSCwhereStude
tSSCSa
dCi
selectCfromSCwhereS00113、把“SC”表中“叶平”老师教的课的成绩都更改为此课程的平均成绩；ur