select A.name,A.sum,B.zong from (select name, sum(xiaoshou) as sum from shujv group by name) Ainner join (select name,zong from shujv order by month desc Limit 1) Bon A.name=B.name
