SELECT ct.playeruuid, p1.playername, p1.playerbalance, sum(ct.cointransactionamount) as poAmount   from cointransactionarchive ct, player p1  where p1.playeruuid=ct.playeruuid  group by p1.playeruuid order by poAmount desc