create table employee(
  companyid char(9),
  employeeid char(9),
  hiredate date);

insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100001', '1993-11-19');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100002', '1993-11-20');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100003', '1993-11-21');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100004', '1993-11-22');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100005', '1993-11-23');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100006', '1993-11-24');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100007', '1993-11-25');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100008', '1993-11-26');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100009', '1993-11-27');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100010', '1993-11-28');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100011', '1993-11-29');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100012', '1993-11-30');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100013', '1993-12-01');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100014', '1993-12-02');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100015', '1993-12-03');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100016', '1993-12-04');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100017', '1993-12-05');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100018', '1993-12-06');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100019', '1993-12-07');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100020', '1993-12-08');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100021', '1993-12-09');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100022', '1993-12-10');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100023', '1993-12-11');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100024', '1993-12-12');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100025', '1993-12-13');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100026', '1993-12-14');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100027', '1993-12-15');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100028', '1993-12-16');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100029', '1993-12-17');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100030', '1993-12-18');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100031', '1993-12-19');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100032', '1993-12-20');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100033', '1993-12-21');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100034', '1993-12-22');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100035', '1993-12-23');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100036', '1993-12-24');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100037', '1993-12-25');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100038', '1993-12-26');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100039', '1993-12-27');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100040', '1993-12-28');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100041', '1993-12-29');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100042', '1993-12-30');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100043', '1993-12-31');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100044', '1994-01-01');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100045', '1994-01-02');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100046', '1994-01-03');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100047', '1994-01-04');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100048', '1994-01-05');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100049', '1994-01-06');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100050', '1994-01-07');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100051', '1994-01-08');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100052', '1994-01-09');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100053', '1994-01-10');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100054', '1994-01-11');
insert into employee(companyid, employeeid, hiredate) values ('000000001', '000100055', '1994-01-12');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200001', '1993-11-19');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200002', '1993-11-20');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200003', '1993-11-21');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200004', '1993-11-22');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200005', '1993-11-23');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200006', '1993-11-24');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200007', '1993-11-25');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200008', '1993-11-26');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200009', '1993-11-27');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200010', '1993-11-28');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200011', '1993-11-29');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200012', '1993-11-30');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200013', '1993-12-01');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200014', '1993-12-02');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200015', '1993-12-03');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200016', '1993-12-04');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200017', '1993-12-05');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200018', '1993-12-06');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200019', '1993-12-07');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200020', '1993-12-08');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200021', '1993-12-09');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200022', '1993-12-10');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200023', '1993-12-11');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200024', '1993-12-12');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200025', '1993-12-13');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200026', '1993-12-14');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200027', '1993-12-15');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200028', '1993-12-16');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200029', '1993-12-17');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200030', '1993-12-18');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200031', '1993-12-19');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200032', '1993-12-20');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200033', '1993-12-21');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200034', '1993-12-22');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200035', '1993-12-23');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200036', '1993-12-24');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200037', '1993-12-25');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200038', '1993-12-26');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200039', '1993-12-27');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200040', '1993-12-28');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200041', '1993-12-29');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200042', '1993-12-30');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200043', '1993-12-31');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200044', '1994-01-01');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200045', '1994-01-02');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200046', '1994-01-03');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200047', '1994-01-04');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200048', '1994-01-05');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200049', '1994-01-06');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200050', '1994-01-07');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200051', '1994-01-08');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200052', '1994-01-09');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200053', '1994-01-10');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200054', '1994-01-11');
insert into employee(companyid, employeeid, hiredate) values ('000000002', '000200055', '1994-01-12');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300001', '1993-11-19');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300002', '1993-11-20');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300003', '1993-11-21');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300004', '1993-11-22');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300005', '1993-11-23');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300006', '1993-11-24');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300007', '1993-11-25');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300008', '1993-11-26');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300009', '1993-11-27');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300010', '1993-11-28');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300011', '1993-11-29');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300012', '1993-11-30');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300013', '1993-12-01');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300014', '1993-12-02');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300015', '1993-12-03');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300016', '1993-12-04');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300017', '1993-12-05');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300018', '1993-12-06');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300019', '1993-12-07');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300020', '1993-12-08');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300021', '1993-12-09');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300022', '1993-12-10');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300023', '1993-12-11');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300024', '1993-12-12');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300025', '1993-12-13');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300026', '1993-12-14');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300027', '1993-12-15');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300028', '1993-12-16');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300029', '1993-12-17');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300030', '1993-12-18');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300031', '1993-12-19');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300032', '1993-12-20');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300033', '1993-12-21');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300034', '1993-12-22');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300035', '1993-12-23');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300036', '1993-12-24');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300037', '1993-12-25');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300038', '1993-12-26');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300039', '1993-12-27');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300040', '1993-12-28');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300041', '1993-12-29');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300042', '1993-12-30');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300043', '1993-12-31');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300044', '1994-01-01');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300045', '1994-01-02');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300046', '1994-01-03');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300047', '1994-01-04');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300048', '1994-01-05');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300049', '1994-01-06');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300050', '1994-01-07');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300051', '1994-01-08');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300052', '1994-01-09');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300053', '1994-01-10');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300054', '1994-01-11');
insert into employee(companyid, employeeid, hiredate) values ('000000003', '000300055', '1994-01-12');

