아래와 같이 적용해 보시면 될듯 싶네요.
수고하세요!!

CREATE TABLE TESTA (
 NUM  CHAR(4),
 NAME VARCHAR(10),
 CHK  CHAR(1),
 TOT  INT
);

INSERT INTO TESTA VALuES ('1111', 'KJS', '1', 1000);
INSERT INTO TESTA VALuES ('2222', 'LIM', '1', 800);
INSERT INTO TESTA VALuES ('1111', 'KJS', '2', 1000);
INSERT INTO TESTA VALuES ('1111', 'KJS', '1', 5000);
INSERT INTO TESTA VALuES ('3333', 'TIU', '1', 400);
INSERT INTO TESTA VALuES ('1111', 'KJS', '1', 1000);

SELECT A.NUM, A.NAME, (A.CNT - NVL(B.CNT, 0)) CNT, (A.TOT - NVL(B.TOT, 0)) TOT
FROM (
 SELECT NUM, NAME, COUNT(*) CNT, SUM(TOT) TOT
 FROM TESTA
 WHERE CHK = '1'
 GROUP BY NUM, NAME
) A LEFT OUTER JOIN (
 SELECT NUM, NAME, COUNT(*) CNT, SUM(TOT) TOT
 FROM TESTA
 WHERE CHK = '2'
 GROUP BY NUM, NAME
) B
ON A.NUM = B.NUM
ORDER BY A.NUM