sql 分组统计问题

SQL code

SELECT COUNT( a.member_id ) AS sum, a.member_idFROM sdb_orders AS aLEFT JOIN sdb_members AS b ON ( a.member_id = b.member_id ) WHERE a.status <>  'dead'GROUP BY a.member_idHAVING COUNT( * ) >1

比如查询出来的结果
member_id sum
1 3
2 2

我要的结果是对COUNT( a.member_id )相加 结果就是5

[解决办法]

SQL code

SELECT sum( a.member_id ) AS total, a.member_idFROM sdb_orders AS aLEFT JOIN sdb_members AS b ON ( a.member_id = b.member_id ) WHERE a.status <>  'dead'GROUP BY a.member_idHAVING COUNT( * ) >1