select companyid, employeeid, hiredate
from employee e
where 49 >
  (select count(*) from employee ei
   where ei.companyid = e.companyid and
   ei.hiredate > e.hiredate) 
order by companyid, hiredate;

select companyid, employeeid, hiredate
from employee e
where not exists
 (select *
  from employee ei
  where ei.companyid = e.companyid
  and ei.employeeid = e.employeeid
  and 49 >
    (select count(*) from employee eii
     where eii.companyid = ei.companyid and
     eii.hiredate < ei.hiredate));

create table employeeaddress(
  employeeid char(9),
  address varchar(200));


insert into employeeaddress(employeeid, address) values ('000100001', '123 Main Street, Suite 100001 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100002', '123 Main Street, Suite 100002 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100003', '123 Main Street, Suite 100003 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100008', '123 Main Street, Suite 100008 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100009', '123 Main Street, Suite 100009 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100010', '123 Main Street, Suite 100010 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100011', '123 Main Street, Suite 100011 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100015', '123 Main Street, Suite 100015 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100016', '123 Main Street, Suite 100016 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100020', '123 Main Street, Suite 100020 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100021', '123 Main Street, Suite 100021 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100022', '123 Main Street, Suite 100022 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100023', '123 Main Street, Suite 100023 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100024', '123 Main Street, Suite 100024 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100025', '123 Main Street, Suite 100025 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100026', '123 Main Street, Suite 100026 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100027', '123 Main Street, Suite 100027 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100028', '123 Main Street, Suite 100028 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100029', '123 Main Street, Suite 100029 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100030', '123 Main Street, Suite 100030 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100031', '123 Main Street, Suite 100031 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100032', '123 Main Street, Suite 100032 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100033', '123 Main Street, Suite 100033 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100034', '123 Main Street, Suite 100034 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100035', '123 Main Street, Suite 100035 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100036', '123 Main Street, Suite 100036 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100037', '123 Main Street, Suite 100037 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100038', '123 Main Street, Suite 100038 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100039', '123 Main Street, Suite 100039 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100050', '123 Main Street, Suite 100050 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100051', '123 Main Street, Suite 100051 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100052', '123 Main Street, Suite 100052 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100054', '123 Main Street, Suite 100054 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000100055', '123 Main Street, Suite 100055 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200001', '123 Main Street, Suite 200001 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200002', '123 Main Street, Suite 200002 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200007', '123 Main Street, Suite 200007 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200008', '123 Main Street, Suite 200008 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200009', '123 Main Street, Suite 200009 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200010', '123 Main Street, Suite 200010 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200018', '123 Main Street, Suite 200018 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200019', '123 Main Street, Suite 200019 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200020', '123 Main Street, Suite 200020 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200028', '123 Main Street, Suite 200028 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200029', '123 Main Street, Suite 200029 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200030', '123 Main Street, Suite 200030 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200031', '123 Main Street, Suite 200031 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200032', '123 Main Street, Suite 200032 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200033', '123 Main Street, Suite 200033 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200034', '123 Main Street, Suite 200034 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200043', '123 Main Street, Suite 200043 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200044', '123 Main Street, Suite 200044 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200045', '123 Main Street, Suite 200045 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200046', '123 Main Street, Suite 200046 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200049', '123 Main Street, Suite 200049 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200050', '123 Main Street, Suite 200050 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200051', '123 Main Street, Suite 200051 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200052', '123 Main Street, Suite 200052 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000200053', '123 Main Street, Suite 200053 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300001', '123 Main Street, Suite 300001 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300002', '123 Main Street, Suite 300002 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300007', '123 Main Street, Suite 300007 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300008', '123 Main Street, Suite 300008 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300009', '123 Main Street, Suite 300009 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300010', '123 Main Street, Suite 300010 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300017', '123 Main Street, Suite 300017 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300018', '123 Main Street, Suite 300018 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300019', '123 Main Street, Suite 300019 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300020', '123 Main Street, Suite 300020 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300021', '123 Main Street, Suite 300021 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300022', '123 Main Street, Suite 300022 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300023', '123 Main Street, Suite 300023 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300024', '123 Main Street, Suite 300024 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300025', '123 Main Street, Suite 300025 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300026', '123 Main Street, Suite 300026 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300037', '123 Main Street, Suite 300037 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300038', '123 Main Street, Suite 300038 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300039', '123 Main Street, Suite 300039 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300040', '123 Main Street, Suite 300040 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300041', '123 Main Street, Suite 300041 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300042', '123 Main Street, Suite 300042 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300043', '123 Main Street, Suite 300043 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300044', '123 Main Street, Suite 300044 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300049', '123 Main Street, Suite 300049 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300050', '123 Main Street, Suite 300050 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300051', '123 Main Street, Suite 300051 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300052', '123 Main Street, Suite 300052 Anytown USA');
insert into employeeaddress(employeeid, address) values ('000300055', '123 Main Street, Suite 300055 Anytown USA');

select companyid, e.employeeid, hiredate, address
from employee e, employeeaddress ea
where e.employeeid = ea.employeeid
and not exists
 (select *
  from employee ei
  where ei.companyid = e.companyid
  and ei.employeeid = e.employeeid
  and 49 >
    (select count(*) from employee eii
     where eii.companyid = ei.companyid and
     eii.hiredate < ei.hiredate));