怎么用SQL语句统计并分列某一时段的金额和人数，请进来看一下

[RedSunIT]

表数据：
Fee Customers Time
2.1 1 2006-01-04 09:02:12
2.2 2 2006-01-04 09:03:12
2.3 3 2006-01-04 09:04:12
2.4 4 2006-01-04 10:02:12
2.5 5 2006-01-04 10:03:12
2.6 6 2006-01-04 10:04:12
2.7 7 2006-01-04 10:05:12
2.8 8 2006-01-04 11:02:12
2.9 9 2006-01-04 11:03:12

统计后的结果为：
AllFee AllCustomers Times
6.6 6 2006-01-04 09:00:00
10.2 22 2006-01-04 10:00:00
5.7 17 2006-01-04 11:00:00

请问SQL语句怎么写？ 谢谢先？

[huailairen]

select sum(Fee) , sum(Customers ),stuff(cast(time as varchar(20)),15,19,'00:00')
from 表
group by stuff(cast(time as varchar(20)),15,19,'00:00')

[冷箫轻笛]

select sum(Fee) as allfee,count(0) as allCustomers,hour
from
(select Fee,Customers,
convert(varchar(10),time,120) +' '+ cast(datepart(time,hh) as varchar)+ ':00:00' as hour
from table)t1
group by hour

[cwdhubin]

select sum(fee),sum(customer),datepart(hh,time) from
table
group by datepart(hh,time)

[RedSunIT]

呵呵，谢谢大家，还有没有？
To huailairen(流浪猫) ,coolingpipe(冷箫轻笛),cwdhubin(hubin) 都有分

[smalltalks]

select Fee=sum(Fee),Customers=sum(Customers),Time1=convert(varchar(13),[time],120)+':00:00'
from 表
group by
convert(varchar(13),[time],120)+':00:00'

[sxdoujg]

up