这种表设计怎么统计用户消费排名

[logoso]

Access表设计：

id
xiaofei 单次消费金额 （可多次消费）
userid 用户id
addtime 消费时间


如何在这张表中列出用户的消费总额排名 从高到低

[lzp4881]

select userid,sum(xiaofei) as xfze from tableName group by userid order by sum(xiaofei) desc

[junshanhudazhaxi]

create table tb_1(
    id int,
    xiaofei money,
    userid int,
    addtime datetime
)

insert into tb_1 values(1, 80, 1, getdate())
insert into tb_1 values(2, 100, 2, getdate())
insert into tb_1 values(3, 180, 3, getdate())
insert into tb_1 values(4, 110, 1, getdate())

select * from tb_1

select userid, sum(xiaofei) as '消费总金额' from tb_1 group by userid order by sum(xiaofei) desc