text: INSERT INTO employee(ssn, fname, lname, bdate, address, sex, salary, superssn, dno) VALUES (110,'Donald','Oconnell','1959.2.7','YONGIN','M',2600,146,3),(111,'Douglas','Grant','1978.8.17','DALLAS','M',2600,146,2120),(112,'Jennifer','Whalen','1982.3.7','CHICAGO','F',4400,146,2130),(113,'Michael','Hartstein','1958.5.8','BOSTON','M',13000,147,3),(114,'Pat','Fay','1984.7.18','SEOUL','F',6000,147,2120),(115,'Susan','Mavris','1972.1.14','MIAMI','F',6500,147,2130),(116,'Hermann','Baer','1961.2.6','NEW YORK','M',10000,146,2140),(117,'Michael Jordan ','lee','1982.3.4','YONGIN','M',2600,146,3),(118,'Sienna Miller','lee','1979.10.2','DALLAS','M',2600,146,2120),(119,'Cristiano Ronaldo','park','1980.3.2','CHICAGO','M',4400,146,2130),(120,'Lionel Messi','choi','1972.4.5','BOSTON','M',6000,146,2140),(121,'Jisung Park','lee','1980.2.3','SEOUL','M',6500,146,2150),(122,'Michael Bolton','bong','1980.11.3','MIAMI','M',13000,146,2160),(123,'Bon Jovi','sim','1982.5.5','NEW YORK','M',6000,146,3),(124,'Lee Chung Ki','sin','1985.2.1','YONGIN','M',6500,146,2120),(125,'Jonghoon Chun','cho','1979.4.9','SEOUL','M',2600,146,2130),(126,'JongHyun Lim','oh','1987.7.7','YONGIN','M',4400,146,2140),(127,'Adeline','jung','1977.4.25','YONGIN','M',13000,146,2150),(128,'Alexandra','ryu','1983.10.3','DALLAS','M',6000,146,2160),(129,'Althea ','kim','1989.11.15','CHICAGO','F',6500,146,3),(130,'Donna','lee','1989.12.30','BOSTON','M',13000,146,2120),(131,'Darlene','kim','1977.10.24','SEOUL','F',2600,146,2130),(132,'Ellen','song','1975.12.25','MIAMI','F',2600,147,2140),(133,'Janet','kim','1986.2.10','NEW YORK','M',6000,147,2150),(134,'Ethel ','park','1975.8.15','YONGIN','M',6500,147,2160),(135,'Henrietta ','go','1971.6.21','SEOUL','F',2600,147,3),(136,'Genevieve ','jang','1973.2.5','YONGIN','M',2600,147,2120),(137,'Glenda ','lee','1972.9.18','YONGIN','M',6000,147,2130),(138,'Betty ','han','1982.9.23','DALLAS','M',6500,147,2140),(139,'Jeannette','jung','1983.3.12','CHICAGO','F',13000,147,2150),(146,'Jonghoon','Chun','1975.4.6','YONGIN','M',25000,148,2000),(147,'Allan','McEwen','1968.10.25','SEOUL','F',20000,148,2000),(150,'Dorothy','park','1977.9.16','BOSTON','M',2600,147,2160),(151,'Cassandra ','sin','1976.8.23','SEOUL','F',10000,147,3),(152,'Eve','park','1984.7.30','MIAMI','F',4400,147,2120),(153,'Brenda ','jin','1974.7.29','NEW YORK','M',6000,147,2130),(154,'Holly','lee','1968.9.28','YONGIN','M',6500,147,2140),(155,'Charlotte','kim','1969.3.11','SEOUL','F',13000,147,2150),(156,'Jenny ','park','1955.6.25','YONGIN','M',10000,147,2160),(157,'Caren','ha','1968.8.18','YONGIN','M',6000,148,3),(158,'Geraldine ','ha','1978.2.27','DALLAS','M',6500,148,2120),(159,'Kelly','kim','1974.8.5','CHICAGO','F',10000,148,2130),(160,'Charity ','na','1983.6.29','BOSTON','M',13000,148,2140),(161,'Josephine ','jun','1981.5.7','SEOUL','F',2600,148,2150),(162,'Leona ','lee','1979.7.9','MIAMI','F',2600,148,2160),(163,'Marina','ryu','1976.7.19','NEW YORK','M',4400,148,3),(164,'Kimberly','cha','1968.5.4','YONGIN','M',6000,148,2120),(165,'Lavinia ','gong','1985.2.4','SEOUL','F',6500,148,2130),(166,'Madeline','kim','1967.4.14','YONGIN','M',13000,148,2140),(167,'Linda','kang','1965.8.19','YONGIN','M',6000,148,2150),(168,'Lora ','park','1967.9.28','DALLAS','M',10000,148,2160),(169,'Lauren','lee','1979.4.18','CHICAGO','F',13000,148,3),(170,'Mary ','gae','1982.10.2','BOSTON','M',2600,148,2120),(171,'Lisa ','sin','1968.11.21','SEOUL','F',10000,148,2130),(172,'Muriel','ga','1984.3.6','MIAMI','F',2600,147,2140),(173,'Olive','nick','1987.9.23','NEW YORK','M',2600,148,2150),(174,'Rose','jo','1987.2.13','YONGIN','M',2600,147,2160),(175,'Waibel Alexander','han','1981.9.7','SEOUL','M',2600,148,2160);
  INSERT INTO department(dnumber, dname, mgrstartdate, dlocation) VALUES (3,'IT','2005.3.2','SEOUL'),(2000,'Administration','1984.10.11','YONGIN'),(2120,'Marketing','2007.7.24','NEW YORK'),(2130,'Human Resources','1999.2.5','DALLAS'),(2140,'Shipping','2010.1.16','CHICAGO'),(2150,'Sales','2004.11.21','BOSTON'),(2160,'Finance','2001.5.7','MIAMI');
  
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (112,'Jennifer','Whalen','1982.3.7','CHICAGO','F',4400,146,2130,3377,20,2130,'Human Resources','1999.2.5','DALLAS','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (111,'Douglas','Grant','1978.8.17','DALLAS','M',2600,146,2120,3373,30,2120,'Marketing','2007.7.24','NEW YORK','Configurator','DALLAS');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (114,'Pat','Fay','1984.7.18','SEOUL','F',6000,147,2120,3373,17,2120,'Marketing','2007.7.24','NEW YORK','Configurator','DALLAS');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (113,'Michael','Hartstein','1958.5.8','BOSTON','M',13000,147,3,3373,15,3,'IT','2005.3.2','SEOUL','Configurator','DALLAS');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (115,'Susan','Mavris','1972.1.14','MIAMI','F',6500,147,2130,3344,20,2130,'Human Resources','1999.2.5','DALLAS','Application Installer','BOSTON');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (117,'Michael Jordan ','lee','1982.3.4','YONGIN','M',2600,146,3,3321,20,3,'IT','2005.3.2','SEOUL','Atomic FTP Uploads','CHICAGO');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (118,'Sienna Miller','lee','1979.10.2','DALLAS','M',2600,146,2120,3344,20,2120,'Marketing','2007.7.24','NEW YORK','Application Installer','BOSTON');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (119,'Cristiano Ronaldo','park','1980.3.2','CHICAGO','M',4400,146,2130,3373,20,2130,'Human Resources','1999.2.5','DALLAS','Configurator','DALLAS');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (120,'Lionel Messi','choi','1972.4.5','BOSTON','M',6000,146,2140,3377,20,2140,'Shipping','2010.1.16','CHICAGO','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (121,'Jisung Park','lee','1980.2.3','SEOUL','M',6500,146,2150,3388,17,2150,'Sales','2004.11.21','BOSTON','Y','SEOUL');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (122,'Michael Bolton','bong','1980.11.3','MIAMI','M',13000,146,2160,3399,25,2160,'Finance','2001.5.7','MIAMI','CSS Colour and Image Annotator','NEW YORK');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (123,'Bon Jovi','sim','1982.5.5','NEW YORK','M',6000,146,3,3333,22,3,'IT','2005.3.2','SEOUL','HTML Disturbed Link Patcher','DALLAS');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (124,'Lee Chung Ki','sin','1985.2.1','YONGIN','M',6500,146,2120,3311,13,2120,'Marketing','2007.7.24','NEW YORK','Smart Layouts','YONGIN');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (125,'Jonghoon Chun','cho','1979.4.9','SEOUL','M',2600,146,2130,3321,20,2130,'Human Resources','1999.2.5','DALLAS','Atomic FTP Uploads','CHICAGO');
  --INSERT INTO employee(ssn, fname, lname, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (126,'JongHyun Lim','oh','1987.7.7','YONGIN','M',4400,146,2140,3344,30,2140,'Shipping','2010.1.16','CHICAGO','Application Installer','BOSTON');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (128,'Alexandra','ryu','1983.10.3','DALLAS','M',6000,146,2160,3377,15,2160,'Finance','2001.5.7','MIAMI','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (129,'Althea ','kim','1989.11.15','CHICAGO','F',6500,146,3,3388,22,3,'IT','2005.3.2','SEOUL','Y','SEOUL');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (130,'Donna','lee','1989.12.30','BOSTON','M',13000,146,2120,3399,20,2120,'Marketing','2007.7.24','NEW YORK','CSS Colour and Image Annotator','NEW YORK');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (131,'Darlene','kim','1977.10.24','SEOUL','F',2600,146,2130,3333,20,2130,'Human Resources','1999.2.5','DALLAS','HTML Disturbed Link Patcher','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (132,'Ellen','song','1975.12.25','MIAMI','F',2600,147,2140,3311,20,2140,'Shipping','2010.1.16','CHICAGO','Smart Layouts','YONGIN');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (134,'Ethel ','park','1975.8.15','YONGIN','M',6500,147,2160,3344,20,2160,'Finance','2001.5.7','MIAMI','Application Installer','BOSTON');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (136,'Genevieve ','jang','1973.2.5','YONGIN','M',2600,147,2120,3377,25,2120,'Marketing','2007.7.24','NEW YORK','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (137,'Glenda ','lee','1972.9.18','YONGIN','M',6000,147,2130,3388,22,2130,'Human Resources','1999.2.5','DALLAS','Y','SEOUL');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (138,'Betty ','han','1982.9.23','DALLAS','M',6500,147,2140,3399,13,2140,'Shipping','2010.1.16','CHICAGO','CSS Colour and Image Annotator','NEW YORK');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (139,'Jeannette','jung','1983.3.12','CHICAGO','F',13000,147,2150,3333,20,2150,'Sales','2004.11.21','BOSTON','HTML Disturbed Link Patcher','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (150,'Dorothy','park','1977.9.16','BOSTON','M',2600,147,2160,3311,30,2160,'Finance','2001.5.7','MIAMI','Smart Layouts','YONGIN');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (151,'Cassandra ','sin','1976.8.23','SEOUL','F',10000,147,3,3321,17,3,'IT','2005.3.2','SEOUL','Atomic FTP Uploads','CHICAGO');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (153,'Brenda ','jin','1974.7.29','NEW YORK','M',6000,147,2130,3373,22,2130,'Human Resources','1999.2.5','DALLAS','Configurator','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (154,'Holly','lee','1968.9.28','YONGIN','M',6500,147,2140,3377,20,2140,'Shipping','2010.1.16','CHICAGO','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (155,'Charlotte','kim','1969.3.11','SEOUL','F',13000,147,2150,3388,20,2150,'Sales','2004.11.21','BOSTON','Y','SEOUL');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (156,'Jenny ','park','1955.6.25','YONGIN','M',10000,147,2160,3399,17,2160,'Finance','2001.5.7','MIAMI','CSS Colour and Image Annotator','NEW YORK');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (157,'Caren','ha','1968.8.18','YONGIN','M',6000,148,3,3333,25,3,'IT','2005.3.2','SEOUL','HTML Disturbed Link Patcher','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (158,'Geraldine ','ha','1978.2.27','DALLAS','M',6500,148,2120,3311,22,2120,'Marketing','2007.7.24','NEW YORK','Smart Layouts','YONGIN');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (159,'Kelly','kim','1974.8.5','CHICAGO','F',10000,148,2130,3321,13,2130,'Human Resources','1999.2.5','DALLAS','Atomic FTP Uploads','CHICAGO');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (160,'Charity ','na','1983.6.29','BOSTON','M',13000,148,2140,3344,20,2140,'Shipping','2010.1.16','CHICAGO','Application Installer','BOSTON');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (162,'Leona ','lee','1979.7.9','MIAMI','F',2600,148,2160,3377,17,2160,'Finance','2001.5.7','MIAMI','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (163,'Marina','ryu','1976.7.19','NEW YORK','M',4400,148,3,3388,15,3,'IT','2005.3.2','SEOUL','Y','SEOUL');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (164,'Kimberly','cha','1968.5.4','YONGIN','M',6000,148,2120,3399,22,2120,'Marketing','2007.7.24','NEW YORK','CSS Colour and Image Annotator','NEW YORK');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (165,'Lavinia ','gong','1985.2.4','SEOUL','F',6500,148,2130,3333,30,2130,'Human Resources','1999.2.5','DALLAS','HTML Disturbed Link Patcher','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (166,'Madeline','kim','1967.4.14','YONGIN','M',13000,148,2140,3311,17,2140,'Shipping','2010.1.16','CHICAGO','Smart Layouts','YONGIN');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (167,'Linda','kang','1965.8.19','YONGIN','M',6000,148,2150,3321,15,2150,'Sales','2004.11.21','BOSTON','Atomic FTP Uploads','CHICAGO');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (169,'Lauren','lee','1979.4.18','CHICAGO','F',13000,148,3,3373,25,3,'IT','2005.3.2','SEOUL','Configurator','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (170,'Mary ','gae','1982.10.2','BOSTON','M',2600,148,2120,3377,22,2120,'Marketing','2007.7.24','NEW YORK','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (172,'Muriel','ga','1984.3.6','MIAMI','F',2600,147,2140,3399,20,2140,'Shipping','2010.1.16','CHICAGO','CSS Colour and Image Annotator','NEW YORK');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (173,'Olive','nick','1987.9.23','NEW YORK','M',2600,148,2150,3333,30,2150,'Sales','2004.11.21','BOSTON','HTML Disturbed Link Patcher','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (174,'Rose','jo','1987.2.13','YONGIN','M',2600,147,2160,3311,17,2160,'Finance','2001.5.7','MIAMI','Smart Layouts','YONGIN');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (175,'Waibel Alexander','han','1981.9.7','SEOUL','M',2600,148,2160,3311,15,2160,'Finance','2001.5.7','MIAMI','Smart Layouts','YONGIN');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (134,'Ethel ','park','1975.8.15','YONGIN','M',6500,147,2160,3321,20,2160,'Finance','2001.5.7','MIAMI','Atomic FTP Uploads','CHICAGO');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (173,'Olive','nick','1987.9.23','NEW YORK','M',2600,148,2150,3344,17,2150,'Sales','2004.11.21','BOSTON','Application Installer','BOSTON');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (134,'Ethel ','park','1975.8.15','YONGIN','M',6500,147,2160,3373,25,2160,'Finance','2001.5.7','MIAMI','Configurator','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (134,'Ethel ','park','1975.8.15','YONGIN','M',6500,147,2160,3377,22,2160,'Finance','2001.5.7','MIAMI','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (134,'Ethel ','park','1975.8.15','YONGIN','M',6500,147,2160,3388,13,2160,'Finance','2001.5.7','MIAMI','Y','SEOUL');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (134,'Ethel ','park','1975.8.15','YONGIN','M',6500,147,2160,3399,20,2160,'Finance','2001.5.7','MIAMI','CSS Colour and Image Annotator','NEW YORK');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (134,'Ethel ','park','1975.8.15','YONGIN','M',6500,147,2160,3333,30,2160,'Finance','2001.5.7','MIAMI','HTML Disturbed Link Patcher','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (134,'Ethel ','park','1975.8.15','YONGIN','M',6500,147,2160,3311,17,2160,'Finance','2001.5.7','MIAMI','Smart Layouts','YONGIN');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (170,'Mary ','gae','1982.10.2','BOSTON','M',2600,148,2120,3321,15,2120,'Marketing','2007.7.24','NEW YORK','Atomic FTP Uploads','CHICAGO');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (170,'Mary ','gae','1982.10.2','BOSTON','M',2600,148,2120,3344,22,2120,'Marketing','2007.7.24','NEW YORK','Application Installer','BOSTON');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (170,'Mary ','gae','1982.10.2','BOSTON','M',2600,148,2120,3373,20,2120,'Marketing','2007.7.24','NEW YORK','Configurator','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (173,'Olive','nick','1987.9.23','NEW YORK','M',2600,148,2150,3377,20,2150,'Sales','2004.11.21','BOSTON','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (170,'Mary ','gae','1982.10.2','BOSTON','M',2600,148,2120,3388,20,2120,'Marketing','2007.7.24','NEW YORK','Y','SEOUL');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (170,'Mary ','gae','1982.10.2','BOSTON','M',2600,148,2120,3399,20,2120,'Marketing','2007.7.24','NEW YORK','CSS Colour and Image Annotator','NEW YORK');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (170,'Mary ','gae','1982.10.2','BOSTON','M',2600,148,2120,3333,20,2120,'Marketing','2007.7.24','NEW YORK','HTML Disturbed Link Patcher','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (170,'Mary ','gae','1982.10.2','BOSTON','M',2600,148,2120,3311,17,2120,'Marketing','2007.7.24','NEW YORK','Smart Layouts','YONGIN');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (173,'Olive','nick','1987.9.23','NEW YORK','M',2600,148,2150,3321,25,2150,'Sales','2004.11.21','BOSTON','Atomic FTP Uploads','CHICAGO');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (151,'Cassandra ','sin','1976.8.23','SEOUL','F',10000,147,3,3344,22,3,'IT','2005.3.2','SEOUL','Application Installer','BOSTON');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (151,'Cassandra ','sin','1976.8.23','SEOUL','F',10000,147,3,3373,13,3,'IT','2005.3.2','SEOUL','Configurator','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (151,'Cassandra ','sin','1976.8.23','SEOUL','F',10000,147,3,3377,20,3,'IT','2005.3.2','SEOUL','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (151,'Cassandra ','sin','1976.8.23','SEOUL','F',10000,147,3,3388,30,3,'IT','2005.3.2','SEOUL','Y','SEOUL');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (151,'Cassandra ','sin','1976.8.23','SEOUL','F',10000,147,3,3399,17,3,'IT','2005.3.2','SEOUL','CSS Colour and Image Annotator','NEW YORK');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (151,'Cassandra ','sin','1976.8.23','SEOUL','F',10000,147,3,3333,25,3,'IT','2005.3.2','SEOUL','HTML Disturbed Link Patcher','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (151,'Cassandra ','sin','1976.8.23','SEOUL','F',10000,147,3,3311,22,3,'IT','2005.3.2','SEOUL','Smart Layouts','YONGIN');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (155,'Charlotte','kim','1969.3.11','SEOUL','F',13000,147,2150,3321,13,2150,'Sales','2004.11.21','BOSTON','Atomic FTP Uploads','CHICAGO');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (155,'Charlotte','kim','1969.3.11','SEOUL','F',13000,147,2150,3344,20,2150,'Sales','2004.11.21','BOSTON','Application Installer','BOSTON');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (155,'Charlotte','kim','1969.3.11','SEOUL','F',13000,147,2150,3373,30,2150,'Sales','2004.11.21','BOSTON','Configurator','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (155,'Charlotte','kim','1969.3.11','SEOUL','F',13000,147,2150,3377,17,2150,'Sales','2004.11.21','BOSTON','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (173,'Olive','nick','1987.9.23','NEW YORK','M',2600,148,2150,3388,15,2150,'Sales','2004.11.21','BOSTON','Y','SEOUL');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (155,'Charlotte','kim','1969.3.11','SEOUL','F',13000,147,2150,3399,22,2150,'Sales','2004.11.21','BOSTON','CSS Colour and Image Annotator','NEW YORK');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (155,'Charlotte','kim','1969.3.11','SEOUL','F',13000,147,2150,3333,20,2150,'Sales','2004.11.21','BOSTON','HTML Disturbed Link Patcher','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (155,'Charlotte','kim','1969.3.11','SEOUL','F',13000,147,2150,3311,20,2150,'Sales','2004.11.21','BOSTON','Smart Layouts','YONGIN');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (164,'Kimberly','cha','1968.5.4','YONGIN','M',6000,148,2120,3321,20,2120,'Marketing','2007.7.24','NEW YORK','Atomic FTP Uploads','CHICAGO');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (164,'Kimberly','cha','1968.5.4','YONGIN','M',6000,148,2120,3344,20,2120,'Marketing','2007.7.24','NEW YORK','Application Installer','BOSTON');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (164,'Kimberly','cha','1968.5.4','YONGIN','M',6000,148,2120,3373,20,2120,'Marketing','2007.7.24','NEW YORK','Configurator','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (164,'Kimberly','cha','1968.5.4','YONGIN','M',6000,148,2120,3377,17,2120,'Marketing','2007.7.24','NEW YORK','Domain Registry ','MIAMI');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (164,'Kimberly','cha','1968.5.4','YONGIN','M',6000,148,2120,3388,25,2120,'Marketing','2007.7.24','NEW YORK','Y','SEOUL');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (173,'Olive','nick','1987.9.23','NEW YORK','M',2600,148,2150,3399,22,2150,'Sales','2004.11.21','BOSTON','CSS Colour and Image Annotator','NEW YORK');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (164,'Kimberly','cha','1968.5.4','YONGIN','M',6000,148,2120,3333,13,2120,'Marketing','2007.7.24','NEW YORK','HTML Disturbed Link Patcher','DALLAS');
  --INSERT INTO employee(ssn, fname, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO, PNUMBER, HOURS, DNUMBER, DNAME, MGRSTARTDATE, DLOCATION, PNAME, PLOCATION) values (164,'Kimberly','cha','1968.5.4','YONGIN','M',6000,148,2120,3311,20,2120,'Marketing','2007.7.24','NEW YORK','Smart Layouts','YONGIN');
  