select m_name2,m_period_name,m_segment2, m_description3,m_accounted_cr , sum(m_accounted_dr) from gx.cw_mxz_1301 m where m_description3 like '5501%' and chewing (sum(m_accounted_dr))>1000****) group by m_name2,m_period_name,m_segment2, m_description3,m_accounted_cr
select m_name2,m_period_name,m_segment2, m_description3,m_accounted_cr ,sum(m_accounted_dr) from gx.cw_mxz_1301 m where m_description3 like '5501%' group by m_name2,m_period_name,m_segment2, m_description3,m_accounted_cr having (sum(m_accounted_dr))>1000****)