case when求和用SUM

SELECT
	CITY,
	COUNT( * ) ins,
	SUM( CASE WHEN OUT_TIME IS NOT NULL THEN 1 ELSE 0 END ) outs 
FROM
	MANAGEMENT_HEALTH_SUMMARY 
WHERE
	DELETED = 0 
	AND CITY IS NOT NULL 
GROUP BY
	CITY 
ORDER BY
	COUNT( * ) DESC

SELECT
	( SELECT d.DNAME FROM MANAGEMENT_DEPT d WHERE d.ID = m.MAIN_CONTRACTOR ) dName,
	COUNT( * ) numbers,
	SUM( CASE WHEN m.IN_OUT = 0 THEN 1 ELSE 0 END ) active 
FROM
	"MANAGEMENT_HEALTH_SUMMARY" m 
WHERE
	m.DELETED = 0 
	AND m.IN_OUT != 2 
GROUP BY
	m.MAIN_CONTRACTOR 
ORDER BY
	COUNT( * ) DESC