create table sarah_tab_1 ( ID Varchar(255), type varchar(255), Dt date) insert into sarah_tab_1 values ( '0518814', 'CRA', '01-JAN-18'); insert into sarah_tab_1 values ( '0922560', 'CRA', '01-JAN-18'); insert into sarah_tab_1 values ( '0057847', 'CRA', '29-NOV-17'); insert into sarah_tab_1 values ( '0050248', 'CRA', '15-DEC-17'); insert into sarah_tab_1 values ( '0498781', 'CRA', '29-NOV-17'); create table sarah_tab_3 ( ID Varchar(255), type varchar(255)) insert into sarah_tab_3 values ( '0498781', 'PRE'); insert into sarah_tab_3 values ( '0922560', 'PRE'); insert into sarah_tab_3 values ( '0057847', 'PRE'); insert into sarah_tab_3 values ( '0050248', 'PRE'); insert into sarah_tab_3 values ( '0518814', 'PRE'); create table sarah_tab_4 ( ID Varchar(255), type varchar(255) ) insert into sarah_tab_4 values ( '0498781', 'PRE'); insert into sarah_tab_4 values ( '0922560', 'PRE'); insert into sarah_tab_4 values ( '0057847', 'PRE'); insert into sarah_tab_4 values ( '0050248', 'PRE'); insert into sarah_tab_4 values ( '0498781', 'PRE'); create table sarah_tab_5 ( ID Varchar(255), dt varchar(255)) insert into sarah_tab_5 values ( '0518814', '01-NOV-17'); insert into sarah_tab_5 values ( '0518814', '01-DEC-17'); insert into sarah_tab_5 values ( '0518814', '02-JAN-18'); insert into sarah_tab_5 values ( '0518814', '01-FEB-18'); insert into sarah_tab_5 values ( '0518814', '01-MAR-18'); insert into sarah_tab_5 values ( '0518814', '17-MAR-18'); insert into sarah_tab_5 values ( '0922560', '01-NOV-17'); insert into sarah_tab_5 values ( '0922560', '01-DEC-17'); insert into sarah_tab_5 values ( '0922560', '31-DEC-17'); insert into sarah_tab_5 values ( '0922560', '17-MAR-18'); insert into sarah_tab_5 values ( '0922560', '21-MAR-18'); insert into sarah_tab_5 values ( '0057847', '20-MAR-18'); insert into sarah_tab_5 values ( '0050248', '01-dec-17'); insert into sarah_tab_5 values ( '0498781', '01-JUn-18');