条件选择case

SELECT COUNT(*),count(CASE b.AUTHORITY WHEN 'addAsmAccessControlList' THEN '1' ELSE NULL END) as auth FROM TM_SEAT_MAINTAIN_GROUP_AUTHORITY b
INNER JOIN TM_SEAT_MAINTAIN_TOOL_USER a ON a.USER_GROUP = b.USER_GROUP and a.MAINTAIN_TOOL_USER='tode' GROUP BY MAINTAIN_TOOL_USER