StuIDstStuId有效课程数SelectCou
tScoreFromtblScorescI
erJoi
tblCoursecsO
scCourseIdcsCourseIdWhereCourseName数据库orCourseName企业管理orCourseName英语A
dscStuIDstStuId有效平均分SelectAvgScoreFromtblScorescI
erJoi
tblCoursecsO
scCourseIdcsCourseIdWhereCourseName数据库orCourseName企业管理orCourseName英语A
dscStuIDstStuIdFromtblStude
tstOrderby有效平均分Desc18、查询各科成绩最高和最低的分：以如下形式显示：课程ID，最高分，最低分SelectCourseIdas课程ID最高分SelectMaxScoreFromtblScorescWherescCourseIdcsCourseId最低分SelectMi
ScoreFromtblScorescWherescCourseIdcsCourseIdFromtblCoursecs19、按各科平均成绩从低到高和及格率的百分数从高到低顺序百分数后如何格式化为两位小数Select课程ID平均分及格率FromSelectCourseIdas课程ID平均分SelectAvgScoreFromtblScorescWherescCourseIdcsCourseId及格率Co
vertvarchar10SelectCou
tFromtblScorescWherescCourseIdcsCourseIdA
dscScore6010000SelectCou
tFromtblScorescWherescCourseIdcsCourseId100FromtblScorecsastmpGroupby课程ID平均分及格率Orderby平均分Co
vertfloatsubstri
g及格率1le
及格率1Desc
f20、查询如下课程平均成绩和及格率的百分数用