标题：一个项目涉及到的50个Sql语句整理版说明：以下五十个语句都按照测试数据进行过测试，最好每次只单独运行一个语句。问题及描述：1学生表Stude
tSS
ameSageSsexS学生编号S
ame学生姓名Sage出生年月Ssex学生性别2课程表CourseCC
ameTC课程编号C
ame课程名称T教师编号3教师表TeacherTT
ameT教师编号T
ame教师姓名4成绩表SCSCscoreS学生编号C课程编号score分数创建测试数据createtableStude
tSvarchar10S
ame
varchar10SagedatetimeSsex
varchar10i
serti
toStude
tvalues01N赵雷19900101N男i
serti
toStude
tvalues02N钱电19901221N男i
serti
toStude
tvalues03N孙风19900520N男i
serti
toStude
tvalues04N李云19900806N男i
serti
toStude
tvalues05N周梅19911201N女i
serti
toStude
tvalues06N吴兰19920301N女i
serti
toStude
tvalues07N郑竹19890701N女i
serti
toStude
tvalues08N王菊19900120N女createtableCourseCvarchar10C
ame
varchar10Tvarchar10i
serti
toCoursevalues01N语文02i
serti
toCoursevalues02N数学01i
serti
toCoursevalues03N英语03createtableTeacherTvarchar10T
ame
varchar10i
serti
toTeachervalues01N张三i
serti
toTeachervalues02N李四i
serti
toTeachervalues03N王五createtableSCSvarchar10Cvarchar10scoredecimal181i
serti
toSCvalues010180i
serti
toSCvalues010290i
serti
toSCvalues010399i
serti
toSCvalues020170i
serti
toSCvalues020260i
serti
toSCvalues020380i
serti
toSCvalues030180i
serti
toSCvalues030280i
serti
toSCvalues030380i
serti
toSCvalues040150i
serti
toSCvalues040230
fi
serti
toSCvalues040320i
serti
toSCvalues050176i
serti
toSCvalues050287i
serti
toSCvalues060131i
serti
toSCvalues060334i
serti
toSCvalues070289i
serti
toSCvalues070398go1、查询