1개 row에 조건에 맞는 count 를 모두 출력
SELECT
COUNT(CASE WHEN A.MEM.STC.DV.C='00' THEN 1) AS "정상",
COUNT(CASE WHEN A.MEM.STC.DV.C='01' THEN 1) AS "탈회",
COUNT(CASE WHEN A.MEM.STC.DV.C='02' THEN 1) AS "휴먼"
FROM MEMBER A
WHERE A.JOIN_TS BETWEEN :inqrStDt AND :inqrEdDt
결과 : sample