INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E1','A','Wong','1','333445555');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E2','B','Wong','2','333445555');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E3','C','Wong','3','333445555');

INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E11','D','Smith','11','1');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E12','E','Smith','12','1');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E21','F','Smith','21','2');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E22','G','Smith','22','2');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E23','H','Smith','23','2');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E31','I','Smith','31','3');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E32','J','Smith','32','3');

INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E111','K','Smith','111','11');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E221','L','Smith','221','22');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E222','M','Smith','222','22');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E223','N','Smith','223','22');

INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E1111','O','Smith','1111','111');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E2211','P','Smith','2211','221');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E2221','Q','Smith','2221','222');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E2231','R','Smith','2231','223');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E2232','S','Smith','2232','223');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E2233','T','Smith','2233','223');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E2234','U','Smith','2234','223');

INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E11111','V','Smith','11111','1111');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E22111','W','Smith','22111','2211');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E22211','X','Smith','22211','2221');

INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E111111','Y','Smith','111111','11111');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E221111','Z','Smith','221111','22111');
INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E222111','A','Smith','222111','22211');

INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E1111111','B','Smith','1111111','111111');

INSERT INTO employee(fname,minit,lname,ssn,superssn) VALUES
  ('E11111111','C','Smith','11111111','1111111');

INSERT INTO works_on VALUES ('111111', 1,  22.5);
INSERT INTO works_on VALUES ('111111', 2,  22.5);
INSERT INTO works_on VALUES ('111111', 3,  22.5);

INSERT INTO works_on VALUES ('11111', 1,  7.5);
INSERT INTO works_on VALUES ('11111', 2,  20.0);
INSERT INTO works_on VALUES ('11111', 3,  10.0);
INSERT INTO works_on VALUES ('11111', 10,  20.0);

INSERT INTO works_on VALUES ('1111', 2,  15.0);
INSERT INTO works_on VALUES ('1111', 3,  15.0);
INSERT INTO works_on VALUES ('1111', 10, 15.0);