-- create tables create table ch05_departments ( id number generated by default on null as identity constraint ch05_department_id_pk primary key, dept_name varchar2(100 char) ) ; create table ch05_projects( id number generated by default on null as identity constraint ch05_project_id_pk primary key, proj_name varchar2(100 char), budget number, begin_date date, end_date date ) ; create table ch05_employees ( id number generated by default on null as identity constraint ch05_employee_id_pk primary key, first_name varchar2(20 char), last_name varchar2(20 char), father_name varchar2(20 char), birth_date date, hire_date date, id_card varchar2(10 char), address varchar2(100 char), city varchar2(20 char), vat_no varchar2(10 char), telephone varchar2(20 char), mobile varchar2(20 char), salary number, dept number constraint ch05_employee_dept_fk references ch05_departments on delete cascade, manager number constraint ch05_employee_manager_fk references ch05_employees on delete cascade ) ; -- table index create index ch05_employee_i1 on ch05_employees (dept); create index ch05_employee_i62 on ch05_employees (manager); create table ch05_emp_proj ( id number generated by default on null as identity constraint ch05_emp_proj_id_pk primary key, emp number constraint ch05_emp_proj_emp_fk references ch05_employees on delete cascade, proj number constraint ch05_emp_proj_proj_fk references ch05_projects on delete cascade, start_date date, end_date date, earnings number ) ; -- table index create index ch05_emp_proj_i1 on ch05_emp_proj (emp); create index ch05_emp_proj_i112 on ch05_emp_proj (proj); -- load data insert into ch05_departments ( id, dept_name ) values ( 1, 'Customer Relationship' ); insert into ch05_departments ( id, dept_name ) values ( 2, 'Purchasing' ); insert into ch05_departments ( id, dept_name ) values ( 3, 'Governance and Acountability' ); insert into ch05_departments ( id, dept_name ) values ( 4, 'Finance' ); insert into ch05_departments ( id, dept_name ) values ( 5, 'Systems Support' ); commit; alter table ch05_departments modify id generated always as identity restart start with 6; -- load data -- load data insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 1, 'Micro Processor Upgrade', 3, sysdate - 39, sysdate - 37 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 2, 'NetSuite Module Rollout', 98, sysdate - 61, sysdate - 59 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 3, 'P12W1 Regress', 22, sysdate - 29, sysdate - 83 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 4, 'Bedford Office Upgrade', 71, sysdate - 37, sysdate - 19 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 5, 'Overseas Migration', 49, sysdate - 92, sysdate - 38 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 6, 'System Breach Analysis', 79, sysdate - 66, sysdate - 37 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 7, 'Reactive System Upgrade', 96, sysdate - 96, sysdate - 66 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 8, 'Personal Management Application', 48, sysdate - 83, sysdate - 50 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 9, 'Corporate Portal', 19, sysdate - 30, sysdate - 46 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 10, 'Manufacturing Computing Environment', 65, sysdate - 84, sysdate - 28 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 11, 'Deadlock Detection Review', 67, sysdate - 40, sysdate - 25 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 12, 'Managed Finance Upgrade', 8, sysdate - 29, sysdate - 82 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 13, 'Facilities Review', 59, sysdate - 26, sysdate - 53 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 14, 'Aerodynamics Virtual Wind Tunnel', 37, sysdate - 50, sysdate - 56 ); insert into ch05_projects ( id, proj_name, budget, begin_date, end_date ) values ( 15, 'Physical Management', 9, sysdate - 40, sysdate - 80 ); commit; alter table ch05_projects modify id generated always as identity restart start with 16; -- load data insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 1, 'Gricelda', 'Luebbers', 'Gricelda Luebbers', sysdate - 85, sysdate - 54, 'Malesuada', '233 Vaqueria Street', 'Tanquecitos', 'Orci', 'Amet', 'Ullamcorperinterdum', 84, 1, 1 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 2, 'Dean', 'Bollich', 'Dean Bollich', sysdate - 16, sysdate - 68, 'Elit', '649 Gonez Ave', 'Sugarloaf', 'Sit', 'Aliquam', 'Suscipit', 11, 3, 2 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 3, 'Milo', 'Manoni', 'Milo Manoni', sysdate - 46, sysdate - 19, 'Lorem', '182 Luxora Blvd', 'Dale City', 'Eu', 'Curae;', 'Lacinia', 26, 3, 1 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 4, 'Laurice', 'Karl', 'Laurice Karl', sysdate - 12, sysdate - 6, 'Amet', '320 Lynnfield Street', 'Grosvenor', 'Ligula', 'Sollicitudin', 'Fames', 1, 2, 4 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 5, 'August', 'Rupel', 'August Rupel', sysdate - 12, sysdate - 61, 'Amet', '696 Phelps Ave', 'Riverside', 'Quis', 'Vestibulum', 'Sapien', 64, 2, 3 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 6, 'Salome', 'Guisti', 'Salome Guisti', sysdate - 31, sysdate - 79, 'Elementum', '697 Cedar Park Ave', 'Ridgeley', 'Proin', 'Ut', 'Viverra', 27, 1, 5 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 7, 'Lovie', 'Ritacco', 'Lovie Ritacco', sysdate - 17, sysdate - 52, 'Dictum', '637 Lake Norman of Catawba Ave', 'Ashley Heights', 'Ipsum', 'Mattis', 'Pellentesque', 20, 3, 3 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 8, 'Chaya', 'Greczkowski', 'Chaya Greczkowski', sysdate - 1, sysdate - 76, 'Et', '583 Tanquecitos Street', 'Monfort Heights', 'Proin', 'Nonmolestie', 'Sit', 83, 1, 4 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 9, 'Twila', 'Coolbeth', 'Twila Coolbeth', sysdate - 87, sysdate - 68, 'Diam', '160 Hambleton Blvd', 'Point Marion', 'Eu', 'Curae;', 'Id', 14, 5, 1 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 10, 'Carlotta', 'Achenbach', 'Carlotta Achenbach', sysdate - 59, sysdate - 33, 'Ac', '456 Yardville Street', 'Eldon', 'Sit', 'Consectetur', 'Placerat', 42, 2, 10 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 11, 'Jeraldine', 'Audet', 'Jeraldine Audet', sysdate - 56, sysdate - 82, 'Suscipit', '626 Colome Ave', 'Greendale', 'Amet', 'Sollicitudin', 'Massa', 57, 4, 2 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 12, 'August', 'Arouri', 'August Arouri', sysdate - 74, sysdate - 28, 'Sapien', '308 Point Marion Street', 'Ammon', 'Amet', 'Arcu', 'Cursus', 57, 4, 12 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 13, 'Ward', 'Stepney', 'Ward Stepney', sysdate - 32, sysdate - 87, 'Proin', '78 Ixtapaluca Blvd', 'Wallsburg', 'Ac', 'Ut', 'Amet', 98, 4, 2 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 14, 'Ayana', 'Barkhurst', 'Ayana Barkhurst', sysdate - 75, sysdate - 72, 'Nec', '305 Consort Street', 'De Pue', 'Ligula', 'Nec', 'Ut', 93, 2, 5 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 15, 'Luana', 'Berends', 'Luana Berends', sysdate - 49, sysdate - 43, 'Quis', '121 Cebrecos Blvd', 'Prompton', 'Sit', 'Mi', 'Pellentesque', 26, 5, 3 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 16, 'Lecia', 'Alvino', 'Lecia Alvino', sysdate - 66, sysdate - 96, 'Tincidunt', '16 Cunningham Blvd', 'New Rockford', 'Amet', 'Ex', 'Mi', 74, 3, 14 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 17, 'Joleen', 'Himmelmann', 'Joleen Himmelmann', sysdate - 92, sysdate - 20, 'Posuere', '357 Guijo Street', 'Tygh Valley', 'Imperdiet', 'Ante', 'Ligula', 63, 3, 8 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 18, 'Monty', 'Kinnamon', 'Monty Kinnamon', sysdate - 29, sysdate - 80, 'Nec', '904 Mugares Place', 'Lookout', 'Rhoncuscra', 'Vulputate', 'Vestibulum', 5, 5, 6 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 19, 'Dania', 'Grizzard', 'Dania Grizzard', sysdate - 95, sysdate - 9, 'Diam', '704 Durango Ave', 'Hermiston', 'Quis', 'Convallis', 'Nulla', 4, 1, 2 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 20, 'Inez', 'Yamnitz', 'Inez Yamnitz', sysdate - 2, sysdate - 51, 'Nec', '136 La Laguna Blvd', 'Mendota Heights', 'Vitae', 'Sollicitudin', 'Et', 80, 1, 11 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 21, 'Fidel', 'Creps', 'Fidel Creps', sysdate - 8, sysdate - 70, 'Proin', '946 Shongopovi Place', 'Kernersville', 'Id', 'Venenatis', 'Ac', 17, 4, 5 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 22, 'Luis', 'Pothoven', 'Luis Pothoven', sysdate - 96, sysdate - 28, 'Ac', '589 Minaya Street', 'North Canton', 'Amet', 'Quis', 'Ligula', 56, 4, 11 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 23, 'Bernardo', 'Phoenix', 'Bernardo Phoenix', sysdate - 73, sysdate - 16, 'Placerat', '498 Hermiston Street', 'El Ojo', 'Mattis', 'Pellentesque', 'Et', 86, 1, 7 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 24, 'Carolyne', 'Centore', 'Carolyne Centore', sysdate - 90, sysdate - 77, 'Vestibulum', '183 Cedar Park Blvd', 'Sherrodsville', 'Volutpat', 'Ac', 'Convallis', 83, 2, 19 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 25, 'Cornell', 'Pratico', 'Cornell Pratico', sysdate - 51, sysdate - 61, 'Ipsumprimi', '925 Lake Norman of Catawba Place', 'Fort Bridger', 'Id', 'Orci', 'Ligula', 27, 1, 9 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 26, 'Sam', 'Rueb', 'Sam Rueb', sysdate - 31, sysdate - 34, 'Ligula', '677 Morse Ave', 'Rural Retreat', 'Nonmolesti', 'Luctus', 'Sit', 35, 5, 19 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 27, 'Shakita', 'Sablock', 'Shakita Sablock', sysdate - 26, sysdate - 17, 'Ac', '811 Conkling Park Place', 'Girard', 'In', 'Convallis', 'Faucibus', 7, 4, 8 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 28, 'Sandy', 'Heffren', 'Sandy Heffren', sysdate - 5, sysdate - 24, 'Sit', '414 Luxora Street', 'South Greeley', 'Amet', 'Ligula', 'Risus', 38, 5, 5 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 29, 'Tressa', 'Coppens', 'Tressa Coppens', sysdate - 4, sysdate - 86, 'Cubilia', '402 Cochrane Street', 'Marrmot Point', 'Risusphase', 'Vestibulum', 'Sit', 74, 5, 17 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 30, 'Shira', 'Arocho', 'Shira Arocho', sysdate - 23, sysdate - 27, 'Nulla', '142 Bruni Blvd', 'Pointe a la Hache', 'Pellentesq', 'Lorem', 'Suscipit', 93, 4, 20 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 31, 'Carter', 'Sacarello', 'Carter Sacarello', sysdate - 33, sysdate - 68, 'Ut', '136 Mascaras Blvd', 'Inver Grove Heights', 'Ultrices', 'Ligula', 'In', 61, 3, 1 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 32, 'Linda', 'Merida', 'Linda Merida', sysdate - 76, sysdate - 62, 'Eu', '201 La Laguna Street', 'Cochrane', 'Commodo', 'Fames', 'Elementum', 17, 3, 13 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 33, 'Winfred', 'Sohn', 'Winfred Sohn', sysdate - 81, sysdate - 48, 'Pharetra', '124 Mendota Heights Blvd', 'Gainesville', 'Ante', 'Vestibulum', 'Ex', 92, 5, 30 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 34, 'Nestor', 'Caparros', 'Nestor Caparros', sysdate - 54, sysdate - 32, 'Vitae', '931 Bargas Place', 'Lake Norman of Cataw', 'Pellentesq', 'Id', 'Eu', 43, 4, 26 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 35, 'Brooks', 'Craker', 'Brooks Craker', sysdate - 94, sysdate - 54, 'Curae;', '313 Soursac Street', 'Natchez', 'Ligula', 'Mi', 'Ultrices', 48, 5, 15 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 36, 'Ruthann', 'Nixa', 'Ruthann Nixa', sysdate - 17, sysdate - 76, 'Id', '917 Anieves Place', 'Hilshire Village', 'Etiam', 'Sodales', 'Sit', 74, 5, 23 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 37, 'Kenny', 'Campobasso', 'Kenny Campobasso', sysdate - 19, sysdate - 32, 'Mi', '23 Cebrecos Blvd', 'Nickerson', 'Venenatis', 'Vestibulum', 'Aliquam', 44, 1, 17 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 38, 'Hildred', 'Donnel', 'Hildred Donnel', sysdate - 53, sysdate - 90, 'Proin', '824 Erquery Place', 'Woodruff', 'Eget', 'Posuere', 'Commodo', 48, 5, 30 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 39, 'Luther', 'Ardinger', 'Luther Ardinger', sysdate - 63, sysdate - 15, 'Rhoncuscra', '485 Doraville Street', 'Lynnfield', 'Consectetu', 'Pellentesque', 'Massa', 25, 3, 6 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 40, 'Rhoda', 'Hasfjord', 'Rhoda Hasfjord', sysdate - 70, sysdate - 6, 'Lacinialec', '904 Matola Place', 'Homeland', 'Amet', 'Risus', 'Vulputate', 85, 1, 16 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 41, 'Cori', 'Ablin', 'Cori Ablin', sysdate - 38, sysdate - 46, 'Porttitor', '122 Huntingdon Blvd', 'Castana', 'Risusphase', 'Ligula', 'In', 5, 3, 3 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 42, 'Reinaldo', 'Feltner', 'Reinaldo Feltner', sysdate - 81, sysdate - 35, 'Ex', '837 Wakefield Place', 'Friedensburg', 'Vestibulum', 'Volutpat', 'Suscipit', 57, 1, 8 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 43, 'Coralee', 'Acerno', 'Coralee Acerno', sysdate - 89, sysdate - 62, 'Diam', '564 Sunny Side Street', 'Mission Bend', 'Ac', 'Proin', 'Amet', 55, 2, 13 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 44, 'Katherine', 'Tagg', 'Katherine Tagg', sysdate - 35, sysdate - 90, 'Massa', '303 Starrucca Street', 'Maribel', 'Vestibulum', 'Suscipit', 'Elementum', 84, 5, 41 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 45, 'Lenore', 'Sullivan', 'Lenore Sullivan', sysdate - 76, sysdate - 84, 'Malesuada', '946 Popponesset Island Place', 'El Rio', 'Risus', 'Vestibulum', 'Posuere', 37, 5, 42 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 46, 'erda', 'Sheer', 'erda Sheer', sysdate - 76, sysdate - 45, 'Mi', '755 Bloedel Ave', 'Brazos Bend', 'Pellentesq', 'Curae;', 'Ligula', 62, 3, 40 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 47, 'Pete', 'Chevis', 'Pete Chevis', sysdate - 44, sysdate - 14, 'Porttitor', '439 Mission Bend Street', 'Stonefort', 'Lorem', 'Convallis', 'Aliquam', 25, 4, 28 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 48, 'Joseph', 'Wilke', 'Joseph Wilke', sysdate - 35, sysdate - 45, 'Commodo', '926 Lock Haven Place', 'Huntingdon', 'Pellentesq', 'Amet', 'Aliquam', 56, 1, 43 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 49, 'Nella', 'Rupnick', 'Nella Rupnick', sysdate - 58, sysdate - 77, 'Luctus', '580 Avery Creek Street', 'Luxora', 'Eu', 'Amet', 'Massa', 52, 5, 3 ); insert into ch05_employees ( id, first_name, last_name, father_name, birth_date, hire_date, id_card, address, city, vat_no, telephone, mobile, salary, dept, manager ) values ( 50, 'Azalee', 'Goodwater', 'Azalee Goodwater', sysdate - 89, sysdate - 60, 'Ante', '586 Cedar Park Street', 'Yardville', 'Volutpat', 'Id', 'Fames', 12, 2, 2 ); commit; alter table ch05_employees modify id generated always as identity restart start with 51; -- load data insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 1, 27, 6, sysdate - 59, sysdate - 42, 58 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 2, 14, 15, sysdate - 17, sysdate - 41, 54 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 3, 26, 11, sysdate - 71, sysdate - 24, 19 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 4, 6, 15, sysdate - 32, sysdate - 17, 14 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 5, 35, 3, sysdate - 52, sysdate - 85, 39 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 6, 12, 2, sysdate - 83, sysdate - 61, 51 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 7, 12, 5, sysdate - 34, sysdate - 54, 94 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 8, 34, 4, sysdate - 56, sysdate - 62, 50 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 9, 10, 12, sysdate - 93, sysdate - 67, 24 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 10, 1, 8, sysdate - 6, sysdate - 78, 74 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 11, 24, 10, sysdate - 45, sysdate - 11, 55 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 12, 2, 4, sysdate - 2, sysdate - 77, 82 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 13, 8, 5, sysdate - 35, sysdate - 36, 9 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 14, 42, 4, sysdate - 4, sysdate - 22, 25 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 15, 13, 8, sysdate - 83, sysdate - 59, 3 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 16, 39, 15, sysdate - 81, sysdate - 19, 6 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 17, 14, 5, sysdate - 24, sysdate - 3, 76 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 18, 33, 3, sysdate - 94, sysdate - 38, 92 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 19, 41, 1, sysdate - 23, sysdate - 27, 54 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 20, 27, 12, sysdate - 85, sysdate - 35, 63 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 21, 46, 14, sysdate - 20, sysdate - 11, 37 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 22, 17, 8, sysdate - 50, sysdate - 56, 78 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 23, 20, 15, sysdate - 30, sysdate - 2, 34 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 24, 37, 4, sysdate - 33, sysdate - 64, 83 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 25, 2, 4, sysdate - 42, sysdate - 13, 91 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 26, 46, 4, sysdate - 21, sysdate - 44, 7 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 27, 29, 13, sysdate - 15, sysdate - 39, 96 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 28, 33, 7, sysdate - 42, sysdate - 91, 45 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 29, 48, 7, sysdate - 77, sysdate - 71, 51 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 30, 44, 6, sysdate - 80, sysdate - 8, 1 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 31, 16, 10, sysdate - 13, sysdate - 88, 45 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 32, 2, 10, sysdate - 85, sysdate - 89, 50 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 33, 2, 4, sysdate - 50, sysdate - 92, 7 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 34, 30, 9, sysdate - 66, sysdate - 15, 53 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 35, 24, 4, sysdate - 69, sysdate - 57, 80 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 36, 26, 3, sysdate - 5, sysdate - 95, 35 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 37, 31, 4, sysdate - 1, sysdate - 42, 64 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 38, 14, 14, sysdate - 7, sysdate - 71, 88 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 39, 37, 10, sysdate - 61, sysdate - 49, 38 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 40, 38, 4, sysdate - 11, sysdate - 21, 72 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 41, 21, 4, sysdate - 75, sysdate - 82, 79 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 42, 12, 14, sysdate - 50, sysdate - 79, 10 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 43, 27, 1, sysdate - 28, sysdate - 43, 72 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 44, 47, 6, sysdate - 43, sysdate - 27, 23 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 45, 31, 12, sysdate - 90, sysdate - 30, 59 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 46, 22, 8, sysdate - 18, sysdate - 54, 83 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 47, 31, 5, sysdate - 77, sysdate - 2, 50 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 48, 14, 14, sysdate - 57, sysdate - 2, 86 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 49, 21, 9, sysdate - 96, sysdate - 10, 99 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 50, 46, 8, sysdate - 91, sysdate - 79, 52 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 51, 17, 1, sysdate - 20, sysdate - 39, 85 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 52, 8, 5, sysdate - 86, sysdate - 99, 81 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 53, 40, 13, sysdate - 37, sysdate - 53, 82 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 54, 24, 12, sysdate - 36, sysdate - 94, 95 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 55, 10, 6, sysdate - 91, sysdate - 60, 64 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 56, 9, 7, sysdate - 72, sysdate - 20, 79 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 57, 46, 10, sysdate - 80, sysdate - 93, 24 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 58, 9, 12, sysdate - 96, sysdate - 16, 60 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 59, 45, 7, sysdate - 55, sysdate - 72, 55 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 60, 41, 3, sysdate - 85, sysdate - 83, 82 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 61, 46, 6, sysdate - 88, sysdate - 79, 50 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 62, 19, 3, sysdate - 53, sysdate - 49, 90 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 63, 18, 9, sysdate - 80, sysdate - 97, 15 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 64, 15, 6, sysdate - 35, sysdate - 22, 5 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 65, 50, 11, sysdate - 34, sysdate - 73, 10 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 66, 26, 3, sysdate - 86, sysdate - 94, 7 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 67, 36, 8, sysdate - 75, sysdate - 53, 67 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 68, 4, 14, sysdate - 53, sysdate - 8, 48 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 69, 24, 4, sysdate - 29, sysdate - 29, 89 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 70, 27, 7, sysdate - 87, sysdate - 39, 89 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 71, 22, 11, sysdate - 93, sysdate - 41, 92 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 72, 47, 13, sysdate - 4, sysdate - 42, 3 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 73, 27, 13, sysdate - 92, sysdate - 95, 100 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 74, 9, 3, sysdate - 70, sysdate - 20, 6 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 75, 18, 8, sysdate - 29, sysdate - 42, 23 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 76, 12, 10, sysdate - 89, sysdate - 41, 89 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 77, 5, 8, sysdate - 24, sysdate - 47, 1 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 78, 2, 2, sysdate - 34, sysdate - 19, 92 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 79, 41, 1, sysdate - 12, sysdate - 9, 19 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 80, 45, 11, sysdate - 75, sysdate - 43, 15 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 81, 17, 15, sysdate - 8, sysdate - 33, 52 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 82, 7, 10, sysdate - 32, sysdate - 65, 57 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 83, 38, 13, sysdate - 77, sysdate - 33, 96 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 84, 40, 2, sysdate - 44, sysdate - 60, 40 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 85, 27, 1, sysdate - 41, sysdate - 99, 35 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 86, 9, 12, sysdate - 41, sysdate - 28, 22 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 87, 13, 2, sysdate - 91, sysdate - 6, 62 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 88, 41, 4, sysdate - 76, sysdate - 67, 90 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 89, 27, 9, sysdate - 72, sysdate - 81, 44 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 90, 31, 15, sysdate - 46, sysdate - 61, 85 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 91, 21, 8, sysdate - 9, sysdate - 18, 43 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 92, 40, 13, sysdate - 73, sysdate - 49, 2 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 93, 39, 11, sysdate - 38, sysdate - 53, 13 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 94, 3, 10, sysdate - 89, sysdate - 24, 45 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 95, 21, 11, sysdate - 95, sysdate - 62, 87 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 96, 7, 14, sysdate - 61, sysdate - 31, 57 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 97, 22, 11, sysdate - 96, sysdate - 93, 77 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 98, 24, 11, sysdate - 1, sysdate - 39, 3 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 99, 48, 4, sysdate - 20, sysdate - 80, 22 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 100, 6, 10, sysdate - 88, sysdate - 39, 2 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 101, 41, 14, sysdate - 1, sysdate - 33, 29 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 102, 34, 14, sysdate - 77, sysdate - 15, 96 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 103, 7, 9, sysdate - 39, sysdate - 40, 88 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 104, 42, 4, sysdate - 53, sysdate - 9, 56 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 105, 1, 7, sysdate - 4, sysdate - 34, 30 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 106, 18, 5, sysdate - 40, sysdate - 21, 83 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 107, 47, 7, sysdate - 86, sysdate - 70, 45 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 108, 29, 9, sysdate - 73, sysdate - 69, 3 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 109, 6, 10, sysdate - 73, sysdate - 91, 20 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 110, 22, 5, sysdate - 73, sysdate - 78, 6 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 111, 48, 1, sysdate - 10, sysdate - 23, 69 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 112, 29, 3, sysdate - 77, sysdate - 89, 89 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 113, 44, 5, sysdate - 51, sysdate - 74, 9 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 114, 7, 12, sysdate - 96, sysdate - 60, 81 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 115, 30, 2, sysdate - 63, sysdate - 67, 16 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 116, 14, 8, sysdate - 83, sysdate - 31, 81 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 117, 16, 2, sysdate - 38, sysdate - 70, 73 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 118, 48, 15, sysdate - 18, sysdate - 89, 44 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 119, 33, 9, sysdate - 27, sysdate - 41, 17 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 120, 36, 7, sysdate - 33, sysdate - 40, 17 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 121, 11, 11, sysdate - 73, sysdate - 74, 94 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 122, 45, 6, sysdate - 78, sysdate - 86, 13 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 123, 21, 5, sysdate - 57, sysdate - 7, 56 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 124, 18, 5, sysdate - 1, sysdate - 34, 37 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 125, 6, 4, sysdate - 19, sysdate - 52, 86 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 126, 25, 5, sysdate - 79, sysdate - 29, 24 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 127, 11, 6, sysdate - 12, sysdate - 23, 58 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 128, 32, 8, sysdate - 10, sysdate - 91, 52 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 129, 32, 2, sysdate - 30, sysdate - 57, 76 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 130, 26, 6, sysdate - 41, sysdate - 10, 1 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 131, 49, 6, sysdate - 71, sysdate - 81, 60 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 132, 16, 11, sysdate - 69, sysdate - 98, 90 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 133, 50, 14, sysdate - 20, sysdate - 92, 68 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 134, 50, 13, sysdate - 12, sysdate - 17, 94 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 135, 11, 1, sysdate - 40, sysdate - 99, 81 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 136, 43, 9, sysdate - 63, sysdate - 49, 92 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 137, 7, 13, sysdate - 85, sysdate - 91, 75 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 138, 2, 5, sysdate - 20, sysdate - 72, 22 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 139, 28, 7, sysdate - 60, sysdate - 8, 63 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 140, 1, 14, sysdate - 31, sysdate - 74, 92 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 141, 7, 12, sysdate - 36, sysdate - 70, 45 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 142, 30, 7, sysdate - 93, sysdate - 54, 87 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 143, 47, 9, sysdate - 93, sysdate - 64, 94 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 144, 16, 13, sysdate - 30, sysdate - 52, 59 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 145, 22, 13, sysdate - 85, sysdate - 61, 98 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 146, 36, 11, sysdate - 1, sysdate - 63, 19 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 147, 20, 11, sysdate - 46, sysdate - 13, 88 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 148, 38, 7, sysdate - 55, sysdate - 62, 84 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 149, 1, 13, sysdate - 93, sysdate - 71, 98 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 150, 7, 5, sysdate - 97, sysdate - 48, 18 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 151, 8, 4, sysdate - 63, sysdate - 47, 70 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 152, 11, 10, sysdate - 17, sysdate - 10, 47 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 153, 3, 7, sysdate - 3, sysdate - 80, 62 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 154, 13, 7, sysdate - 41, sysdate - 41, 36 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 155, 39, 7, sysdate - 7, sysdate - 95, 100 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 156, 29, 5, sysdate - 43, sysdate - 10, 59 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 157, 34, 1, sysdate - 58, sysdate - 45, 9 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 158, 26, 8, sysdate - 98, sysdate - 79, 47 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 159, 26, 14, sysdate - 50, sysdate - 99, 48 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 160, 42, 1, sysdate - 51, sysdate - 4, 15 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 161, 2, 4, sysdate - 22, sysdate - 56, 6 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 162, 28, 9, sysdate - 57, sysdate - 92, 1 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 163, 28, 15, sysdate - 2, sysdate - 94, 62 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 164, 39, 2, sysdate - 6, sysdate - 5, 10 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 165, 20, 10, sysdate - 44, sysdate - 4, 38 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 166, 2, 5, sysdate - 16, sysdate - 18, 10 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 167, 32, 10, sysdate - 62, sysdate - 3, 60 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 168, 8, 7, sysdate - 6, sysdate - 32, 61 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 169, 2, 4, sysdate - 23, sysdate - 15, 14 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 170, 50, 4, sysdate - 46, sysdate - 63, 40 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 171, 23, 5, sysdate - 48, sysdate - 78, 35 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 172, 45, 13, sysdate - 76, sysdate - 15, 78 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 173, 19, 14, sysdate - 68, sysdate - 71, 43 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 174, 18, 12, sysdate - 1, sysdate - 48, 80 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 175, 42, 15, sysdate - 61, sysdate - 41, 35 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 176, 18, 15, sysdate - 19, sysdate - 21, 52 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 177, 32, 13, sysdate - 25, sysdate - 95, 20 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 178, 19, 8, sysdate - 9, sysdate - 5, 24 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 179, 18, 14, sysdate - 22, sysdate - 1, 64 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 180, 34, 4, sysdate - 56, sysdate - 60, 5 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 181, 43, 2, sysdate - 24, sysdate - 44, 73 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 182, 28, 1, sysdate - 25, sysdate - 59, 70 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 183, 30, 1, sysdate - 68, sysdate - 10, 24 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 184, 22, 3, sysdate - 65, sysdate - 72, 78 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 185, 37, 8, sysdate - 15, sysdate - 30, 85 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 186, 46, 12, sysdate - 33, sysdate - 67, 45 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 187, 36, 11, sysdate - 97, sysdate - 37, 22 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 188, 4, 4, sysdate - 98, sysdate - 93, 87 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 189, 11, 8, sysdate - 32, sysdate - 17, 41 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 190, 23, 7, sysdate - 51, sysdate - 51, 64 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 191, 7, 12, sysdate - 27, sysdate - 54, 100 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 192, 10, 1, sysdate - 15, sysdate - 77, 45 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 193, 26, 11, sysdate - 50, sysdate - 57, 61 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 194, 49, 12, sysdate - 86, sysdate - 17, 39 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 195, 24, 9, sysdate - 29, sysdate - 95, 42 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 196, 43, 4, sysdate - 83, sysdate - 15, 22 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 197, 48, 14, sysdate - 31, sysdate - 17, 78 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 198, 6, 1, sysdate - 46, sysdate - 99, 79 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 199, 12, 9, sysdate - 2, sysdate - 38, 50 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 200, 19, 14, sysdate - 45, sysdate - 73, 14 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 201, 44, 11, sysdate - 82, sysdate - 93, 72 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 202, 27, 14, sysdate - 69, sysdate - 65, 85 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 203, 1, 8, sysdate - 19, sysdate - 13, 81 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 204, 47, 7, sysdate - 94, sysdate - 10, 19 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 205, 14, 9, sysdate - 11, sysdate - 58, 83 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 206, 18, 14, sysdate - 95, sysdate - 73, 65 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 207, 48, 13, sysdate - 79, sysdate - 84, 4 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 208, 30, 9, sysdate - 76, sysdate - 94, 1 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 209, 43, 6, sysdate - 68, sysdate - 74, 36 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 210, 6, 6, sysdate - 94, sysdate - 61, 14 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 211, 46, 10, sysdate - 90, sysdate - 74, 1 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 212, 16, 8, sysdate - 53, sysdate - 20, 24 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 213, 49, 8, sysdate - 37, sysdate - 8, 18 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 214, 26, 4, sysdate - 42, sysdate - 75, 31 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 215, 33, 14, sysdate - 15, sysdate - 84, 8 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 216, 23, 1, sysdate - 98, sysdate - 91, 51 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 217, 29, 15, sysdate - 29, sysdate - 50, 7 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 218, 45, 10, sysdate - 22, sysdate - 16, 82 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 219, 28, 4, sysdate - 34, sysdate - 26, 69 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 220, 30, 3, sysdate - 64, sysdate - 90, 92 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 221, 6, 4, sysdate - 14, sysdate - 72, 47 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 222, 41, 5, sysdate - 54, sysdate - 18, 56 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 223, 4, 5, sysdate - 13, sysdate - 7, 25 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 224, 40, 6, sysdate - 7, sysdate - 72, 32 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 225, 45, 12, sysdate - 82, sysdate - 46, 50 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 226, 21, 6, sysdate - 20, sysdate - 97, 78 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 227, 10, 6, sysdate - 27, sysdate - 50, 85 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 228, 41, 2, sysdate - 59, sysdate - 56, 32 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 229, 9, 9, sysdate - 4, sysdate - 50, 24 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 230, 12, 1, sysdate - 32, sysdate - 31, 97 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 231, 28, 15, sysdate - 76, sysdate - 29, 17 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 232, 39, 6, sysdate - 76, sysdate - 73, 86 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 233, 41, 7, sysdate - 89, sysdate - 52, 21 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 234, 7, 6, sysdate - 33, sysdate - 67, 53 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 235, 32, 12, sysdate - 6, sysdate - 17, 33 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 236, 50, 13, sysdate - 28, sysdate - 49, 30 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 237, 6, 11, sysdate - 43, sysdate - 27, 99 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 238, 30, 8, sysdate - 6, sysdate - 84, 90 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 239, 50, 10, sysdate - 82, sysdate - 96, 54 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 240, 17, 3, sysdate - 32, sysdate - 15, 92 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 241, 25, 14, sysdate - 13, sysdate - 39, 61 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 242, 37, 8, sysdate - 40, sysdate - 80, 59 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 243, 39, 13, sysdate - 21, sysdate - 76, 14 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 244, 45, 12, sysdate - 22, sysdate - 57, 39 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 245, 44, 9, sysdate - 12, sysdate - 73, 23 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 246, 16, 2, sysdate - 89, sysdate - 53, 1 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 247, 24, 12, sysdate - 96, sysdate - 19, 45 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 248, 19, 15, sysdate - 93, sysdate - 99, 100 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 249, 1, 10, sysdate - 74, sysdate - 57, 2 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 250, 31, 9, sysdate - 31, sysdate - 18, 65 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 251, 13, 1, sysdate - 88, sysdate - 53, 24 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 252, 6, 8, sysdate - 53, sysdate - 21, 67 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 253, 46, 4, sysdate - 12, sysdate - 63, 19 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 254, 4, 8, sysdate - 27, sysdate - 80, 35 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 255, 6, 2, sysdate - 51, sysdate - 84, 4 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 256, 25, 3, sysdate - 52, sysdate - 71, 98 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 257, 33, 12, sysdate - 34, sysdate - 54, 94 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 258, 1, 12, sysdate - 96, sysdate - 67, 20 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 259, 12, 1, sysdate - 98, sysdate - 78, 90 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 260, 44, 7, sysdate - 5, sysdate - 78, 78 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 261, 12, 2, sysdate - 19, sysdate - 91, 45 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 262, 35, 12, sysdate - 13, sysdate - 44, 59 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 263, 22, 12, sysdate - 74, sysdate - 45, 99 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 264, 19, 4, sysdate - 89, sysdate - 23, 82 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 265, 31, 9, sysdate - 49, sysdate - 37, 35 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 266, 2, 14, sysdate - 63, sysdate - 90, 98 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 267, 46, 10, sysdate - 36, sysdate - 25, 13 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 268, 50, 5, sysdate - 11, sysdate - 79, 43 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 269, 12, 13, sysdate - 80, sysdate - 21, 85 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 270, 14, 14, sysdate - 73, sysdate - 49, 95 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 271, 16, 15, sysdate - 42, sysdate - 33, 68 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 272, 39, 7, sysdate - 56, sysdate - 10, 90 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 273, 46, 1, sysdate - 59, sysdate - 73, 41 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 274, 11, 5, sysdate - 13, sysdate - 87, 30 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 275, 36, 8, sysdate - 83, sysdate - 39, 47 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 276, 17, 9, sysdate - 15, sysdate - 73, 84 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 277, 3, 9, sysdate - 44, sysdate - 39, 12 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 278, 20, 13, sysdate - 98, sysdate - 20, 95 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 279, 40, 7, sysdate - 86, sysdate - 71, 6 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 280, 15, 14, sysdate - 23, sysdate - 50, 14 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 281, 9, 9, sysdate - 35, sysdate - 68, 76 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 282, 25, 7, sysdate - 15, sysdate - 45, 46 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 283, 15, 2, sysdate - 48, sysdate - 33, 62 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 284, 17, 12, sysdate - 55, sysdate - 47, 8 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 285, 37, 1, sysdate - 67, sysdate - 95, 78 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 286, 13, 1, sysdate - 68, sysdate - 30, 85 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 287, 13, 15, sysdate - 62, sysdate - 53, 43 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 288, 18, 12, sysdate - 44, sysdate - 11, 53 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 289, 18, 7, sysdate - 84, sysdate - 32, 74 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 290, 37, 11, sysdate - 20, sysdate - 38, 6 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 291, 1, 7, sysdate - 78, sysdate - 82, 90 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 292, 36, 13, sysdate - 93, sysdate - 26, 30 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 293, 2, 15, sysdate - 81, sysdate - 17, 8 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 294, 42, 4, sysdate - 67, sysdate - 21, 67 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 295, 29, 10, sysdate - 46, sysdate - 67, 11 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 296, 49, 5, sysdate - 94, sysdate - 89, 46 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 297, 48, 8, sysdate - 15, sysdate - 92, 95 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 298, 33, 7, sysdate - 48, sysdate - 27, 32 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 299, 6, 3, sysdate - 56, sysdate - 66, 49 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 300, 4, 12, sysdate - 39, sysdate - 62, 50 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 301, 20, 12, sysdate - 22, sysdate - 21, 82 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 302, 7, 2, sysdate - 81, sysdate - 41, 6 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 303, 21, 13, sysdate - 11, sysdate - 76, 10 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 304, 44, 6, sysdate - 77, sysdate - 48, 96 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 305, 7, 9, sysdate - 79, sysdate - 68, 8 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 306, 10, 14, sysdate - 98, sysdate - 31, 95 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 307, 27, 13, sysdate - 30, sysdate - 37, 84 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 308, 50, 9, sysdate - 78, sysdate - 83, 60 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 309, 37, 6, sysdate - 8, sysdate - 43, 58 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 310, 50, 14, sysdate - 16, sysdate - 51, 45 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 311, 39, 10, sysdate - 82, sysdate - 90, 94 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 312, 46, 14, sysdate - 73, sysdate - 93, 42 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 313, 44, 12, sysdate - 30, sysdate - 28, 77 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 314, 20, 3, sysdate - 97, sysdate - 37, 83 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 315, 46, 10, sysdate - 10, sysdate - 92, 25 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 316, 27, 15, sysdate - 10, sysdate - 66, 7 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 317, 6, 14, sysdate - 10, sysdate - 76, 59 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 318, 24, 13, sysdate - 22, sysdate - 53, 10 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 319, 17, 5, sysdate - 64, sysdate - 43, 50 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 320, 41, 11, sysdate - 85, sysdate - 50, 51 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 321, 19, 3, sysdate - 63, sysdate - 76, 49 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 322, 21, 9, sysdate - 52, sysdate - 25, 19 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 323, 9, 11, sysdate - 72, sysdate - 4, 33 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 324, 26, 14, sysdate - 40, sysdate - 91, 91 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 325, 18, 4, sysdate - 11, sysdate - 69, 20 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 326, 5, 14, sysdate - 66, sysdate - 9, 18 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 327, 17, 15, sysdate - 44, sysdate - 16, 25 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 328, 20, 13, sysdate - 42, sysdate - 24, 97 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 329, 20, 9, sysdate - 48, sysdate - 9, 27 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 330, 15, 10, sysdate - 26, sysdate - 94, 97 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 331, 45, 5, sysdate - 89, sysdate - 5, 96 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 332, 46, 7, sysdate - 52, sysdate - 42, 64 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 333, 2, 1, sysdate - 36, sysdate - 20, 99 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 334, 35, 8, sysdate - 53, sysdate - 4, 89 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 335, 36, 3, sysdate - 67, sysdate - 58, 35 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 336, 48, 10, sysdate - 10, sysdate - 3, 74 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 337, 20, 15, sysdate - 56, sysdate - 31, 81 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 338, 11, 12, sysdate - 93, sysdate - 55, 2 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 339, 18, 9, sysdate - 55, sysdate - 78, 16 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 340, 34, 12, sysdate - 98, sysdate - 39, 2 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 341, 35, 9, sysdate - 64, sysdate - 5, 43 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 342, 49, 8, sysdate - 34, sysdate - 46, 73 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 343, 48, 11, sysdate - 33, sysdate - 56, 50 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 344, 48, 4, sysdate - 59, sysdate - 21, 55 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 345, 9, 2, sysdate - 45, sysdate - 12, 100 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 346, 21, 14, sysdate - 20, sysdate - 54, 72 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 347, 9, 2, sysdate - 54, sysdate - 1, 36 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 348, 2, 3, sysdate - 44, sysdate - 55, 29 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 349, 44, 7, sysdate - 14, sysdate - 92, 8 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 350, 14, 10, sysdate - 46, sysdate - 47, 90 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 351, 30, 6, sysdate - 74, sysdate - 82, 82 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 352, 29, 4, sysdate - 47, sysdate - 8, 80 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 353, 34, 10, sysdate - 90, sysdate - 44, 29 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 354, 12, 3, sysdate - 95, sysdate - 74, 72 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 355, 26, 2, sysdate - 53, sysdate - 26, 95 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 356, 11, 4, sysdate - 19, sysdate - 11, 36 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 357, 37, 3, sysdate - 21, sysdate - 79, 22 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 358, 38, 3, sysdate - 17, sysdate - 39, 57 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 359, 25, 6, sysdate - 6, sysdate - 9, 69 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 360, 35, 5, sysdate - 33, sysdate - 48, 68 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 361, 20, 7, sysdate - 58, sysdate - 67, 54 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 362, 4, 4, sysdate - 30, sysdate - 48, 67 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 363, 3, 8, sysdate - 64, sysdate - 7, 82 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 364, 47, 14, sysdate - 73, sysdate - 62, 56 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 365, 47, 9, sysdate - 81, sysdate - 14, 47 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 366, 44, 1, sysdate - 64, sysdate - 49, 69 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 367, 50, 15, sysdate - 92, sysdate - 4, 59 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 368, 33, 5, sysdate - 77, sysdate - 53, 10 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 369, 50, 9, sysdate - 23, sysdate - 31, 60 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 370, 46, 8, sysdate - 85, sysdate - 72, 83 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 371, 10, 13, sysdate - 18, sysdate - 58, 76 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 372, 28, 4, sysdate - 23, sysdate - 64, 95 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 373, 9, 3, sysdate - 50, sysdate - 36, 8 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 374, 42, 12, sysdate - 81, sysdate - 6, 84 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 375, 6, 12, sysdate - 49, sysdate - 66, 29 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 376, 18, 6, sysdate - 53, sysdate - 66, 46 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 377, 15, 1, sysdate - 29, sysdate - 47, 54 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 378, 46, 10, sysdate - 16, sysdate - 64, 29 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 379, 9, 5, sysdate - 47, sysdate - 52, 48 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 380, 7, 1, sysdate - 96, sysdate - 20, 64 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 381, 50, 8, sysdate - 18, sysdate - 95, 26 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 382, 29, 8, sysdate - 80, sysdate - 95, 60 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 383, 48, 10, sysdate - 35, sysdate - 27, 25 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 384, 34, 7, sysdate - 43, sysdate - 77, 67 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 385, 31, 13, sysdate - 91, sysdate - 79, 5 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 386, 31, 13, sysdate - 45, sysdate - 20, 100 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 387, 2, 14, sysdate - 58, sysdate - 61, 37 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 388, 40, 8, sysdate - 15, sysdate - 31, 50 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 389, 26, 14, sysdate - 62, sysdate - 76, 45 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 390, 27, 7, sysdate - 53, sysdate - 16, 54 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 391, 7, 15, sysdate - 76, sysdate - 68, 87 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 392, 47, 9, sysdate - 35, sysdate - 7, 79 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 393, 11, 1, sysdate - 30, sysdate - 84, 42 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 394, 25, 10, sysdate - 31, sysdate - 63, 14 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 395, 4, 12, sysdate - 59, sysdate - 94, 97 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 396, 10, 5, sysdate - 60, sysdate - 10, 94 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 397, 30, 13, sysdate - 97, sysdate - 20, 21 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 398, 49, 10, sysdate - 24, sysdate - 80, 87 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 399, 40, 5, sysdate - 40, sysdate - 57, 8 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 400, 46, 12, sysdate - 78, sysdate - 15, 60 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 401, 42, 8, sysdate - 41, sysdate - 96, 83 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 402, 44, 4, sysdate - 55, sysdate - 27, 13 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 403, 36, 7, sysdate - 39, sysdate - 40, 43 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 404, 16, 11, sysdate - 36, sysdate - 39, 58 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 405, 8, 5, sysdate - 6, sysdate - 27, 86 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 406, 13, 14, sysdate - 81, sysdate - 39, 55 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 407, 28, 10, sysdate - 93, sysdate - 84, 63 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 408, 50, 8, sysdate - 66, sysdate - 26, 68 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 409, 11, 8, sysdate - 75, sysdate - 93, 38 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 410, 38, 4, sysdate - 90, sysdate - 89, 40 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 411, 37, 9, sysdate - 8, sysdate - 7, 49 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 412, 3, 6, sysdate - 87, sysdate - 22, 87 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 413, 11, 6, sysdate - 55, sysdate - 66, 3 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 414, 40, 9, sysdate - 81, sysdate - 43, 88 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 415, 5, 2, sysdate - 13, sysdate - 75, 67 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 416, 6, 2, sysdate - 73, sysdate - 10, 7 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 417, 31, 3, sysdate - 30, sysdate - 10, 49 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 418, 16, 8, sysdate - 31, sysdate - 32, 90 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 419, 46, 5, sysdate - 90, sysdate - 49, 91 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 420, 13, 6, sysdate - 22, sysdate - 25, 77 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 421, 31, 7, sysdate - 6, sysdate - 99, 95 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 422, 47, 1, sysdate - 79, sysdate - 1, 68 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 423, 36, 11, sysdate - 55, sysdate - 8, 55 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 424, 18, 6, sysdate - 89, sysdate - 44, 27 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 425, 17, 3, sysdate - 23, sysdate - 92, 97 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 426, 17, 15, sysdate - 14, sysdate - 53, 41 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 427, 15, 15, sysdate - 23, sysdate - 27, 89 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 428, 46, 15, sysdate - 47, sysdate - 5, 70 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 429, 18, 8, sysdate - 43, sysdate - 84, 71 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 430, 15, 7, sysdate - 49, sysdate - 81, 43 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 431, 15, 7, sysdate - 18, sysdate - 24, 81 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 432, 40, 6, sysdate - 8, sysdate - 97, 42 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 433, 17, 7, sysdate - 29, sysdate - 47, 93 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 434, 41, 11, sysdate - 66, sysdate - 64, 54 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 435, 34, 8, sysdate - 46, sysdate - 23, 40 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 436, 37, 12, sysdate - 65, sysdate - 16, 88 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 437, 24, 1, sysdate - 72, sysdate - 51, 17 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 438, 41, 14, sysdate - 51, sysdate - 86, 48 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 439, 28, 5, sysdate - 81, sysdate - 52, 8 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 440, 37, 4, sysdate - 97, sysdate - 39, 33 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 441, 32, 4, sysdate - 51, sysdate - 63, 72 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 442, 40, 13, sysdate - 24, sysdate - 59, 27 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 443, 2, 14, sysdate - 90, sysdate - 19, 14 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 444, 41, 13, sysdate - 44, sysdate - 24, 20 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 445, 30, 7, sysdate - 56, sysdate - 65, 42 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 446, 26, 3, sysdate - 70, sysdate - 76, 76 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 447, 32, 5, sysdate - 48, sysdate - 78, 54 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 448, 25, 7, sysdate - 55, sysdate - 61, 27 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 449, 49, 9, sysdate - 21, sysdate - 98, 40 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 450, 45, 15, sysdate - 34, sysdate - 19, 76 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 451, 48, 11, sysdate - 31, sysdate - 3, 54 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 452, 9, 8, sysdate - 47, sysdate - 18, 1 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 453, 22, 12, sysdate - 73, sysdate - 37, 97 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 454, 34, 13, sysdate - 23, sysdate - 53, 96 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 455, 21, 6, sysdate - 52, sysdate - 19, 75 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 456, 37, 7, sysdate - 68, sysdate - 98, 80 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 457, 2, 12, sysdate - 99, sysdate - 14, 37 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 458, 42, 5, sysdate - 91, sysdate - 11, 78 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 459, 6, 8, sysdate - 22, sysdate - 32, 93 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 460, 8, 6, sysdate - 66, sysdate - 55, 59 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 461, 3, 6, sysdate - 78, sysdate - 76, 57 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 462, 28, 15, sysdate - 31, sysdate - 7, 43 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 463, 12, 15, sysdate - 46, sysdate - 69, 87 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 464, 23, 5, sysdate - 97, sysdate - 87, 54 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 465, 6, 11, sysdate - 72, sysdate - 97, 21 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 466, 1, 13, sysdate - 48, sysdate - 63, 5 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 467, 44, 15, sysdate - 19, sysdate - 60, 98 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 468, 47, 11, sysdate - 44, sysdate - 90, 57 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 469, 14, 12, sysdate - 60, sysdate - 92, 99 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 470, 2, 14, sysdate - 32, sysdate - 94, 66 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 471, 35, 4, sysdate - 38, sysdate - 19, 33 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 472, 34, 9, sysdate - 11, sysdate - 58, 58 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 473, 41, 1, sysdate - 38, sysdate - 56, 91 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 474, 27, 3, sysdate - 79, sysdate - 25, 85 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 475, 29, 15, sysdate - 90, sysdate - 52, 66 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 476, 36, 10, sysdate - 93, sysdate - 10, 4 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 477, 42, 5, sysdate - 35, sysdate - 43, 9 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 478, 41, 14, sysdate - 89, sysdate - 22, 35 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 479, 8, 2, sysdate - 88, sysdate - 28, 47 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 480, 46, 6, sysdate - 33, sysdate - 60, 39 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 481, 32, 8, sysdate - 15, sysdate - 44, 48 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 482, 48, 4, sysdate - 63, sysdate - 89, 9 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 483, 8, 4, sysdate - 50, sysdate - 60, 8 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 484, 35, 4, sysdate - 32, sysdate - 76, 24 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 485, 7, 15, sysdate - 23, sysdate - 68, 49 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 486, 44, 1, sysdate - 75, sysdate - 51, 10 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 487, 10, 9, sysdate - 39, sysdate - 13, 18 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 488, 7, 8, sysdate - 19, sysdate - 9, 20 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 489, 37, 1, sysdate - 83, sysdate - 85, 95 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 490, 34, 6, sysdate - 36, sysdate - 86, 1 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 491, 17, 4, sysdate - 84, sysdate - 70, 97 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 492, 11, 6, sysdate - 25, sysdate - 8, 5 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 493, 26, 13, sysdate - 6, sysdate - 9, 28 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 494, 48, 13, sysdate - 54, sysdate - 82, 71 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 495, 3, 10, sysdate - 43, sysdate - 91, 95 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 496, 8, 5, sysdate - 92, sysdate - 98, 15 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 497, 3, 14, sysdate - 8, sysdate - 77, 87 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 498, 7, 4, sysdate - 96, sysdate - 4, 46 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 499, 12, 12, sysdate - 52, sysdate - 96, 37 ); insert into ch05_emp_proj ( id, emp, proj, start_date, end_date, earnings ) values ( 500, 48, 11, sysdate - 20, sysdate - 78, 13 ); commit; alter table ch05_emp_proj modify id generated always as identity restart start with 501; -- Generated by Quick SQL Tuesday April 25, 2023 21:07:46 /* ch05_departments /insert 5 dept_name vc100 ch05_projects /insert 15 proj_name vc100 budget num begin_date date end_date date ch05_employees /insert 50 first_name vc20 last_name vc20 father_name vc20 birth_date date hire_date date id_card vc10 address vc100 city vc20 vat_no vc10 telephone vc20 mobile vc20 salary num dept num /fk ch05_departments manager num /fk ch05_employees ch05_emp_proj /insert 500 emp num /fk ch05_employees proj num /fk ch05_projects start_date date end_date date earnings num # settings = { semantics: "CHAR", language: "EN", APEX: true } drop table ch05_emp_proj; drop table ch05_employees; drop table ch05_departments; drop table ch05_projects; */