DROP TABLE age_ckh;
CREATE TABLE age_ckh
(
min_age NUMBER(3),
max_age NUMBER(3),
rule_id NUMBER(5),
bill_id NUMBER(5),
status_code VARCHAR2(10)
);
INSERT INTO age_ckh
(
SELECT 17, 33 ,1, 18,'COU' FROM dual
UNION ALL
SELECT 34, 43 ,1, 19,'COU' FROM dual
UNION ALL
SELECT 44, 53 ,1, 20,'COU' FROM dual
UNION ALL
SELECT 54, 58 ,1, 21,'COU' FROM dual
UNION ALL
SELECT 59, 64 ,1, 22,'COU' FROM dual
UNION ALL
SELECT 52, 55 ,1, 23,'COU' FROM dual--Wrong
UNION ALL
SELECT 50, 52 ,1, 24,'FAM' FROM dual--Wrong
UNION ALL
SELECT 17, 33 ,1, 25,'FAM' FROM dual
UNION ALL
SELECT 34, 43 ,1, 26,'FAM' FROM dual
UNION ALL
SELECT 44, 53 ,1, 27,'FAM' FROM dual
UNION ALL
SELECT 54, 58 ,1, 28,'FAM' FROM dual
UNION ALL
SELECT 59, 64 ,1, 29,'FAM' FROM dual
UNION ALL
SELECT 62, 64 ,1, 29,'FAM' FROM dual--WRONG
UNION ALL
SELECT 17, 33 ,1, 30,'SIN' FROM dual
UNION ALL
SELECT 34, 43 ,1, 31,'SIN' FROM dual
UNION ALL
SELECT 44, 53 ,1, 32,'SIN' FROM dual
UNION ALL
SELECT 54, 58 ,1, 33,'SIN' FROM dual
UNION ALL
SELECT 59, 64 ,1, 34,'SIN' FROM dual
UNION ALL
SELECT 17, 33 ,1, 35,'COU' FROM dual
UNION ALL
SELECT 34, 43 ,1, 36,'COU' FROM dual
UNION ALL
SELECT 44, 53 ,1, 37,'COU' FROM dual
UNION ALL
SELECT 54, 58 ,1, 38,'COU' FROM dual
UNION ALL
SELECT 59, 64 ,1, 39,'COU' FROM dual
UNION ALL
SELECT 60, 61 ,1, 40,'COU' FROM dual--WRONG
);
COMMIT;