求一sql语句，按用户消费总金额排列

select ta.nane as 用户名,tb.总消费金额 from book as taleft join( select kind as 客户编号 , sum (xfje) as 总消费金额 from xfjl group by kind ) as tbon ta.id=tb.kindorder by tb.总消费金额 asc

文章标签：

来自：idkh