CREATE TABLE T117
(
    员工号 VARCHAR2(20),
    姓名  VARCHAR2(20)
);

INSERT INTO T117 VALUES('01', '张三');
INSERT INTO T117 VALUES('02', '李四');
INSERT INTO T117 VALUES('03', '王五');

CREATE TABLE T118
(
    员工号 VARCHAR2(20),
    扣款类型 NUMBER(4),
    扣款金额 NUMBER(4)
);
DELETE T118;
INSERT INTO T118 VALUES('01', 1, 10);
INSERT INTO T118 VALUES('01', 1, 20);
INSERT INTO T118 VALUES('01', 2, 30);
INSERT INTO T118 VALUES('01', 3, 40);
INSERT INTO T118 VALUES('02', 1, 50);
INSERT INTO T118 VALUES('02', 2, 60);
INSERT INTO T118 VALUES('02', 2, 70);