SELECT YW_SEQ, SUM (BILL), SUM (Louisa), SUM (Lynn), SUM (WAN), COM_NO from (SELECT COM_NO, YW_SEQ, DECODE (Person, '0001', (Agree)) AS Lynn, Decode (Person, '0011', (agree)) As Bill, Decode (Agree) AS WANG, DECODE (AGREE) AS Louisa from ywht_shenpi group by yw_seq, Person, Agree, COM_NO) Group by yw_seq, com_no
