sql 分组统计有关问题

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

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