CREATE TABLE PROD_OWN_RANGE (
	CUSTOMER_ID INTEGER,
	PROD_ID		INTEGER,
	PRD_GRP_ID	CHAR(1),
	DATE_FROM	DATE,
	DATE_TO		DATE
);

insert into PROD_OWN_RANGE (CUSTOMER_ID, PROD_ID, PRD_GRP_ID, DATE_FROM, DATE_TO) VALUES (100,1,'A', TO_DATE('2019-09-15','yyyy-mm-dd'),TO_DATE('2019-10-02','yyyy-mm-dd'));
insert into PROD_OWN_RANGE (CUSTOMER_ID, PROD_ID, PRD_GRP_ID, DATE_FROM, DATE_TO) VALUES (100,3,'A', TO_DATE('2019-09-17','yyyy-mm-dd'),TO_DATE('2019-10-01','yyyy-mm-dd'));
insert into PROD_OWN_RANGE (CUSTOMER_ID, PROD_ID, PRD_GRP_ID, DATE_FROM, DATE_TO) VALUES (100,5,'A', TO_DATE('2019-09-16','yyyy-mm-dd'),TO_DATE('2019-09-30','yyyy-mm-dd'));
insert into PROD_OWN_RANGE (CUSTOMER_ID, PROD_ID, PRD_GRP_ID, DATE_FROM, DATE_TO) VALUES (100,2,'B', TO_DATE('2019-09-18','yyyy-mm-dd'),TO_DATE('2019-09-20','yyyy-mm-dd'));
insert into PROD_OWN_RANGE (CUSTOMER_ID, PROD_ID, PRD_GRP_ID, DATE_FROM, DATE_TO) VALUES (100,2,'B', TO_DATE('2019-09-19','yyyy-mm-dd'),TO_DATE('2019-09-30','yyyy-mm-dd'));
insert into PROD_OWN_RANGE (CUSTOMER_ID, PROD_ID, PRD_GRP_ID, DATE_FROM, DATE_TO) VALUES (100,4,'B', TO_DATE('2019-09-25','yyyy-mm-dd'),TO_DATE('2019-10-03','yyyy-mm-dd'));

select * from PROD_OWN_RANGE;