10、查询各科成绩最高和最低的分：以如下形式显示：课程ID，最高分，最低分

SELECt L.C# 课程ID,L.score 最高分,R.score 最低分
FROM SC L ,SC R
WHERe L.C# = R.C#
and
L.score = (SELECt MAX(IL.score)
FROM SC IL,Student IM
WHERe IL.C# = L.C# and IM.S#=IL.S#
GROUP BY IL.C#)
and
R.Score = (SELECt MIN(IR.score)
FROM SC IR
WHERe IR.C# = R.C#
GROUP BY IR.C# );