<select id="getCountByDISC" resultType="com.rm.algo.entity.AlgoResult">

SELECT

sum( case when t2.type='D' and content='0' then 1 else 0 end) as unlikeD,

sum( case when t2.type='I' and content='0' then 1 else 0 end) as unlikeI,

sum( case when t2.type='S' and content='0' then 1 else 0 end) as unlikeS,

sum( case when t2.type='C' and content='0' then 1 else 0 end) as unlikeC,

sum( case when t2.type='D' and content='1' then 1 else 0 end) as likenessD,

sum( case when t2.type='I' and content='1' then 1 else 0 end) as likenessI,

sum( case when t2.type='S' and content='1' then 1 else 0 end) as likenessS,

sum( case when t2.type='C' and content='1' then 1 else 0 end) as likenessC

FROM cust_record_data  t1 left  JOIN cust_qn_option t2  ON  t1.option_id=t2.id  WHERE

t1.validate_flag="Y" AND t2.validate_flag="Y" AND t1.qn_id=#{param1} AND t1.`status`=1

    </select>