if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([name] varchar(6),[team] varchar(20),[num1] int,[num2] int)
insert [tb]
select '陈婉仪','东华西分行连小莉组',4,1 union all
select '陈婉仪','建设分行叶剑敏组',9,0 union all
select '陈婉仪','淘金分行刘桂贤组',3,0 union all
select '邓海莲','海珠中分行潘柳组',5,4 union all
select '邓海莲','应元分行吴木坤组',3,2 union all
select '邓海莲','百灵路分行曾庆倍组',1,0 union all
select '何庆祥','滨江东分行唐湘组',2,1 union all
select '何庆祥','百灵路分行朱洁片组',7,0 union all
select '黄景元','中海名都分行陈银伍组',1,1 union all
select '黄景元','中海名都分行赵桃生组',3,3 union all
select '黄景元','海联分行杨健萍组',5,1 union all
select '黄景元','新港西分行范文学组',1,0 union all
select '黄景元','新港西分行黄景元组',4,0 union all
select '廖振刚','农林下路商铺何杰君组',1,0 union all
select '刘荣','公益路分行宋小清组',3,1 union all
select '刘荣','雍华廷分行辛金明组',8,1 union all
select '刘荣','金碧分行刘荣组',6,0 union all
select '吴苏彬','江南西分行吴苏彬组',2,0
