试题

SQL> create table eac_info ( cust_id varchar2(255),eac_id varchar2(255),opn_dt date,close_dt date);
SQL> create table trx_inf ( evt_id varchar2(255),cust_id varchar2(255),eact_id varchar2(255), trx_tm date,tex_amt number(10));
SQL> create table cust_uid_map ( cust_uid varchar2(255),cust_id varchar2(255));

insert into cust_uid_map values('PNCIF0000000001','0000000001');
insert into cust_uid_map values('PNCIF0000000001','0000000002');
insert into cust_uid_map values('PNCIF0000000001','0000000003');
insert into cust_uid_map values('PNCIF0000000002','0000000004');
insert into cust_uid_map values('PNCIF0000000003','0000000005');

insert into eac_inf values('0000000001','001',to_date('2023-02-20','YYYY-MM-DD'),to_date('9999-12-31','YYYY-MM-DD'));
insert into eac_inf values('0000000001','002',to_date('2023-02-22','YYYY-MM-DD'),to_date('2023-02-22','YYYY-MM-DD'));
insert into eac_inf values('0000000002','003',to_date('2023-02-24','YYYY-MM-DD'),to_date('2023-02-24','YYYY-MM-DD'));
insert into eac_inf values('0000000004','004',to_date('2023-02-21','YYYY-MM-DD'),to_date('2023-02-21','YYYY-MM-DD'));
insert into eac_inf values('0000000005','005',to_date('2023-02-21','YYYY-MM-DD'),to_date('2023-02-21','YYYY-MM-DD'));
insert into eac_inf values('0000000005','006',to_date('2023-02-23','YYYY-MM-DD'),to_date('2023-02-23','YYYY-MM-DD'));

insert into trx_inf values('S000P21','0000000001',to_date('2023-02-20 10:50:20','YYYY-MM-DD HH:MI:SS'),10000,'001');
insert into trx_inf values('S00W002','0000000001',to_date('2023-02-22 14:20:20','YYYY-MM-DD HH24:MI:SS'),50000,'002');
insert into trx_inf values('5000003','0000000002',to_date('2023-02-24 11:30:20','YYYY-MM-DD HH:MI:SS'),20000,'003');
insert into trx_inf values('S0X0004','0000000004',to_date('2023-02-21 13:30:20','YYYY-MM-DD HH24:MI:SS'),30000,'004');
insert into trx_inf values('S0T0005','0000000005',to_date('2023-02-21 18:30:20','YYYY-MM-DD HH24:MI:SS'),40000,'005');
insert into trx_inf values('S000B06','0000000005',to_date('2023-02-23 15:30:20','YYYY-MM-DD HH24:MI:SS'),20000,'006');
insert into trx_inf values('S0T0011','0000000005',to_date('2023-02-21 19:30:20','YYYY-MM-DD HH24:MI:SS'),15000,'005');