一个题目涉及到的50个Sql语句（下面表的结构以给出自己在数据库中建立表并且添加相应的数据数据要全面些其中Stude
t表中SId为学生的ID）表结构学生表tblStude
t（编号StuId、姓名StuName、年龄StuAge、性别StuSex）课程表tblCourse课程编号CourseId、课程名称CourseName、教师编号TeaId）（成绩表tblScore（学生编号StuId、课程编号CourseId、成绩Score）教师表tblTeacher（教师编号TeaId、姓名TeaName）1、查询“001”课程比“002”课程成绩高的所有学生的学号；SelectStuIdFromtblStude
ts1WhereSelectScoreFromtblScoret1Wheret1StuIds1stuIdA
dt1CourseId001SelectScoreFromtblScoret2Wheret2StuIds1stuIdA
dt2CourseId0022、查询平均成绩大于60分的同学的学号和平均成绩；SelectStuIdAvgScoreasAvgScoreFromtblScoreGroupByStuIdHavi
gAvgScore603、查询所有同学的学号、姓名、选课数、总成绩；SelectStuIdStuNameSelCoursesSelectCou
tCourseIdFromtblScoret1Wheret1StuIds1StuIdSumScoreSelectSumScoreFromtblScoret2Wheret2StuIds1StuIdFromtblStude
ts14、查询姓“李”的老师的个数；SelectCou
tFromtblTeacherWhereTeaNamelike李5、查询没学过“叶平”老师课的同学的学号、姓名；SelectStuIdStuNameFromtblStude
tWhereStuIdNotI
SelectStuIDFromtblScorescI
erJoi
tblCoursecuONscCourseIdcuCourseIdI
erJoi
tblTeachertcONcuTeaIdtcTeaIdWheretcTeaName叶平
f6、查询学过“001”并且也学过编号“002”课程的同学的学号、姓名；SelectStuIdStuNameFromtblStude
tstWhereSelectCou
tFromtblScores1Wheres1StuIdstStuIdA
ds1CourseId0010A
dSelectCou
tFromtblScores2Wheres2StuIdstStuIdA
ds2CourseId00207、查询学过“叶平”老师所教的所有课的同学的学号、姓名；SelectStuIdStuNameFromtblStude
tstWhere
otexistsSelectCourseIDFromtblCoursecuI
erJoi
tblTeachertcO
cuTeaIDtcTeaIDWheretcTeaName叶平A
dCourseID
oti
SelectCourseIDFromtblScoreWhereStuIDstStuID8、查询课程编号“002”的成绩比课程编号“001”课程低的所有同学的学号、姓名；SelectStuIdStuNameFromtblStude
ts1WhereSelectScoreFromtblScoret1Wheret1StuIds1stuIdA
dt1CourseId001SelectScoreFromtblScoret2Wheret2StuIds1stuIdA
dt2CourseId0029、查询所有课程成绩小于60分的同学的学号、姓名；SelectStuIdStuNameFromtblStude
tstWhereStuIdNotINSelectStuIdFromtblScorescWherestStuIdscStuIdA
dScore6010、查询没有学全所有课的同学的学号、姓r