--创建测试环境
create table #
(
[名字] varchar(20),
[吃的李子個數] int,
[吃的布林的] int
)
insert #
select 'A',1,2 union
select 'A',2,2 union
select 'B',2,3 union
select 'B',1,1 union
select 'C',1,2
--测试
select [吃的李子個數]=A,[吃的布林的]=sum([B])
from
(
select [名字],
[A]=sum([吃的李子個數]),
[B]=sum([吃的布林的])
from # group by [名字]
)T group by A order by sum([B]) desc