请教复杂sql语句
a dj sl je

101-1
101-1-1 1 1 0
101-1-2 2 1 0
101-1-1 1 1 0

102-1
102-1-1 3 1 0
102-1-2 4 1 0
102-1-3 5 1 0
.......

要结果如下
a sl je

101-1
101-1-1 2 2
101-1-2 1 2

102-1
102-1-1 1 3
102-1-2 1 4
102-1-3 1 5
.......

要求也就是：（1）把 101-1和102-1 的子的汇总
（2）把重复的 sl 加和 je 加和
这样子能写吗?非常感谢

[解决办法]

if object_id( 'pubs..tb ') is not null
drop table tb
go

create table tb
(
a varchar(20),
dj int,
sl int,
je int
)

insert into tb(a,dj,sl,je) values( '101-1 ', null,null,null)
insert into tb(a,dj,sl,je) values( '101-1-1 ',1, 1, 0)
insert into tb(a,dj,sl,je) values( '101-1-2 ',2, 1, 0)
insert into tb(a,dj,sl,je) values( '101-1-1 ',1, 1, 0)
insert into tb(a,dj,sl,je) values( '102-1 ', null,null,null)
insert into tb(a,dj,sl,je) values( '102-1-1 ',3, 1, 0)
insert into tb(a,dj,sl,je) values( '102-1-2 ',4, 1, 0)
insert into tb(a,dj,sl,je) values( '102-1-3 ',5, 1, 0)

select a,max(sl) as sl , max(je) as je from
(
select left(a,5) as a , sum(sl) as sl , sum(dj) as je from tb group by left(a,5)
union all
select left(a,7) as a , sum(sl) as sl , sum(dj) as je from tb group by left(a,7)
) t
group by a

drop table tb

/*
a sl je
-------------- ----------- -----------
101-1 3 4
101-1-1 2 2
101-1-2 1 2
102-1 3 12
102-1-1 1 3
102-1-2 1 4
102-1-3 1 5

（所影响的行数为 7 行）
*/