SELECT COALESCE(SUM(CASE WHEN gender_cd = 0 THEN 1 ELSE 0 END),0) MAN_CNT ,COALESCE(SUM(CASE WHEN gender_cd = 1 THEN 1 ELSE 0 END),0) WOMAN_CNT ,COALESCE(SUM(CASE WHEN COALESCE(gender_cd,3) not in (0,1) THEN 1 ELSE 0 END),0) WHO_CNT ,COALESCE(ROUND( (SUM(CASE WHEN gender_cd = 0 THEN 1 ELSE 0 END) / (COUNT(1)*1.0) * 100 ),0),0) MAN_CNT_PER ,COALESCE(ROUND( (SUM(CASE WHEN gender_cd = 1 THEN 1 ELSE 0 END) / (COUNT(1)*1.0) * 100 ),0),0) WOMAN_CNT_PER ,COALESCE(ROUND( (SUM(CASE WHEN COALESCE(gender_cd,3) not in (0,1) THEN 1 ELSE 0 END) / (COUNT(1)*1.0) * 100 ),0),0) WHO_CNT_PER ,COUNT(1) TOTAL_CNT FROM (select distinct member_id,GENDER_CD,ANSWER_TIMES from t_reply where enquete_id=/*enquete_id*/) T
