select a.StudentID,b.StudentName,a.Score
(select StudentID,sum(Score) Score
from 成绩表
group by StudentID)a,StudentInfo b
where a.StudentID = b.StudentID(+)
(select StudentID,sum(Score) Score
from 成绩表
group by StudentID)a,StudentInfo b
where a.StudentID = b.StudentID(+)
from 成绩表
group by StudentID,StudentName
/
,max(( select StudentName from StudentInfo where StudentInfo.StudentID = CourseInfo.StudentID )) as StudentName
,sum(score)
from CourseInfo
group by StudentID
/
from studentinfo group by studentID
/