앱)특정 컬럼에 따라 Count하는 쿼리 mybatis dao

<select id="xxx" parmeterType="map" resultType="hashmap">
SELECT
CAST(COUNT(CASE WHEN ABC.YN ='N' THEN 1 END) AS CHAR)AS N_CNT
,CAST(COUNT(CASE WHEN ABC.YN='Y' THEN 1 END) AS CHAR) AS Y_CNT
FROM ABC AS ABC;
</select>


public HashMap<String, String> getCount(){
Map<String, String> paramMap = new HashMap<String, String>();
paramMap.put("key","value");
      return sqlSessionTemplate.selectOne("xxx", paramMap);
}