SQL²éÁ½¸ö±í

SQL code:
----²âÊÔÊý¾Ý-----
if object_id('[t1]') is not null drop table [t1]
go
create table [t1]([ÐÕÃû] varchar(2),[µÃ·Ö] int,[ʱ¼ä] datetime)
insert [t1]
select 'ÕÅ',-1 ,'2010-2-4' union all
select 'Íõ',-1 ,'2010-2-6' union all
select 'Àî',-1 ,'2010-2-7' union all
select 'ÕÔ',-2 ,'2010-2-10'
if object_id('[t2]') is not null drop table [t2]
go
create table [t2]([ÐÕÃû2] varchar(2),[×ÓÀà] char(1),[ʱ¼ä] datetime)
insert [t2]
select 'ÕÅ','A','2010-2-14' union all
select 'Íõ','A','2010-2-16' union all
select 'Íõ','A','2010-2-17' union all
select 'ÕÔ','B','2010-2-20'
----²éѯ----
select ÐÕÃû,100+sum(µÃ·Ö)as SumSS from t1 where ʱ¼ä between '2010-2-1' and '2010-2-21' group by ÐÕÃû

----½á¹û-----
ÐÕÃû µÃ·ÖºÏ¼Æ
Àî 99
Íõ 99
ÕÅ 99
ÕÔ 98

ÎÒÏÖÔÚÏëÒÔ°´Ê±¼ä¶Î²éÁ½¸ö±í£¬¾ÍÊÇÔÙ¼õÈ¥±í2¶ÔÓ¦ÐÕÃûµÄ×ÓÀ࣬A¾Í¼õ6.6£¬B¾Í¼õÈ¥3.3,Èç¹ûûÓоͲ»¼õ¡£
ÎÒÏëÁгö£º

ÐÕÃû  µÃ·ÖºÏ¼Æ    ÅÅÃû
Àî    99          1
ÕÅ    92.4        2
Íõ    85.8        3
ÕÔ    94.7        4

---

SQL code:
----²âÊÔÊý¾Ý-----
if object_id('[t1]') is not null drop t