DECLARE @t_class TABLE (id  INT, name VARCHAR(100),parent_id INT )
INSERT INTO @t_class
SELECT 1,'高中部',0 UNION ALL 
SELECT 2,'高一年级',1 UNION ALL 
SELECT 3,'高二年级',1 UNION ALL 
SELECT 4,'高二一班',3 UNION ALL 
SELECT 5,'高二二班',3 UNION ALL
SELECT 6,'高一二班',2 UNION ALL 
SELECT 7,'高一一班',2  
DECLARE @t_grade TABLE (id INT ,student_id INT ,class_id INT ,course_id INT ,grade INT )
INSERT INTO @t_grade
SELECT 1,001,4,001,60 UNION ALL
SELECT 2,002,5,001,30 UNION ALL
SELECT 3,003,4,001,80 UNION ALL
SELECT 4,004,5,001,90 UNION ALL
SELECT 4,004,6,001,90 UNION ALL
SELECT 4,004,7,001,90 

SELECT c3.name,c2.name,c1.name,ga.course_id,ga.grade  from 
(select c.id,g.course_id ,sum(g.grade) as grade  
from  @t_grade g join @t_class c on g.class_id = c.id
group  by c.id,course_id) as ga
join @t_class c1 on ga.id = c1.id
join @t_class c2 on c2.id = c1.parent_id 
join @t_class c3 on c3.id = c2.parent_id  

SELECT c3.name,c2.name,'' AS name,ga.course_id,ga.grade  from 
(select c2.id,g.course_id ,sum(g.grade) as grade  
from  @t_grade g join @t_class c on g.class_id = c.id join @t_class c2 on c2.id = c.parent_id 
group  by c2.id,g.course_id) as ga
join @t_class c2 on c2.id = ga.id
join @t_class c3 on c3.id = c2.parent_id

SELECT c3.name,'' AS name  ,'' AS name,ga.course_id,ga.grade  from 
(select c3.id,g.course_id ,sum(g.grade) as grade  
from  @t_grade g join @t_class c on g.class_id = c.id 
join @t_class c2 on c2.id = c.parent_id join @t_class c3 on c3.id = c2.parent_id
group  by c3.id,g.course_id) as ga
join @t_class c3 on c3.id = ga.id