Insert Query.sql

-- Creating and populating tblEmployee


INSERT INTO Employee ( Emp_id, EmpFirstName, EmpMiddleName, EmpLastName, EmpGovernmentID, DateOfBirth, Department) 
     VALUES 	(123, 'Jane', NULL, 'Zwilling', 'AB123456G', '1985-01-01', 'Customer Relations'),
	(124, 'Carolyn', 'Andrea', 'Zimmerman', 'AB234578H', '1975-06-01', 'Commercial'),
	(125, 'Jane', NULL, 'Zabokritski', 'LU778728T', '1977-12-09', 'Commercial'),
	(126, 'Ken', 'J', 'Yukish', 'PO201903O', '1969-12-27', 'HR'),
	(127, 'Terri', 'Lee', 'Yu', 'ZH206496W', '1986-11-14', 'Customer Relations'),
	(128, 'Roberto', NULL, 'Young', 'EH793082D', '1967-04-05', 'Customer Relations'),
	(129, 'Rob', NULL, 'Yalovsky', 'WF039886Z', '1981-08-31', 'Litigation'),
	(130, 'Gail', 'A', 'Wu', 'SR883921U', '1972-02-19', 'HR'),
	(131, 'Jossef', 'H', 'Wright', 'FU781952O', '1980-08-01', 'Commercial'),
	(132, 'Dylan', 'A', 'Word', 'SU416128W', '1989-11-28', 'Customer Relations'),
	(133, 'Diane', 'L', 'Wood', 'MF594311S', '1970-12-10', 'Commercial'),
	(134, 'Gigi', 'N', 'Wilson', 'ZQ071470Z', '1980-01-15', 'Customer Relations'),
	(135, 'Michael', NULL, 'Williams', 'OV366977J', '1980-09-15', 'HR'),
	(136, 'Ovidiu', 'V', 'Welcker', 'UM830485R', '1988-10-12', 'Commercial'),
	(137, 'Thierry', 'B', 'Wedge', 'GE056775L', '1988-08-11', 'Commercial'),
	(138, 'Janice', 'M', 'Watters', 'QG194296A', '1990-07-30', 'Commercial'),
	(139, 'Michael', 'I', 'Wang', 'BM792963U', '1968-07-13', 'Customer Relations'),
	(140, 'Sharon', 'B', 'Walton', 'SA071422P', '1968-10-17', 'Commercial'),
	(141, 'David', 'M', 'Walters', 'JW703438O', '1970-10-22', 'Customer Relations'),
	(142, 'Kevin', 'F', 'Vong', 'HA567992P', '1989-08-16', 'Customer Relations'),
	(143, 'John', 'L', 'Varkey Chudukatil', 'HC853020N', '1980-11-02', 'Litigation'),
	(144, 'Mary', 'A', 'Vargas', 'JJ995138N', '1979-10-18', 'HR'),
	(145, 'Wanida', 'M', 'Vanderhyde', 'BC456441N', '1992-02-01', 'Commercial'),
	(146, 'Terry', 'J', 'Vande Velde', 'HC364512Q', '1987-11-12', 'Customer Relations'),
	(147, 'Sariya', 'E', 'Valdez', 'GB370569V', '1971-07-26', 'Commercial'),
	(148, 'Mary', 'E', 'Valdez', 'WP346718G', '1974-11-16', 'Litigation'),
	(149, 'Jill', 'A', 'Uddin', 'JP544067O', '1990-08-04', 'Customer Relations'),
	(150, 'James', 'R', 'Turner', 'BR544348B', '1970-06-15', 'HR'),
	(151, 'Peter', 'J', 'Tsoflias', 'PS031251Z', '1970-09-22', 'Litigation'),
	(152, 'Jo', 'A', 'Trenary', 'YF329015Z', '1987-10-28', 'HR'),
	(153, 'Guy', 'R', 'Tomic', 'AA327196C', '1975-05-09', 'Customer Relations'),
	(154, 'Mark', 'K', 'Ting', 'SC568031A', '1972-09-12', 'Commercial'),
	(155, 'Britta', 'L', 'Tiedt', 'UR891641O', '1976-11-14', 'Customer Relations'),
	(156, 'Margie', 'W', 'Tibbott', 'WZ431413L', '1990-12-29', 'Commercial'),
	(157, 'Rebecca', 'A', 'Tejani', 'MB889927Z', '1967-06-21', 'HR'),
	(158, 'Annik', 'O', 'Tamburello', 'YX712825J', '1987-02-16', 'HR'),
	(159, 'Suchitra', 'O', 'Sunkammurali', 'GO107833S', '1978-07-26', 'Customer Relations'),
	(160, 'Brandon', 'G', 'Sullivan', 'KI423518P', '1969-04-14', 'Commercial'),
	(161, 'Jose', 'R', 'Su', 'RA831250L', '1986-05-21', 'Commercial'),
	(162, 'Chris', 'O', 'Steele', 'QE827695A', '1994-04-06', 'Customer Relations'),
	(163, 'Kim', 'B', 'Stahl', 'FU098115B', '1983-10-15', 'HR'),
	(164, 'Ed', 'R', 'Stadick', 'AR855935J', '1981-12-23', 'Customer Relations'),
	(165, 'JoLynn', 'M', 'Spoon', 'FH267421E', '1982-10-07', 'Litigation'),
	(166, 'Bryan', NULL, 'Sousa', 'RY783836I', '1978-04-30', 'Commercial'),
	(167, 'James', 'D', 'Song', 'QK335062S', '1981-07-19', 'Litigation'),
	(168, 'Nancy', 'A', 'Smith', 'KK563253K', '1966-12-10', 'Commercial'),
	(169, 'Simon', 'D', 'Smith', 'FU586271D', '1984-05-16', 'Litigation'),
	(170, 'Thomas', 'R', 'Smith', 'AP079315D', '1970-01-13', 'HR'),
	(171, 'Eugene', 'O', 'Smith', 'ZN301297L', '1970-03-26', 'HR'),
	(172, 'Andrew', 'R', 'Smith', 'RU424844O', '1976-02-18', 'HR'),
	(173, 'Ruth', 'Ann', 'Smith', 'NA760925P', '1990-02-05', 'Litigation'),
	(174, 'Barry', 'K', 'Singh', 'XX675669J', '1991-11-05', 'Commercial'),
	(175, 'Sidney', 'M', 'Simon', 'UX037427K', '1975-05-20', 'Commercial'),
	(176, 'Jeffrey', 'L', 'Shoop', 'YF178043W', '1981-06-07', 'Litigation'),
	(177, 'Doris', 'M', 'Sheperdigian', 'ON477598X', '1979-04-28', 'Commercial'),
	(178, 'Diane', 'R', 'Sharma', 'IV001488G', '1974-04-08', 'Customer Relations'),
	(179, 'Bonnie', 'N', 'Shabalin', 'SY920270U', '1971-06-01', 'Commercial'),
	(180, 'Taylor', 'R', 'Selikoff', 'JX287207O', '1983-06-03', 'Litigation'),
	(181, 'Denise', 'H', 'Seamans', 'GJ414243K', '1967-11-09', 'Customer Relations'),
	(182, 'Frank', 'T', 'Scardelis', 'AU270589J', '1969-04-28', 'HR'),
	(183, 'Kendall', 'C', 'Saraiva', 'IQ768024J', '1992-03-17', 'Customer Relations'),
	(184, 'Bob', 'N', 'Sandberg', 'WR095338D', '1989-10-26', 'Litigation'),
	(185, 'Pete', 'C', 'Sánchez', 'RO623911G', '1993-03-30', 'HR'),
	(186, 'Diane', 'H', 'Samarawickrama', 'WK839526U', '1968-11-12', 'Customer Relations'),
	(187, 'John', 'T', 'Samant', 'XS703927P', '1966-10-24', 'Commercial'),
	(188, 'Maciej', 'W', 'Sam', 'HA443152A', '1994-01-31', 'Customer Relations'),
	(189, 'Michael', 'J', 'Salmre', 'IF576121L', '1988-07-08', 'Customer Relations'),
	(190, 'Randy', 'T', 'Salavaria', 'OB958801K', '1977-08-15', 'Litigation'),
	(191, 'Karan', 'R', 'Sacksteder', 'GL208415K', '1986-06-12', 'Litigation'),
	(192, 'Jay', 'G', 'Ruth', 'SU217027D', '1986-09-28', 'HR'),
	(193, 'Charles', 'B', 'Rounthwaite', 'WQ237019J', '1991-10-18', 'HR'),
	(194, 'Steve', 'F', 'Rothkugel', 'YL673909Y', '1986-01-28', 'Commercial'),
	(195, 'David', 'J', 'Rodman', 'SI132036J', '1972-04-07', 'Litigation'),
	(196, 'Michael', 'Sean', 'Rodgers', 'NI641299B', '1982-07-26', 'Litigation'),
	(197, 'Steven', 'T', 'Rockne', 'MM990626R', '1969-12-26', 'HR'),
	(198, 'Carole', 'M', 'Robinson', 'LA586100J', '1966-08-01', 'Commercial'),
	(199, 'Bjorn', 'M', 'Robinson', 'MS873892G', '1977-03-10', 'HR'),
	(200, 'Michiko', 'F', 'Robinett', 'FU588676X', '1981-12-23', 'HR'),
	(201, 'Carol', 'M', 'Roberts', 'QX474508L', '1991-06-25', 'Litigation'),
	(202, 'Merav', 'A', 'Rizzi', 'FS933541U', '1988-03-16', 'Commercial'),
	(203, 'Reuben', 'H', 'Richter', 'CE492472U', '1976-12-15', 'Customer Relations'),
	(204, 'Eric', 'L', 'Richmeier', 'GI672952C', '1970-10-18', 'Litigation'),
	(205, 'Sandeep', 'P', 'Richins', 'WQ734683W', '1969-03-27', 'Customer Relations'),
	(206, 'Mihail', 'U', 'Richins', 'AT855605R', '1981-06-22', 'Litigation'),
	(207, 'Jack', 'T', 'Richards', 'ML487121S', '1980-06-11', 'Commercial'),
	(208, 'Patrick', 'M', 'Richards', 'PH151087Y', '1985-01-31', 'Customer Relations'),
	(209, 'Frank', 'R', 'Rhodes', 'GW931567T', '1981-04-01', 'Customer Relations'),
	(210, 'Brian', 'Richard', 'Rhodes', 'HK672162G', '1967-07-10', 'Commercial'),
	(211, 'Ryan', 'L', 'Reynolds', 'SN571717M', '1975-03-30', 'Commercial'),
	(212, 'Cristian', 'K', 'Rettig', 'GR737860U', '1987-04-11', 'HR'),
	(213, 'Betsy', 'A', 'Remmington', 'MG422105J', '1977-12-17', 'Customer Relations'),
	(214, 'Patrick', 'C', 'Remick', 'AA745935J', '1970-03-04', 'HR'),
	(215, 'Danielle', 'C', 'Reiter', 'EC012012X', '1975-05-09', 'HR'),
	(216, 'Kimberly', 'B', 'Reeves', 'JC715470Z', '1979-08-14', 'Litigation'),
	(217, 'Tom', 'M', 'Reeves', 'CG625194N', '1992-04-21', 'HR'),
	(218, 'Kok-Ho', 'T', 'Reed', 'QM827526U', '1987-06-08', 'HR'),
	(219, 'Russell', NULL, 'Reed', 'CW347088A', '1989-11-06', 'HR'),
	(220, 'Jim', 'H', 'Reding', 'NY480363H', '1988-12-23', 'Litigation'),
	(221, 'Elizabeth', 'I', 'Rector', 'KP298792T', '1977-05-11', 'Customer Relations'),
	(222, 'Mandar', 'H', 'Reátegui Alayo', 'RA549593S', '1986-07-16', 'Customer Relations');
INSERT INTO Employee ( Emp_id, EmpFirstName, EmpMiddleName, EmpLastName, EmpGovernmentID, DateOfBirth, Department) 
 VALUES 	(223, 'Sameer', 'A', 'Reams', 'YG615891A', '1972-12-03', 'HR'),
	(224, 'Nuan', NULL, 'Ray', 'ND117517F', '1978-11-20', 'Litigation'),
	(225, 'Lolan', 'B', 'Ray', 'SK649995H', '1980-10-26', 'Litigation'),
	(226, 'Houman', 'N', 'Rapier', 'AM866046T', '1980-07-04', 'Commercial'),
	(227, 'Zheng', 'W', 'Rapier', 'JB411618S', '1970-03-11', 'Litigation'),
	(228, 'Ebru', 'N', 'Rao', 'SC540325S', '1988-02-27', 'HR'),
	(229, 'Mary', 'R', 'Rao', 'TI717406L', '1986-06-22', 'Litigation'),
	(230, 'Kevin', 'M', 'Randall', 'ZH651560A', '1978-05-07', 'Customer Relations'),
	(231, 'John', 'T', 'Randall', 'KZ709454P', '1973-08-03', 'Litigation'),
	(232, 'Christopher', 'E', 'Randall', 'GK886830E', '1984-10-13', 'HR'),
	(233, 'Jinghao', 'K', 'Ramos', 'PH768497F', '1982-07-18', 'HR'),
	(234, 'Alice', 'O', 'Ralls', 'NN434556K', '1968-10-17', 'Litigation'),
	(235, 'Jun', 'T', 'Ralls', 'LI040384W', '1984-01-12', 'Litigation'),
	(236, 'Suroor', 'R', 'Raheem', 'XA357061W', '1991-07-17', 'Commercial'),
	(237, 'John', 'P', 'Quintana', 'FC275045Q', '1974-07-07', 'Litigation'),
	(238, 'Linda', 'K', 'Quintana', 'FM512571D', '1985-05-01', 'Litigation'),
	(239, 'Mindaugas', 'J', 'Purcell', 'HT765655S', '1970-08-05', 'HR'),
	(240, 'Angela', 'W', 'Pugh', 'DJ470629J', '1982-02-18', 'Litigation'),
	(241, 'Michael', 'W', 'Price', 'ZL793802F', '1975-02-18', 'Litigation'),
	(242, 'Chad', 'W', 'Preston', 'HS184360Y', '1989-10-20', 'Commercial'),
	(243, 'Don', 'L', 'Preston', 'TW819126B', '1974-08-10', 'Commercial'),
	(244, 'Michael', 'T', 'Pournasseh', 'UR929065D', '1982-02-01', 'Commercial'),
	(245, 'Kitti', 'H', 'Potts', 'RW333854L', '1992-05-04', 'Customer Relations'),
	(246, 'Pilar', 'G', 'Posner', 'RP789319Y', '1987-11-11', 'Customer Relations'),
	(247, 'Susan', 'W', 'Porter', 'ZO581568G', '1994-02-18', 'Litigation'),
	(248, 'Vamsi', 'N', 'Porter', 'RH703735B', '1973-12-27', 'Customer Relations'),
	(249, 'Kim', 'T', 'Poorbaugh', 'NJ860316M', '1986-03-05', 'Commercial'),
	(250, 'Matthias', 'T', 'Pompa', 'LX772351W', '1972-04-26', 'Litigation'),
	(251, 'Jimmy', 'T', 'Pollock', 'PK276903A', '1973-09-23', 'Customer Relations'),
	(252, 'David', 'P', 'Poland', 'GB292840S', '1993-02-10', 'Commercial'),
	(253, 'Paul', 'B', 'Poland', 'CX993916W', '1977-07-28', 'Customer Relations'),
	(254, 'Gary', 'W', 'Pogulsky', 'SA636072H', '1972-05-24', 'Customer Relations'),
	(255, 'Rob', 'T', 'Poe', 'PQ895161T', '1994-03-18', 'Litigation'),
	(256, 'Baris', 'F', 'Poe', 'AU964816Y', '1966-07-09', 'Commercial'),
	(257, 'Nicole', 'B', 'Pinto', 'YY859015L', '1993-09-03', 'HR'),
	(258, 'Michael', 'L', 'Pinkston', 'CT732927U', '1966-01-05', 'Commercial'),
	(259, 'Eric', NULL, 'Philips', 'WZ443467Z', '1973-07-08', 'HR'),
	(260, 'Ivo', 'William', 'Philips', 'ZW022113Z', '1976-07-26', 'Commercial'),
	(261, 'Sylvester', 'A', 'Pettengill', 'WW746868C', '1984-10-02', 'Commercial'),
	(262, 'Anibal', 'T', 'Peterson', 'VU920256D', '1974-12-11', 'Customer Relations'),
	(263, 'Samantha', 'H', 'Peters', 'EI963658C', '1980-06-29', 'HR'),
	(264, 'Hung-Fu', 'T', 'Petculescu', 'CZ960714K', '1991-03-17', 'Commercial'),
	(265, 'Prasanna', 'E', 'Perko', 'LT390489X', '1982-08-22', 'Litigation'),
	(266, 'Min', 'G', 'Perera', 'AU901464Z', '1973-04-08', 'HR'),
	(267, 'Olinda', 'C', 'Peoples', 'QR897308Y', '1977-08-22', 'Customer Relations'),
	(268, 'Krishna', NULL, 'Peoples', 'CM554364N', '1992-11-09', 'Litigation'),
	(269, 'Paul', 'R', 'Penuchot', 'GK110938D', '1981-09-13', 'HR'),
	(270, 'Cynthia', 'S', 'Penuchot', 'PH373860L', '1978-05-11', 'Litigation'),
	(271, 'Jian Shuo', NULL, 'Penor', 'ZR192112Z', '1989-02-18', 'Commercial'),
	(272, 'Sandra', NULL, 'Pellow', 'MP748399N', '1975-05-11', 'Commercial'),
	(273, 'Jason', 'M', 'Pellow', 'LF044303H', '1975-01-22', 'Customer Relations'),
	(274, 'Andy', 'M', 'Pederson', 'YK835341N', '1972-04-12', 'HR'),
	(275, 'Michael', 'T', 'Patten', 'QH580920P', '1967-06-06', 'HR'),
	(276, 'Rostislav', 'E', 'Patten', 'MU608808O', '1975-04-12', 'HR'),
	(277, 'Yuhong', 'L', 'Pather', 'UQ790735F', '1982-01-04', 'Customer Relations'),
	(278, 'Hanying', 'P', 'Patel', 'XD324192E', '1969-03-07', 'Litigation'),
	(279, 'Raymond', 'K', 'Patel', 'KA832378H', '1970-12-07', 'Commercial'),
	(280, 'Fadi', 'K', 'Park', 'JZ001131Q', '1993-09-19', 'Litigation'),
	(281, 'Lane', 'M', 'Pak', 'XI744325C', '1966-03-22', 'Customer Relations'),
	(282, 'Linda', 'A', 'Pai', 'FV616018T', '1974-10-06', 'Customer Relations'),
	(283, 'Shelley', 'N', 'Oviatt', 'HO986911C', '1985-02-09', 'HR'),
	(284, 'Terrence', 'W', 'Oveson', 'MA204130V', '1987-04-07', 'Litigation'),
	(285, 'Jeff', 'V', 'Osorio', 'LQ049157Q', '1980-04-05', 'Commercial'),
	(286, 'Kirk', 'J', 'Osborn', 'KK553556R', '1982-02-03', 'HR'),
	(287, 'Laura', 'C', 'Osada', 'VB289488Z', '1975-06-01', 'Litigation'),
	(288, 'Alex', 'M', 'Osada', 'DD374841L', '1979-05-05', 'Litigation'),
	(289, 'Andrew', 'M', 'Ortiz', 'OZ039664I', '1976-11-11', 'Commercial'),
	(290, 'Chris', 'T', 'Ortiz', 'ND888679U', '1988-02-04', 'Litigation'),
	(291, 'Jack', 'S', 'Ortiz', 'LL343666X', '1970-10-11', 'Litigation'),
	(292, 'David', 'N', 'Ortiz', 'SN532038Q', '1976-01-20', 'HR'),
	(293, 'Garrett', 'R', 'Orona', 'QO787401K', '1977-12-14', 'Customer Relations'),
	(294, 'Susan', 'A', 'Orman', 'MO580458R', '1966-03-23', 'Commercial'),
	(295, 'George', 'Z', 'Olivotto', 'HY924529A', '1986-05-30', 'Litigation'),
	(296, 'David', 'A', 'Olguin', 'ZV172930Z', '1968-05-07', 'HR'),
	(297, 'Marc', 'J', 'Okelberry', 'RR256994D', '1988-03-04', 'Customer Relations'),
	(298, 'Eugene', 'R', 'O''Hara', 'NM819987N', '1987-05-26', 'Commercial'),
	(299, 'Benjamin', 'R', 'Ogisu', 'OT086299T', '1975-11-03', 'Customer Relations'),
	(300, 'Reed', 'T', 'O''Dell', 'VL412247Y', '1984-06-06', 'Litigation'),
	(301, 'David', 'Oliver', 'O''Connell', 'HZ405123P', '1968-09-20', 'Customer Relations'),
	(302, 'Russell', 'M', 'O''Brien', 'EZ129095R', '1979-02-11', 'Customer Relations'),
	(303, 'John', 'N', 'Nusbaum', 'UN164874N', '1968-11-11', 'Litigation'),
	(304, 'Jan', 'S', 'Northup', 'TS562783H', '1987-09-23', 'Commercial'),
	(305, 'Katie', 'L', 'Northup', 'TQ646527J', '1967-08-02', 'Litigation'),
	(306, 'Michael', 'T', 'Norred', 'JN963479H', '1967-10-19', 'HR'),
	(307, 'Nitin', 'S', 'Norman', 'OC255205P', '1981-12-15', 'Litigation'),
	(308, 'Barbara', 'S', 'Norman', 'XO300911I', '1991-06-11', 'Litigation'),
	(309, 'John', 'Y', 'Nixon', 'NO932055Z', '1993-04-26', 'Customer Relations'),
	(310, 'Stefen', 'A', 'Niswonger', 'ZE648808G', '1978-08-20', 'Litigation'),
	(311, 'Shane', 'S', 'Nilson', 'HT054267D', '1977-03-15', 'Litigation'),
	(312, 'Yvonne', 'S', 'Newman', 'KR399457K', '1970-05-14', 'Commercial'),
	(313, 'Douglas', 'B', 'Netz', 'FO694910M', '1990-03-09', 'Customer Relations'),
	(314, 'Janeth', 'M', 'Netz', 'UO942878M', '1988-11-19', 'Commercial'),
	(315, 'Robert', 'J', 'Nelson', 'CG190765E', '1981-11-25', 'Litigation'),
	(316, 'Lionel', 'C', 'Nelsen', 'WR558489F', '1969-12-20', 'Litigation'),
	(317, 'Brenda', 'M', 'Nayberg', 'DO284313U', '1971-02-20', 'HR'),
	(318, 'Alejandro', 'E', 'Nayberg', 'NE097774R', '1967-10-17', 'HR'),
	(319, 'Fred', 'T', 'Nay', 'IM995961W', '1987-11-30', 'Commercial'),
	(320, 'Kevin', 'H', 'Nay', 'ZK847878W', '1989-02-20', 'Commercial'),
	(321, 'Shammi', 'G', 'Nash', 'EW458203L', '1968-04-27', 'HR'),
	(322, 'Rajesh', 'M', 'Nartker', 'JB783423G', '1987-12-31', 'HR');
INSERT INTO [dbo].[tblEmployee] ( [EmployeeNumber], [EmployeeFirstName], [EmployeeMiddleName], [EmployeeLastName], [EmployeeGovernmentID], [DateOfBirth], [Department]) VALUES 	(323, 'Lorraine', 'O', 'Naik', 'LY344333R', '1975-03-06', 'Customer Relations'),
	(324, 'Paula', 'R', 'Myer', 'UM375041E', '1985-03-12', 'Commercial'),
	(325, 'Frank', 'T', 'Myer', 'RM433520A', '1970-01-28', 'Commercial'),
	(326, 'Brian', 'T', 'Myer', 'NJ837536J', '1979-12-15', 'HR'),
	(327, 'Tawana', 'G', 'Murray', 'KF558209L', '1984-12-04', 'HR'),
	(328, 'Ken', 'L', 'Munson', 'WY111892C', '1979-06-13', 'Commercial'),
	(329, 'Gabe', 'B', 'Munson', 'IH193140I', '1981-04-06', 'Litigation'),
	(330, 'Lori', 'A', 'Mungin', 'WR639349T', '1985-12-05', 'Commercial'),
	(331, 'Stuart', 'V', 'Mughal', 'EX456780U', '1986-10-24', 'Customer Relations'),
	(332, 'Greg', 'F', 'Mu', 'UU417076U', '1979-12-26', 'Commercial'),
	(333, 'Scott', 'R', 'Mu', 'HE276747M', '1969-11-25', 'Customer Relations'),
	(334, 'Kathie', 'E', 'Moya', 'PF404453T', '1974-10-28', 'Litigation'),
	(335, 'Belinda', 'M', 'Moseley', 'LR982813D', '1974-08-16', 'Litigation'),
	(336, 'Hazem', 'E', 'Moschell', 'HV244764I', '1982-02-01', 'Customer Relations'),
	(337, 'Peng', 'J', 'Morris', 'AR850926O', '1991-11-29', 'HR'),
	(338, 'Sootha', 'T', 'Moreland', 'NR574916Z', '1981-11-15', 'Customer Relations'),
	(339, 'Andreas', 'T', 'Moreland', 'VM291445T', '1993-11-02', 'Customer Relations'),
	(340, 'Mark', 'L', 'Moore', 'LN831561X', '1988-08-05', 'HR'),
	(341, 'Sean', 'P', 'Montera', 'RY686119B', '1968-07-06', 'Commercial'),
	(342, 'Zainal', 'T', 'Monroe', 'GA025362V', '1980-02-17', 'HR'),
	(343, 'Tengiz', 'N', 'Monitor', 'XJ612479F', '1968-12-24', 'Litigation'),
	(344, 'Sean', 'N', 'Mohan', 'WK803868K', '1968-10-02', 'Commercial'),
	(345, 'Karen', 'R', 'Mohan', 'ER008587V', '1985-05-25', 'HR'),
	(346, 'Chris', 'K', 'Mohamed', 'LR083676G', '1991-11-11', 'HR'),
	(347, 'A. Scott', NULL, 'Mohamed', 'ZK918198D', '1969-10-26', 'HR'),
	(348, 'Sairaj', 'L', 'Moeller', 'AN827627L', '1984-03-26', 'Litigation'),
	(349, 'William', 'S', 'Moberly', 'HP478620Y', '1984-04-07', 'Customer Relations'),
	(350, 'Alan', 'J', 'Mitzner', 'XY414517N', '1967-05-31', 'HR'),
	(351, 'Brian', 'P', 'Mitosinka', 'HN879180K', '1991-04-03', 'Commercial'),
	(352, 'Gary', 'E.', 'Mitchell', 'ZG909295K', '1970-08-09', 'Commercial'),
	(353, 'Christian', 'E', 'Mitchell', 'WB795754S', '1988-07-30', 'Litigation'),
	(354, 'Lori', 'K', 'Mitchell', 'YN456694H', '1981-10-02', 'Litigation'),
	(355, 'Stuart', 'J', 'Mitchell', 'XV597618Z', '1990-04-14', 'HR'),
	(356, 'Jo', 'L', 'Mirchandani', 'YR666452M', '1987-07-08', 'Customer Relations'),
	(357, 'Pat', 'H', 'Miller', 'SK449263Q', '1984-03-26', 'HR'),
	(358, 'Magnus', 'E', 'Miller', 'KU007033Q', '1980-05-24', 'HR'),
	(359, 'Laura', 'F', 'Miller', 'YQ300005J', '1972-12-14', 'Litigation'),
	(360, 'Paula', 'M', 'Miller', 'WK473364H', '1974-02-05', 'Commercial'),
	(361, 'Grant', 'N', 'Miller', 'LZ710576J', '1984-02-03', 'Litigation'),
	(362, 'Hao', 'O', 'Miller', 'OS160801L', '1978-02-18', 'Customer Relations'),
	(363, 'Vidur', 'X', 'Miller', 'KA189807X', '1976-12-02', 'Commercial'),
	(364, 'Mindy', 'C', 'Miller', 'AN363838D', '1993-03-18', 'HR'),
	(365, 'Willis', 'T', 'Miller', 'NU353125Q', '1992-06-21', 'Commercial'),
	(366, 'David', 'J', 'Miksovsky', 'WJ235501N', '1989-11-24', 'Litigation'),
	(367, 'Deborah', 'E', 'Miksovsky', 'NP856098E', '1986-01-12', 'Customer Relations'),
	(368, 'Candy', 'L', 'Michaels', 'ZM566138W', '1971-07-07', 'Commercial'),
	(369, 'Bryan', 'A', 'Michaels', 'AU509601O', '1985-02-21', 'Customer Relations'),
	(370, 'Barbara', 'C', 'Meyyappan', 'UX216321S', '1968-08-30', 'HR'),
	(371, 'Dragan', 'K', 'Meyyappan', 'KF601808O', '1983-04-24', 'Customer Relations'),
	(372, 'Janet', 'L', 'Meyerhoff', 'FC728012I', '1967-07-09', 'HR'),
	(373, 'Mike', 'K', 'Meyer', 'TN682753R', '1977-01-23', 'Litigation'),
	(374, 'Wendy', 'Beth', 'Meyer', 'EE715775L', '1983-04-21', 'Litigation'),
	(375, 'Sheela', 'H', 'Meyer', 'IZ459698P', '1978-08-28', 'Litigation'),
	(376, 'Mikael', 'Q', 'Mew', 'HL317503R', '1973-01-18', 'Commercial'),
	(377, 'Arvind', 'B', 'Metters', 'SM817536T', '1969-04-08', 'Commercial'),
	(378, 'Linda', 'P', 'Metters', 'KQ021581P', '1969-12-12', 'Litigation'),
	(379, 'Fukiko', 'J', 'Meston', 'ZL641657L', '1975-01-08', 'Customer Relations'),
	(380, 'Gordon', 'L', 'Mensa-Annan', 'KI101419Q', '1978-09-16', 'HR'),
	(381, 'Frank', 'S', 'Mendoza', 'FM080945P', '1968-06-28', 'HR'),
	(382, 'Eric', 'S', 'Mendiola', 'ZN053524C', '1975-03-17', 'HR'),
	(383, 'Erin', 'M', 'Mello', 'HG710967X', '1993-03-08', 'Litigation'),
	(384, 'Ben', 'T', 'Meisner', 'UM436476P', '1968-07-03', 'Litigation'),
	(385, 'Annette', 'L', 'Medina', 'TV928911M', '1967-12-08', 'Litigation'),
	(386, 'Reinout', 'N', 'McPhearson', 'LE508409U', '1974-12-03', 'Commercial'),
	(387, 'David', 'M', 'McLin', 'FC062825X', '1966-02-19', 'Commercial'),
	(388, 'Jean', 'E', 'McKay', 'KC412516R', '1968-07-17', 'Commercial'),
	(389, 'Stephanie', 'A', 'McKay', 'NJ542300N', '1986-06-30', 'Litigation'),
	(390, 'Ashvini', 'R', 'McGuigan', 'GU225465H', '1989-08-27', 'Customer Relations'),
	(391, 'Peter', 'I', 'McGuel', 'SV842894H', '1969-09-11', 'Customer Relations'),
	(392, 'Karen', 'A', 'McGuel', 'KQ376977T', '1993-09-16', 'Commercial'),
	(393, 'Ramesh', 'V', 'McDonald', 'WT659700L', '1992-03-30', 'Customer Relations'),
	(394, 'Dan', 'K', 'McCoy', 'OI168725L', '1970-01-27', 'Litigation'),
	(395, 'François', 'P', 'McCormick', 'HG689275V', '1986-01-04', 'Litigation'),
	(396, 'Dan', 'B', 'McClane', 'TN638360B', '1977-11-12', 'Customer Relations'),
	(397, 'Janaina', 'Barreiro Gambaro', 'McCarty', 'QE338418G', '1975-10-06', 'Customer Relations'),
	(398, 'Brian', 'S', 'McCarthy', 'PW349198I', '1975-11-12', 'Commercial'),
	(399, 'Stephen', 'Y', 'McAskill-White', 'VY423156F', '1992-03-14', 'Customer Relations'),
	(400, 'Michael', 'G', 'McAskill-White', 'WU716313J', '1978-12-29', 'Litigation'),
	(401, 'Linda', 'C', 'McArthur', 'GK923986G', '1989-08-02', 'Commercial'),
	(402, 'Jillian', NULL, 'Mcanich', 'EM073294X', '1991-04-21', 'Litigation'),
	(403, 'Garrett', 'R', 'Mays', 'KN016551I', '1986-06-18', 'Commercial'),
	(404, 'Tsvi', 'Michael', 'Maynard', 'UQ356763K', '1978-05-11', 'Customer Relations'),
	(405, 'Pamela', 'O', 'Maxwell', 'QQ624243U', '1981-06-28', 'Customer Relations'),
	(406, 'Shu', 'K', 'Maxwell', 'RR535452M', '1968-08-05', 'Commercial'),
	(407, 'José', 'Edvaldo', 'Maxham', 'QI067297A', '1979-12-24', 'Commercial'),
	(408, 'David', 'R', 'Matthews', 'UF346641S', '1982-11-03', 'Litigation'),
	(409, 'Tete', 'A', 'Matthew', 'DS299944Y', '1982-08-13', 'Litigation'),
	(410, 'Syed', 'E', 'Masters', 'DW232399L', '1980-06-07', 'HR'),
	(411, 'Lynn', 'N', 'Masters', 'AS027090I', '1976-03-24', 'Commercial'),
	(412, 'Amy', 'E', 'Martinez', 'OR429260Y', '1981-08-28', 'Litigation'),
	(413, 'Rachel', 'B', 'Martinez', 'QH897888I', '1969-05-18', 'Commercial'),
	(414, 'Jae', 'B', 'Martin', 'MX381190H', '1986-04-24', 'Customer Relations'),
	(415, 'Ranjit', 'R', 'Martin', 'WD132300H', '1979-02-19', 'HR'),
	(416, 'Gustavo', NULL, 'Martin', 'GD451175O', '1984-09-03', 'Litigation'),
	(417, 'Catherine', 'R.', 'Martin', 'NZ608573U', '1980-04-24', 'Litigation'),
	(418, 'Kim', NULL, 'Martin', 'FY474358C', '1985-09-25', 'Customer Relations'),
	(419, 'Humberto', NULL, 'Mart¡nez', 'DF764157Q', '1982-03-15', 'Litigation'),
	(420, 'Pilar', NULL, 'Marshall', 'IM167983H', '1975-04-03', 'Litigation'),
	(421, 'Frances', 'B.', 'Marple', 'JG858859Z', '1975-03-31', 'Customer Relations'),
	(422, 'Margaret', 'J.', 'Markwood', 'FE303791N', '1990-11-05', 'Customer Relations');
INSERT INTO [dbo].[tblEmployee] ( [EmployeeNumber], [EmployeeFirstName], [EmployeeMiddleName], [EmployeeLastName], [EmployeeGovernmentID], [DateOfBirth], [Department]) VALUES 	(423, 'Carla', 'J.', 'Margheim', 'HM072560V', '1979-12-25', 'Commercial'),
	(424, 'Jay', NULL, 'Mares', 'ED047455B', '1978-10-20', 'Commercial'),
	(425, 'Ronald', 'L.', 'Marcovecchio', 'KV098725J', '1987-02-04', 'Commercial'),
	(426, 'Samuel', 'N.', 'Manzanares', 'XB307209W', '1982-01-12', 'Litigation'),
	(427, 'James', 'T.', 'Manek', 'LC490412U', '1966-11-28', 'Commercial'),
	(428, 'Robert', 'E.', 'Manchepalli', 'HI749277C', '1967-02-19', 'HR'),
	(429, 'François', NULL, 'Malmendier', 'ER973604J', '1965-12-21', 'Litigation'),
	(430, 'Kim', NULL, 'Male', 'IL223516E', '1977-01-08', 'Commercial'),
	(431, 'Lili', 'J.', 'Magenheimer', 'DW963672R', '1974-03-20', 'Commercial'),
	(432, 'Amy', 'E.', 'Macrae', 'UM796011V', '1976-10-13', 'Customer Relations'),
	(433, 'Anna', 'A.', 'MacDonald', 'QS692530C', '1969-10-27', 'Customer Relations'),
	(434, 'Milton', 'J.', 'Maccietto', 'OG398599V', '1984-04-03', 'Commercial'),
	(435, 'Paul', 'L.', 'Lysaker', 'RI881631L', '1971-12-30', 'Customer Relations'),
	(436, 'Gregory', 'F.', 'Lyon', 'FR176967G', '1973-12-17', 'Commercial'),
	(437, 'J. Phillip', 'L.', 'Lynn', 'AD410766E', '1983-01-30', 'Customer Relations'),
	(438, 'Michelle', NULL, 'Lyeba', 'HT353877D', '1982-05-20', 'Customer Relations'),
	(439, 'Sean', 'P.', 'Luthra', 'FU983183I', '1976-05-22', 'Litigation'),
	(440, 'Phyllis', 'A.', 'Lutes', 'QJ197600U', '1980-02-04', 'Litigation'),
	(441, 'Marvin', 'N.', 'Lunt', 'AD446670V', '1981-09-25', 'Commercial'),
	(442, 'Michael', NULL, 'Lundahl', 'EN593972K', '1988-07-10', 'Customer Relations'),
	(443, 'Cecil', 'J.', 'Lum', 'RE641064K', '1993-12-30', 'Litigation'),
	(444, 'Oscar', 'L.', 'Lugo', 'NI233710I', '1988-11-01', 'Commercial'),
	(445, 'Sandra', 'J.', 'Lugo', 'QJ572587C', '1978-09-27', 'Commercial'),
	(446, 'Selena', 'R.', 'Lucerne', 'BU295129U', '1969-09-07', 'Commercial'),
	(447, 'Emilio', 'R.', 'Low', 'BP692194O', '1990-06-21', 'HR'),
	(448, 'Maxwell', 'J.', 'Los', 'NA868679T', '1977-10-20', 'HR'),
	(449, 'Mae', 'N.', 'Looney', 'RG627073R', '1992-09-14', 'Commercial'),
	(450, 'Ramona', 'J.', 'Long', 'QO080999Z', '1989-03-18', 'Commercial'),
	(451, 'Sabria', 'B.', 'Loh', 'LF453498P', '1986-07-09', 'Customer Relations'),
	(452, 'Hannah', 'R.', 'Loh', 'PQ256476D', '1977-09-03', 'Litigation'),
	(453, 'Kyley', 'J.', 'Logan', 'DB918928H', '1973-08-24', 'HR'),
	(454, 'Tom', 'H', 'Lloyd', 'XP360021B', '1971-05-03', 'Litigation'),
	(455, 'Thomas', 'B.', 'Liu', 'EH142135Y', '1987-03-22', 'HR'),
	(456, 'John', NULL, 'Liu', 'EE938482C', '1987-01-07', 'Customer Relations'),
	(457, 'Chris', NULL, 'Liu', 'MS298469J', '1987-09-04', 'Customer Relations'),
	(458, 'Teresa', NULL, 'Liu', 'QN133103R', '1987-11-11', 'HR'),
	(459, 'John', 'P.', 'Liu', 'LB382272F', '1971-02-03', 'Customer Relations'),
	(460, 'Robert', 'A.', 'Liu', 'FE655870R', '1975-07-16', 'Litigation'),
	(461, 'Stephen', 'M.', 'Liu', 'SV413403D', '1974-08-17', 'HR'),
	(462, 'Phillip', 'M.', 'Lisboa', 'NC404319V', '1980-08-30', 'Litigation'),
	(463, 'Daniel', NULL, 'Lique', 'XT491673Y', '1987-07-11', 'Customer Relations'),
	(464, 'Cory', 'K.', 'Li', 'KO606359X', '1976-08-05', 'Commercial'),
	(465, 'James', 'B.', 'Li', 'YZ331502L', '1986-08-18', 'Commercial'),
	(466, 'Douglas', 'A.', 'Li', 'EY734847X', '1975-01-14', 'Commercial'),
	(467, 'Jennifer', 'B.', 'Li', 'UZ513304L', '1972-03-29', 'Litigation'),
	(468, 'Alberto', 'F.', 'Li', 'WX256694G', '1979-03-03', 'Commercial'),
	(469, 'Wayne', 'N.', 'Li', 'ZZ174938A', '1971-06-11', 'HR'),
	(470, 'Darrell', 'M.', 'Lewin', 'QR963071K', '1980-01-17', 'Customer Relations'),
	(471, 'Angela', NULL, 'Lew', 'TV139411Y', '1972-08-17', 'Customer Relations'),
	(472, 'David', NULL, 'Levy', 'VW516525G', '1967-09-22', 'Litigation'),
	(473, 'Robert', 'L.', 'Leste', 'VU570547G', '1981-04-10', 'Litigation'),
	(474, 'Rebecca', 'R.', 'Lesko', 'QS657916O', '1988-08-04', 'Customer Relations'),
	(475, 'Brenda', 'L.', 'Lertpiriyasuwat', 'PF319454S', '1982-03-04', 'HR'),
	(476, 'Josh', NULL, 'Lepro', 'YR776944Z', '1977-09-15', 'Commercial'),
	(477, 'Adam', NULL, 'Leonetti', 'YB140676B', '1992-01-09', 'Litigation'),
	(478, 'Norma', 'N.', 'Lengel', 'AY746391D', '1987-10-07', 'Customer Relations'),
	(479, 'Gytis', 'M', 'Lenehan', 'OE787618H', '1984-10-08', 'Litigation'),
	(480, 'David', 'M.', 'Lee', 'VS520458X', '1967-05-24', 'Customer Relations'),
	(481, 'Karel', 'E.', 'Lee', 'WF370705Q', '1968-03-09', 'Litigation'),
	(482, 'Ciro', 'J.', 'Lee', 'SU821507B', '1981-09-17', 'Customer Relations'),
	(483, 'Glenna', 'L.', 'Lee', 'AA162361D', '1993-06-11', 'Litigation'),
	(484, 'Shaun', NULL, 'Lee', 'MO770587Q', '1979-03-02', 'Litigation'),
	(485, 'John', 'A.', 'Lee', 'FH469663D', '1979-11-10', 'Customer Relations'),
	(486, 'Christopher', 'R.', 'Leavitt', 'EB645335E', '1990-10-03', 'Commercial'),
	(487, 'Bradley', NULL, 'Lawrence', 'IR143095N', '1980-10-28', 'Litigation'),
	(488, 'Benjamin', 'J.', 'Lawrence', 'LL898095I', '1991-04-20', 'Customer Relations'),
	(489, 'Ann', NULL, 'Laursen', 'YE174559R', '1988-11-30', 'Commercial'),
	(490, 'Shane', 'J.', 'Laszlo', 'JJ785787U', '1973-02-18', 'Litigation'),
	(491, 'Stanley', 'A.', 'Laszlo', 'BB793368D', '1968-10-10', 'HR'),
	(492, 'Mason', NULL, 'Lang', 'WV286920R', '1982-06-01', 'Litigation'),
	(493, 'John', 'M.', 'LaMee', 'SJ709587S', '1980-02-09', 'Litigation'),
	(494, 'Ido', NULL, 'Kurtz', 'WB910003F', '1984-09-13', 'HR'),
	(495, 'Edna', 'J.', 'Kurniawan', 'EH176624N', '1974-03-11', 'Litigation'),
	(496, 'Payton', 'P.', 'Kurjan', 'ZZ886487P', '1982-10-27', 'Litigation'),
	(497, 'Max', NULL, 'Kuppa', 'KH426916M', '1983-08-17', 'Commercial'),
	(498, 'Scot', 'A.', 'Kuppa', 'PA809173E', '1986-09-28', 'HR'),
	(499, 'Richard', 'M.', 'Kung', 'NX537899G', '1974-02-01', 'Customer Relations'),
	(500, 'Marian', 'M.', 'Kumar', 'YG834413W', '1973-10-24', 'Commercial'),
	(501, 'Karen', NULL, 'Krupka', 'BT196887S', '1970-07-07', 'Commercial'),
	(502, 'Alexander', 'J.', 'Krow', 'DP559772S', '1990-12-10', 'Customer Relations'),
	(503, 'John', 'M.', 'Krebs', 'NZ493164U', '1981-02-27', 'HR'),
	(504, 'Kris', 'R.', 'Krapauskas', 'XC726875N', '1973-05-21', 'HR'),
	(505, 'Andreas', NULL, 'Krane', 'IJ895511T', '1966-05-05', 'Commercial'),
	(506, 'Robert', 'M.', 'Krane', 'NO457432H', '1968-05-14', 'Commercial'),
	(507, 'Matthias', NULL, 'Krane', 'KT078458E', '1976-04-09', 'Litigation'),
	(508, 'John', NULL, 'Kramer', 'QQ247788C', '1993-04-28', 'Commercial'),
	(509, 'Steven', 'B.', 'Kramer', 'FQ504875G', '1971-06-11', 'Customer Relations'),
	(510, 'Chris', 'N.', 'Kozlowski', 'MD582005P', '1986-10-02', 'HR'),
	(511, 'Mary', 'B.', 'Kotc', 'VD647807X', '1974-02-16', 'Litigation'),
	(512, 'Jimmy', NULL, 'Koski', 'LC655206B', '1988-02-15', 'HR'),
	(513, 'Mary', NULL, 'Konersmann', 'PI595354T', '1990-03-27', 'Litigation'),
	(514, 'Mae', 'M.', 'Komosinski', 'EV319884A', '1986-11-10', 'Customer Relations'),
	(515, 'Jackie', 'E.', 'Kogan', 'SH886824R', '1982-05-09', 'Commercial'),
	(516, 'Donald', 'L.', 'Kogan', 'YT173982D', '1972-11-08', 'HR'),
	(517, 'Linda', 'E.', 'Koenigsbauer', 'CH974573I', '1991-03-17', 'Litigation'),
	(518, 'Michael', 'Greg', 'Koch', 'LQ548792H', '1993-01-03', 'Litigation'),
	(519, 'Gabriel', 'L.', 'Koch', 'QA061858L', '1975-10-31', 'Customer Relations'),
	(520, 'Michael', 'L.', 'Kobylinski', 'ZL483698T', '1969-11-14', 'Commercial'),
	(521, 'Corinna', NULL, 'Kleinerman', 'MG865016A', '1966-10-23', 'HR'),
	(522, 'Luis', NULL, 'Kleinerman', 'JR236403Q', '1966-11-07', 'HR');
INSERT INTO Employee ( Emp_id, EmpFirstName, EmpMiddleName, EmpLastName, EmpGovernmentID, DateOfBirth, Department)
    VALUES 	(523, 'Randall', NULL, 'Kitt', 'IA458347Y', '1987-01-11', 'Commercial'),
	(524, 'Stephanie', NULL, 'Kirilov', 'OI905733G', '1981-03-31', 'Commercial'),
	(525, 'Eli', NULL, 'King', 'NT241932W', '1966-01-28', 'Litigation'),
	(526, 'Lester', 'J.', 'King', 'KZ687176J', '1973-09-14', 'Customer Relations'),
	(527, 'David', 'M.', 'King', 'UB785267H', '1970-10-06', 'Commercial'),
	(528, 'Cornelius', 'L.', 'Kim', 'GA036760O', '1969-01-19', 'HR'),
	(529, 'Richard', NULL, 'Kim', 'CA299089X', '1982-04-25', 'Customer Relations'),
	(530, 'Sara', 'N.', 'Kim', 'UE721281W', '1986-07-20', 'HR'),
	(531, 'Ted', NULL, 'Kim', 'NS942640E', '1986-01-14', 'Customer Relations'),
	(532, 'Alan', NULL, 'Kim', 'GB453648L', '1966-02-14', 'Commercial'),
	(533, 'Walter', 'J.', 'Kharatishvili', 'DF208663R', '1971-11-21', 'Commercial'),
	(534, 'Christopher', 'M.', 'Khanna', 'YG563969D', '1972-05-11', 'HR'),
	(535, 'Carol', 'J.', 'Khanna', 'CZ935587U', '1968-04-25', 'Commercial'),
	(536, 'David', 'J.', 'Khan', 'KV907997B', '1966-08-08', 'Customer Relations'),
	(537, 'John', 'R.', 'Khan', 'TS246549E', '1978-04-05', 'Commercial'),
	(538, 'Willie', 'P.', 'Keyser', 'IR674453I', '1966-06-29', 'Commercial'),
	(539, 'Carolee', 'J.', 'Keyser', 'LB230291G', '1981-02-04', 'Customer Relations'),
	(540, 'Jo', NULL, 'Kesterson', 'RM118807P', '1975-10-17', 'HR'),
	(541, 'Robert', NULL, 'Kesslep', 'QT598544F', '1989-07-12', 'Commercial'),
	(542, 'Kevin', 'F.', 'Kennedy', 'YI030471I', '1974-12-15', 'Commercial'),
	(543, 'Mary', 'K.', 'Kennedy', 'VL552639Q', '1982-02-18', 'Litigation'),
	(544, 'Dave', 'P.', 'Kennedy', 'HD982374N', '1993-03-02', 'Customer Relations'),
	(545, 'Bridget', 'E.', 'Kelly', 'OP032477I', '1977-10-16', 'Customer Relations'),
	(546, 'Eric', 'J.', 'Kelly', 'KD962186X', '1971-07-08', 'HR'),
	(547, 'Dick', 'R.', 'Kelley', 'IB024236P', '1976-10-25', 'Litigation'),
	(548, 'Michael', NULL, 'Keil', 'LV979364U', '1990-08-11', 'HR'),
	(549, 'Shirley', 'R.', 'Keil', 'JT738674D', '1980-12-01', 'Commercial'),
	(550, 'June', 'B.', 'Kearney', 'DG700017T', '1966-03-26', 'Commercial'),
	(551, 'Dirk', 'J.', 'Kearney', 'KW078557F', '1982-11-10', 'Litigation'),
	(552, 'Nancy', NULL, 'Katyal', 'DU588123K', '1972-02-14', 'Commercial'),
	(553, 'Janaina Barreiro Gambaro', NULL, 'Kane', 'IX220634Q', '1971-07-05', 'Customer Relations'),
	(554, 'Edward', 'T.', 'Kane', 'EP212841J', '1968-01-31', 'Litigation'),
	(555, 'Megan', 'E.', 'Kane', 'GG451204N', '1987-08-02', 'Customer Relations'),
	(556, 'Ingrid', 'K.', 'Kane', 'DF498296G', '1980-10-05', 'Commercial'),
	(557, 'Karren', 'K.', 'Kaliyath', 'TJ713334X', '1986-02-26', 'HR'),
	(558, 'Ovidiu', NULL, 'Kaliyath', 'PB111580O', '1974-11-16', 'Customer Relations'),
	(559, 'Dana', 'H.', 'Kahn', 'WV944153U', '1985-04-21', 'Customer Relations'),
	(560, 'Timothy', 'B.', 'Kahn', 'UZ836754L', '1990-12-13', 'Commercial'),
	(561, 'Stephen', 'R.', 'Kaffer', 'AI618900E', '1973-06-06', 'Commercial'),
	(562, 'Deanna', 'R.', 'Justice', 'XW548210F', '1974-07-26', 'Litigation'),
	(563, 'Jared', 'L.', 'Jordan', 'DC523188A', '1989-09-04', 'HR'),
	(564, 'Richard', 'A.', 'Jones', 'BH701266L', '1974-10-24', 'Commercial'),
	(565, 'David', 'J.', 'Jones', 'RU149680E', '1990-10-04', 'Commercial'),
	(566, 'Ryan', NULL, 'Johnston', 'DN718259N', '1985-10-09', 'Customer Relations'),
	(567, 'Sylvia', 'A.', 'Johnston', 'PI065011Y', '1993-09-27', 'HR'),
	(568, 'Mari', 'B.', 'Johnson', 'LJ927258Y', '1983-05-13', 'HR'),
	(569, 'Barbara', 'J.', 'Johnson', 'KG005262T', '1986-01-27', 'Litigation'),
	(570, 'Lindsey', 'R.', 'Johnson', 'GK924628P', '1976-12-15', 'Customer Relations'),
	(571, 'Gustavo', NULL, 'Johnson', 'HO571282D', '1981-06-03', 'Litigation'),
	(572, 'DeeDee', 'J.', 'Johnson', 'VA857683T', '1972-05-02', 'Litigation'),
	(573, 'Deborah', 'M.', 'Johnson', 'FM245826L', '1968-03-24', 'Litigation'),
	(574, 'Joan', 'M.', 'Johnson', 'VL001773W', '1984-10-24', 'Litigation'),
	(575, 'David', NULL, 'Johnson', 'WH730278V', '1991-03-15', 'Litigation'),
	(576, 'Henry', 'L.', 'Johnson', 'EC769194P', '1975-07-25', 'Customer Relations'),
	(577, 'Chris', NULL, 'Johnson', 'CB849757K', '1988-12-21', 'Litigation'),
	(578, 'Joseph', 'J.', 'Johns', 'OE250669H', '1968-02-02', 'Commercial'),
	(579, 'Suzana De Abreu', 'A.', 'Jiang', 'KI116565J', '1981-03-02', 'Commercial'),
	(580, 'Jun', NULL, 'Jiang', 'GV835226C', '1993-03-18', 'Commercial'),
	(581, 'Johnny', 'A.', 'Jiang', 'VR384675E', '1977-09-03', 'Litigation'),
	(582, 'Richard', NULL, 'Jarvis', 'IO607400H', '1974-03-04', 'Commercial'),
	(583, 'Carlton', 'M.', 'Jamison', 'EL046864K', '1978-02-08', 'Commercial'),
	(584, 'Ty Loren', NULL, 'Jaffe', 'XZ277123X', '1994-07-15', 'HR'),
	(585, 'Jane', 'N.', 'Jacobson', 'VP054987L', '1976-06-28', 'HR'),
	(586, 'Jovita', 'A.', 'Jacobson', 'CR669027G', '1986-03-03', 'HR'),
	(587, 'Steve', 'J.', 'Jacobsen', 'QN330840M', '1981-06-10', 'HR'),
	(588, 'Fernando', NULL, 'Jacobs', 'PZ412792A', '1973-11-11', 'Commercial'),
	(589, 'Rob', NULL, 'Iyer', 'IP751772B', '1984-07-09', 'Commercial'),
	(590, 'Andy', NULL, 'Ito', 'VH123564Z', '1967-02-01', 'HR'),
	(591, 'Donna', 'F.', 'Ison', 'CK132760G', '1984-01-28', 'HR'),
	(592, 'Rosmarie', 'J.', 'Ismert', 'FT370596B', '1968-09-01', 'Commercial'),
	(593, 'Matthew', NULL, 'Irwin', 'CP891680F', '1991-03-28', 'HR'),
	(594, 'Joseph', 'N.', 'Ingle', 'AX390386S', '1981-02-03', 'Litigation'),
	(595, 'Pamela', 'A.', 'Inghram', 'JC112281E', '1982-03-29', 'Litigation'),
	(596, 'Raul', 'E.', 'Ihrig', 'NF004400L', '1979-05-21', 'Litigation'),
	(597, 'Elizabeth', 'E.', 'Iallo', 'EW900434Q', '1969-01-15', 'HR'),
	(598, 'Matthew', 'J.', 'Hurkett', 'LI245218J', '1971-10-15', 'Commercial'),
	(599, 'Brigid', 'F.', 'Huntsman', 'YU969829U', '1968-09-21', 'HR'),
	(600, 'Andrew', NULL, 'Hunter', 'UH004900I', '1983-07-21', 'Litigation'),
	(601, 'Stacey', 'M.', 'Hunter', 'JB153295L', '1984-05-06', 'Commercial'),
	(602, 'Baris', NULL, 'Huff', 'WL300573U', '1969-06-14', 'HR'),
	(603, 'Sean', NULL, 'Huff', 'CB104079E', '1976-11-09', 'Customer Relations'),
	(604, 'Pat', 'A.', 'Huckaby', 'IK492611R', '1968-04-06', 'Commercial'),
	(605, 'Forrest', 'J.', 'Hows', 'BS151729D', '1975-06-14', 'Commercial'),
	(606, 'Lee', 'J.', 'Howard', 'MU776053C', '1981-09-23', 'Commercial'),
	(607, 'Greg', NULL, 'Howard', 'UC630991Q', '1969-05-28', 'Customer Relations'),
	(608, 'Neil', NULL, 'Houston', 'HF606442X', '1981-12-24', 'Litigation'),
	(609, 'Hao', NULL, 'Homer', 'DS114338Q', '1978-06-06', 'Litigation'),
	(610, 'John', 'Y.', 'Holt', 'GG083149K', '1968-09-20', 'Litigation'),
	(611, 'Pei', NULL, 'Holmes', 'CL393345G', '1979-10-13', 'Customer Relations'),
	(612, 'Yao-Qiang', NULL, 'Holman', 'PM071699M', '1985-04-29', 'Commercial'),
	(613, 'Nicky', 'E.', 'Holm', 'UG703204P', '1967-08-11', 'HR'),
	(614, 'Susan', 'B.', 'Holloway', 'UT672298T', '1985-02-07', 'Commercial'),
	(615, 'Martin', NULL, 'Holliday', 'EN429893H', '1979-09-26', 'HR'),
	(616, 'Mike', 'M.', 'Hohman', 'NI183685S', '1968-06-29', 'Litigation'),
	(617, 'Ruth', 'A.', 'Hoffman', 'IR378234O', '1987-06-07', 'Commercial'),
	(618, 'Anthony', NULL, 'Hoeing', 'QR710021E', '1980-07-28', 'Commercial'),
	(619, 'Charles', 'M.', 'Hodgson', 'VX904444N', '1966-05-23', 'HR'),
	(620, 'Jill', 'J.', 'Hodges', 'AY561782G', '1985-12-26', 'Customer Relations'),
	(621, 'Alice', NULL, 'Hite', 'HS366986U', '1984-03-01', 'HR'),
	(622, 'Gina', 'N.', 'Hite', 'QJ919087J', '1993-12-28', 'Customer Relations');
INSERT INTO Employee ( Emp_id, EmpFirstName, EmpMiddleName, EmpLastName, EmpGovernmentID, DateOfBirth, Department)
VALUES 	(623, 'James', 'J.', 'Hirsch', 'AX296181P', '1967-03-05', 'Customer Relations'),
	(624, 'Jane', NULL, 'Hirota', 'AC136922O', '1988-09-18', 'Commercial'),
	(625, 'Kristine', 'J.', 'Hink', 'GV772368F', '1993-05-02', 'Litigation'),
	(626, 'Teanna', 'M.', 'Hines', 'ES178152H', '1967-06-05', 'Commercial'),
	(627, 'Connie', 'L.', 'Hines', 'SK243139K', '1972-12-13', 'Customer Relations'),
	(628, 'Jeanette', 'R.', 'Hillmann', 'VE490612E', '1989-02-15', 'Customer Relations'),
	(629, 'Eric', 'E.', 'Hillmann', 'GW874651S', '1992-02-15', 'HR'),
	(630, 'Pat', NULL, 'Hill', 'LB414322N', '1970-09-30', 'HR'),
	(631, 'Takiko', 'J.', 'Hill', 'CS363980H', '1981-05-18', 'Commercial'),
	(632, 'John', 'L.', 'Hill', 'OZ258825X', '1968-10-23', 'Commercial'),
	(633, 'Scott', 'A.', 'Hill', 'SB249957R', '1974-07-31', 'HR'),
	(634, 'Aaron', NULL, 'Hill', 'GX189323H', '1982-10-09', 'Litigation'),
	(635, 'Peter', NULL, 'Highfill', 'DH190444I', '1986-08-26', 'Litigation'),
	(636, 'William', 'J.', 'Higgs', 'UH546933G', '1982-08-08', 'HR'),
	(637, 'Stephanie', NULL, 'Higa', 'FR655710G', '1978-04-28', 'HR'),
	(638, 'Amy', 'R.', 'Higa', 'MO272634D', '1990-02-11', 'Customer Relations'),
	(639, 'Dorothy', 'J.', 'Heymsfield', 'GQ272094H', '1990-05-08', 'Litigation'),
	(640, 'Patrick', 'M.', 'Hesse', 'AY936596N', '1993-06-27', 'Litigation'),
	(641, 'Scott', NULL, 'Herring', 'BL922365I', '1972-04-15', 'Commercial'),
	(642, 'Eva', NULL, 'Herrick', 'HE323037S', '1967-01-21', 'Litigation'),
	(643, 'Marlin', 'M.', 'Hernandez', 'SN342518I', '1971-05-30', 'Litigation'),
	(644, 'Ryan', NULL, 'Hernandez', 'EW348444V', '1974-05-31', 'Customer Relations'),
	(645, 'Bruno', NULL, 'Herman', 'WD618293P', '1987-12-10', 'Commercial'),
	(646, 'Pamela', 'R.', 'Hensien', 'PP934664Y', '1984-01-29', 'HR'),
	(647, 'Jack', NULL, 'Henshaw', 'VC036048U', '1982-03-01', 'Customer Relations'),
	(648, 'Sharon', 'A.', 'Henningsen', 'WK497887G', '1965-12-03', 'Commercial'),
	(649, 'Shelley', 'R.', 'Hendricks', 'CK148263R', '1982-07-16', 'Customer Relations'),
	(650, 'Grant', NULL, 'Hendergart', 'OA751765J', '1973-06-04', 'Customer Relations'),
	(651, 'Scott', NULL, 'Heidepriem', 'XC719841M', '1979-07-31', 'Litigation'),
	(652, 'Conor', NULL, 'Hee', 'TS195861S', '1966-09-15', 'Litigation'),
	(653, 'Jose', 'M.', 'Hedlund', 'LF374709I', '1986-04-08', 'Customer Relations'),
	(654, 'Thierry', NULL, 'Heaney', 'FQ585287R', '1981-12-01', 'Commercial'),
	(655, 'Ryan', NULL, 'Hay', 'NM531255L', '1974-01-17', 'Customer Relations'),
	(656, 'Mike', NULL, 'Hay', 'TY669927G', '1983-01-19', 'Litigation'),
	(657, 'Megan', 'N.', 'Haugh', 'IO312813A', '1989-02-05', 'Customer Relations'),
	(658, 'Alvaro', NULL, 'Hasty', 'HV386014Y', '1969-03-10', 'Customer Relations'),
	(659, 'Jose', NULL, 'Hassall', 'BY645068N', '1986-11-20', 'Customer Relations'),
	(660, 'Jacob', 'N.', 'Hass', 'UX141150Z', '1974-09-25', 'Commercial'),
	(661, 'Alexander', 'J.', 'Harui', 'RW530633R', '1979-06-14', 'Commercial'),
	(662, 'Barbara', 'S.', 'Hartwig', 'YN979617O', '1973-07-19', 'Litigation'),
	(663, 'Kirk', NULL, 'Hartwig', 'HR569621T', '1969-09-13', 'HR'),
	(664, 'Aidan', NULL, 'Harrison', 'PR021558J', '1971-02-02', 'Litigation'),
	(665, 'Stefan', NULL, 'Harris', 'XR056298C', '1969-05-05', 'HR'),
	(666, 'Shawn', 'R.', 'Harrington', 'YU012218S', '1993-06-09', 'HR'),
	(667, 'Della', 'F.', 'Harrington', 'EE338319T', '1973-11-27', 'Litigation'),
	(668, 'Bruno', NULL, 'Harrington', 'QC752584G', '1980-02-24', 'Litigation'),
	(669, 'Helen', 'J.', 'Harnpadoungsataya', 'IJ251306A', '1971-12-11', 'Customer Relations'),
	(670, 'Prashanth', NULL, 'Harding', 'YL467639D', '1986-03-27', 'HR'),
	(671, 'Bev', 'L.', 'Hapke', 'VO330913D', '1979-07-08', 'HR'),
	(672, 'Brenda', NULL, 'Hanson', 'FL733381T', '1981-07-02', 'Customer Relations'),
	(673, 'Gabriele', NULL, 'Hanson', 'FV594749O', '1984-04-11', 'HR'),
	(674, 'Holly', NULL, 'Hanif', 'NK539670P', '1977-04-01', 'Customer Relations'),
	(675, 'Dick', NULL, 'Handley', 'IK940741P', '1968-01-11', 'Customer Relations'),
	(676, 'Rudolph', 'J.', 'Hamilton', 'ZN150303N', '1992-01-05', 'Litigation'),
	(677, 'Andrew', NULL, 'Hamilton', 'WI209525X', '1986-05-18', 'Litigation'),
	(678, 'Blaine', NULL, 'Hamilton', 'TS402133T', '1970-08-08', 'Litigation'),
	(679, 'Cindy', 'M.', 'Hamilton', 'IA005776R', '1968-03-24', 'HR'),
	(680, 'John', 'T.', 'Hall', 'SI725894E', '1978-07-19', 'HR'),
	(681, 'Patricia', NULL, 'Hall', 'FY541420R', '1974-05-16', 'HR'),
	(682, 'Gerald', 'M.', 'Hall', 'BZ176949D', '1987-05-30', 'Litigation'),
	(683, 'Gary', 'T.', 'Haines', 'TP615775I', '1976-06-26', 'Commercial'),
	(684, 'Reuben', NULL, 'Hagens', 'MM763296Z', '1978-03-23', 'Customer Relations'),
	(685, 'Ed', NULL, 'Hagens', 'LB777202I', '1982-09-01', 'Litigation'),
	(686, 'Bernard', NULL, 'Hagemann', 'KO461410Z', '1980-11-20', 'Commercial'),
	(687, 'Tish', 'R.', 'Haemon', 'KA248564E', '1980-02-04', 'Customer Relations'),
	(688, 'Adrian', NULL, 'Gustafson', 'OA841190O', '1993-09-27', 'Commercial'),
	(689, 'Bart', NULL, 'Gubbels', 'GM460863I', '1974-05-31', 'Customer Relations'),
	(690, 'Maciej', NULL, 'Groth', 'ZZ435169J', '1967-03-30', 'HR'),
	(691, 'Shelley', NULL, 'Groncki', 'IX664010S', '1976-11-04', 'HR'),
	(692, 'Linda', 'R.', 'Grisso', 'TA533123D', '1991-08-17', 'Litigation'),
	(693, 'Carla', 'L.', 'Greer', 'CO821137S', '1971-11-26', 'HR'),
	(694, 'Carol', 'B.', 'Grande', 'YU364368Y', '1977-09-30', 'Commercial'),
	(695, 'Shannon', 'P.', 'Graham', 'IN091303K', '1979-07-30', 'Litigation'),
	(696, 'Jauna', 'E.', 'Graham', 'YI956142P', '1980-12-20', 'Litigation'),
	(697, 'Michael', NULL, 'Graff', 'UP936307F', '1973-06-07', 'Commercial'),
	(698, 'Terry', NULL, 'Gonzalez', 'RS923484S', '1980-11-06', 'Customer Relations'),
	(699, 'John', NULL, 'Gonzales', 'SV248342V', '1975-07-04', 'HR'),
	(700, 'Gail', NULL, 'Gonzales', 'BZ100072N', '1982-04-20', 'Litigation'),
	(701, 'Mark', 'B', 'Goldstein', 'ZA861637S', '1991-09-01', 'Litigation'),
	(702, 'Martha', 'R.', 'Goldstein', 'AK010282L', '1973-07-19', 'Commercial'),
	(703, 'Julie', 'P.', 'Goldberg', 'UQ021961R', '1993-05-15', 'Customer Relations'),
	(704, 'Janeth', NULL, 'Goldberg', 'VN159420Q', '1992-05-01', 'Litigation'),
	(705, 'Twanna', 'R.', 'Goktepe', 'JL840180V', '1981-08-31', 'Customer Relations'),
	(706, 'Ann', 'R.', 'Gode', 'JN224195P', '1992-05-09', 'HR'),
	(707, 'John', NULL, 'Gode', 'SG838622X', '1975-11-30', 'Litigation'),
	(708, 'Marc', NULL, 'Glynn', 'NH690361Y', '1972-10-20', 'HR'),
	(709, 'Fadi', NULL, 'Glimp', 'DE350824A', '1972-09-11', 'Litigation'),
	(710, 'Carolyn', NULL, 'Glimp', 'RZ284191L', '1982-09-13', 'Litigation'),
	(711, 'Geri', 'P.', 'Glenn', 'CQ712694G', '1994-04-26', 'Litigation'),
	(712, 'Hanying', NULL, 'Givens', 'RN540445E', '1979-09-26', 'Customer Relations'),
	(713, 'Rhoda', 'J.', 'Gimmi', 'DV997684U', '1980-02-15', 'Customer Relations'),
	(714, 'Duane', 'R.', 'Gilliat', 'SM946720E', '1979-08-29', 'Commercial'),
	(715, 'James', NULL, 'Gilbert', 'QF332622J', '1980-05-31', 'Litigation'),
	(716, 'Kathie', NULL, 'Gilbert', 'LH315858B', '1967-01-13', 'Litigation'),
	(717, 'Jay', NULL, 'Giglio', 'YE711062P', '1970-05-01', 'HR'),
	(718, 'Kelly', NULL, 'Gibson', 'FM847849A', '1993-08-07', 'HR'),
	(719, 'Jeffrey', 'L.', 'Gibbens', 'MY377625P', '1972-09-04', 'Customer Relations'),
	(720, 'Garth', NULL, 'Giakoumakis', 'IO012095G', '1971-01-17', 'HR'),
	(721, 'Dorothy', 'J.', 'Getzinger', 'NL799299L', '1983-03-13', 'Customer Relations'),
	(722, 'Judith', 'B.', 'German', 'AI063893N', '1981-12-06', 'HR');
INSERT INTO Employee ( Emp_id, EmpFirstName, EmpMiddleName, EmpLastName, EmpGovernmentID, DateOfBirth, Department)
    VALUES 	(723, 'John', NULL, 'Geist', 'XK446729V', '1991-03-06', 'Commercial'),
	(724, 'Susan', 'E.', 'Gehring', 'KJ537174I', '1966-03-10', 'Litigation'),
	(725, 'Liam', 'J.', 'Gee', 'SB618986Q', '1989-12-21', 'HR'),
	(726, 'Mihail', NULL, 'Gates', 'QO924744H', '1984-04-11', 'Customer Relations'),
	(727, 'John', NULL, 'Gash', 'FN600062Z', '1979-11-09', 'Commercial'),
	(728, 'Paul', 'J.', 'Garza', 'RK157380C', '1983-06-11', 'Litigation'),
	(729, 'Don', NULL, 'Ganio', 'BV382066I', '1979-12-20', 'Commercial'),
	(730, 'Bob', NULL, 'Galvin', 'KT212017Z', '1988-01-01', 'Litigation'),
	(731, 'Aldeen', 'J.', 'Galos', 'ED875907W', '1967-04-07', 'Litigation'),
	(732, 'Michael', NULL, 'Gallagher', 'IB373904F', '1987-07-30', 'Litigation'),
	(733, 'Jon', NULL, 'Gage', 'DF797008B', '1977-04-22', 'Commercial'),
	(734, 'Kathleen', 'M.', 'Funk', 'OT008162W', '1965-11-05', 'HR'),
	(735, 'Dominic', 'P.', 'Fulton', 'NQ448089Z', '1972-03-09', 'Litigation'),
	(736, 'Janet', 'M.', 'Frum', 'KP165658O', '1990-09-23', 'Commercial'),
	(737, 'Orlando', 'N.', 'Frintu', 'RQ051173L', '1991-09-21', 'Customer Relations'),
	(738, 'Darren', NULL, 'Frintu', 'SO376297R', '1986-08-05', 'Litigation'),
	(739, 'Jim', NULL, 'Friedland', 'KA594217K', '1980-07-19', 'Litigation'),
	(740, 'Barbara', 'J.', 'French', 'SM191822E', '1969-06-02', 'HR'),
	(741, 'Tom', NULL, 'Fredericksen', 'VO480562E', '1968-05-27', 'HR'),
	(742, 'Leo', NULL, 'Frazier', 'QR528614A', '1971-02-03', 'Customer Relations'),
	(743, 'Cornett', 'L.', 'Fox', 'ZR896137E', '1969-08-20', 'Customer Relations'),
	(744, 'Frances', 'J.', 'Fort', 'WD689905X', '1987-10-26', 'Litigation'),
	(745, 'Guy', NULL, 'Ford', 'XH067395J', '1976-03-23', 'Litigation'),
	(746, 'Janet', 'J.', 'Ford', 'WI773394X', '1982-08-07', 'Litigation'),
	(747, 'Mary', 'M.', 'Ford', 'GY982604K', '1983-07-04', 'Litigation'),
	(748, 'David', 'L.', 'Focht', 'HI210595Z', '1991-12-25', 'Commercial'),
	(749, 'Jeanie', 'R.', 'Fluegel', 'MM073232G', '1985-07-27', 'HR'),
	(750, 'Diane', 'R.', 'Flood', 'NG734052D', '1981-12-07', 'Customer Relations'),
	(751, 'James', 'R.', 'Flood', 'UJ907880J', '1967-11-09', 'Litigation'),
	(752, 'Scott', NULL, 'Fitzgerald', 'MM612613A', '1980-09-09', 'Commercial'),
	(753, 'Mete', NULL, 'Fitzgerald', 'BZ672787F', '1992-04-08', 'HR'),
	(754, 'Jossef', NULL, 'Finley', 'BZ223006Z', '1970-08-15', 'HR'),
	(755, 'Brian', 'R', 'Fine', 'MF142144W', '1980-09-25', 'Litigation'),
	(756, 'Lynn', 'A.', 'Ferrier', 'UM657885X', '1981-11-21', 'Customer Relations'),
	(757, 'Linda', 'L.', 'Feng', 'IQ782806S', '1979-06-20', 'Commercial'),
	(758, 'Abigail', 'J.', 'Feng', 'QQ633449E', '1973-12-20', 'Commercial'),
	(759, 'Michael', NULL, 'Fatima', 'PL852012Z', '1971-05-25', 'Commercial'),
	(760, 'Derek', NULL, 'Farrell', 'GK930335W', '1990-04-06', 'Litigation'),
	(761, 'Lowell', 'J.', 'Farino', 'AB700619L', '1971-04-06', 'Customer Relations'),
	(762, 'Jon', NULL, 'Fakhouri', 'AZ593920N', '1992-07-05', 'Litigation'),
	(763, 'Jane', 'P.', 'Fakhouri', 'CB618951G', '1985-02-16', 'Customer Relations'),
	(764, 'Geoff', NULL, 'Faeber', 'CQ701428P', '1968-08-19', 'HR'),
	(765, 'Douglas', NULL, 'Evans', 'WT510911V', '1972-07-09', 'Litigation'),
	(766, 'Brian', NULL, 'Evans', 'UF096546Z', '1967-09-08', 'Litigation'),
	(767, 'Faith', 'M.', 'Evans', 'AM953879L', '1975-10-23', 'HR'),
	(768, 'Greg', NULL, 'Evans', 'QX123990X', '1986-05-01', 'HR'),
	(769, 'Hattie', 'J.', 'Esteves', 'JC923307J', '1987-03-28', 'Customer Relations'),
	(770, 'Matthew', 'M.', 'Esteves', 'XV486664D', '1992-01-03', 'Customer Relations'),
	(771, 'Erin', 'M.', 'Estes', 'AK099187B', '1991-01-09', 'Customer Relations'),
	(772, 'Betty', 'M.', 'Espinoza', 'AA267639R', '1966-05-09', 'Litigation'),
	(773, 'Karen', 'E.', 'Ersan', 'OG850295U', '1991-06-07', 'Customer Relations'),
	(774, 'Don', NULL, 'Erickson', 'DZ863171I', '1965-12-31', 'Commercial'),
	(775, 'Bryan', NULL, 'Erickson', 'UI353020I', '1966-03-02', 'HR'),
	(776, 'Don', NULL, 'Erickson', 'MZ805269T', '1990-10-11', 'HR'),
	(777, 'Kerim', NULL, 'Entin', 'JZ299330C', '1983-07-06', 'Customer Relations'),
	(778, 'Jean', 'P.', 'Emory', 'CJ479056J', '1986-07-21', 'HR'),
	(779, 'Mark', NULL, 'Eminhizer', 'YA345827G', '1970-08-21', 'HR'),
	(780, 'William', 'J.', 'Eminhizer', 'DH832251T', '1974-06-16', 'Customer Relations'),
	(781, 'Katherine', NULL, 'Emanuel', 'UA055807N', '1989-07-01', 'Customer Relations'),
	(782, 'Kimberly', 'Beth', 'Elson', 'OS659457I', '1969-04-14', 'HR'),
	(783, 'Lucy', NULL, 'Elliott', 'AC816133S', '1987-05-30', 'HR'),
	(784, 'Keith', NULL, 'Elliott', 'QK388939U', '1989-04-14', 'Commercial'),
	(785, 'Doris', NULL, 'Ellerbrock', 'KC661580K', '1974-05-02', 'Customer Relations'),
	(786, 'Roger', NULL, 'Eldridge', 'VI470385D', '1974-12-02', 'Commercial'),
	(787, 'Ann', 'T.', 'Ecoffey', 'CQ834431D', '1982-04-08', 'Customer Relations'),
	(788, 'Mark', NULL, 'Eaton', 'XN691971M', '1966-12-02', 'Commercial'),
	(789, 'Neal', 'B.', 'Earls', 'LV832806E', '1976-12-07', 'Commercial'),
	(790, 'James', 'B.', 'Dyck', 'BO184888R', '1968-06-09', 'HR'),
	(791, 'Jeff', NULL, 'Dyck', 'EB221307K', '1970-12-24', 'HR'),
	(792, 'Brenda', 'F.', 'Dusza', 'KB775033C', '1967-03-15', 'Litigation'),
	(793, 'James', NULL, 'Dusza', 'UM387252H', '1990-01-28', 'Litigation'),
	(794, 'John', NULL, 'Duncan', 'WJ429734J', '1966-04-19', 'Commercial'),
	(795, 'Valerie', 'M.', 'Dumitrascu', 'XL748485R', '1991-03-16', 'Commercial'),
	(796, 'Jay', NULL, 'Duffy', 'EU338965F', '1990-03-02', 'Litigation'),
	(797, 'Jeff', 'D.', 'Duff', 'HQ051516Y', '1972-08-11', 'Commercial'),
	(798, 'Kari', NULL, 'Duerr', 'GO818002X', '1985-03-27', 'Litigation'),
	(799, 'Deena', 'J.', 'Dudenhoefer', 'OM660481Q', '1992-10-23', 'Customer Relations'),
	(800, 'Irene', 'J.', 'Dudenhoefer', 'HZ227682V', '1975-09-13', 'Litigation'),
	(801, 'Jésus', NULL, 'D''sa', 'IR880883L', '1989-06-06', 'Commercial'),
	(802, 'Pam', 'L.', 'D''sa', 'ZS162465E', '1987-06-20', 'Commercial'),
	(803, 'Cheryl', 'M.', 'Drury', 'DS557052G', '1972-11-24', 'HR'),
	(804, 'Ronald', 'K.', 'Drury', 'PG442422X', '1966-05-22', 'Commercial'),
	(805, 'Sidney', NULL, 'Doyle', 'FG029507S', '1975-02-13', 'HR'),
	(806, 'Onetha', 'F.', 'Donovan', 'GJ370113O', '1970-03-12', 'HR'),
	(807, 'Fran', 'P.', 'Dodd', 'QD413553M', '1984-10-20', 'HR'),
	(808, 'Geneva', 'T.', 'Dockter', 'RW350653J', '1970-01-14', 'Commercial'),
	(809, 'Andrew', 'R.', 'Dobney', 'TM925829H', '1987-10-07', 'HR'),
	(810, 'Reinout', NULL, 'Dixon', 'PA098488K', '1967-12-21', 'Commercial'),
	(811, 'Mike', NULL, 'Dillon', 'XU309116Z', '1968-01-01', 'Litigation'),
	(812, 'Matthew', NULL, 'Dievendorff', 'EU043291S', '1983-10-03', 'Commercial'),
	(813, 'Nancy', 'E.', 'Dickson', 'DC966812G', '1981-01-19', 'Litigation'),
	(814, 'Rose', NULL, 'Dickmann', 'SG402423C', '1982-01-11', 'Commercial'),
	(815, 'Douglas', NULL, 'Diaz', 'DE179854S', '1989-08-05', 'Litigation'),
	(816, 'David', NULL, 'Diaz', 'RX139310V', '1983-09-06', 'Litigation'),
	(817, 'Helge', NULL, 'D''Hers', 'CI019393B', '1977-01-10', 'Customer Relations'),
	(818, 'Barbara', NULL, 'D''Hers', 'DI919231F', '1967-07-31', 'Litigation'),
	(819, 'Holly', 'J.', 'Desalvo', 'IB385721Y', '1981-02-20', 'Commercial'),
	(820, 'Bob', NULL, 'Desai', 'DM148216J', '1984-08-23', 'Customer Relations'),
	(821, 'Jean', 'J.', 'Dennis', 'NK997269W', '1975-02-22', 'HR'),
	(822, 'Michael', NULL, 'Deniut', 'PJ115368Y', '1974-05-17', 'HR');
INSERT INTO Employee ( Emp_id, EmpFirstName, EmpMiddleName, EmpLastName, EmpGovernmentID, DateOfBirth, Department)
VALUES 	(823, 'Eddie', 'M.', 'Dempsey', 'TL352905O', '1976-01-07', 'Commercial'),
	(824, 'Juanita', 'J.', 'Demott Jr', 'FH057195T', '1967-05-09', 'Customer Relations'),
	(825, 'Peter', NULL, 'Demicell', 'XA015656S', '1984-03-10', 'Customer Relations'),
	(826, 'Curtis', 'P.', 'Delmarco', 'CM072162T', '1989-03-26', 'Commercial'),
	(827, 'Joe', NULL, 'Delaney', 'TE539148L', '1988-04-26', 'Customer Relations'),
	(828, 'Janice', 'K.', 'DeGrasse', 'EB501567C', '1985-12-22', 'Litigation'),
	(829, 'George', 'M.', 'Decker', 'HZ186350T', '1987-05-18', 'Litigation'),
	(830, 'Joshua', 'J.', 'Decker', 'KX008038W', '1980-11-09', 'Litigation'),
	(831, 'Arlene', NULL, 'Deborde', 'SY232013B', '1976-02-10', 'Litigation'),
	(832, 'Matthew', 'M.', 'Dean', 'CW818205G', '1970-04-24', 'Customer Relations'),
	(833, 'Phyllis', 'R.', 'De Oliveira', 'HB670991L', '1977-02-05', 'HR'),
	(834, 'Lawrence', 'E.', 'De Matos Miranda Filho', 'YJ770911D', '1978-03-27', 'Litigation'),
	(835, 'Ryan', NULL, 'Davis', 'KP985039K', '1976-04-17', 'HR'),
	(836, 'Beth', NULL, 'Danseglio', 'MA981023M', '1980-05-21', 'Litigation'),
	(837, 'Lucio', NULL, 'Danner', 'CV507216N', '1986-12-20', 'Litigation'),
	(838, 'Richard', 'L.', 'Curry', 'XJ494233V', '1990-07-09', 'Customer Relations'),
	(839, 'Erik', NULL, 'Cunningham', 'EQ410786L', '1982-07-03', 'Commercial'),
	(840, 'Denean', 'J.', 'Culp', 'JD671831N', '1977-11-05', 'Litigation'),
	(841, 'Raman', NULL, 'Culbertson', 'SD643745Y', '1970-02-08', 'Customer Relations'),
	(842, 'Bronson', 'R.', 'Culbertson', 'AD485683T', '1982-09-17', 'Commercial'),
	(843, 'Eric', 'A.', 'Crow', 'HK122093X', '1976-06-14', 'HR'),
	(844, 'Jodan', 'M.', 'Crow', 'IQ782131T', '1994-07-19', 'Litigation'),
	(845, 'Mary', NULL, 'Creasey', 'RO521430M', '1981-03-06', 'Customer Relations'),
	(846, 'David', NULL, 'Creasey', 'KM694447E', '1970-07-22', 'Litigation'),
	(847, 'Jay', NULL, 'Cracium', 'WJ802120F', '1993-05-27', 'HR'),
	(848, 'Vance', 'P.', 'Cox', 'PJ588400W', '1991-02-01', 'Customer Relations'),
	(849, 'Joyce', NULL, 'Costa Da Silva', 'SF220496T', '1993-08-23', 'Commercial'),
	(850, 'George', NULL, 'Cornelsen', 'WA858622F', '1983-10-24', 'HR'),
	(851, 'Stephen', 'Yuan', 'Cornelsen', 'MU970430C', '1989-02-18', 'Commercial'),
	(852, 'Samuel', 'A.', 'Coriell', 'LK784471C', '1976-10-21', 'Litigation'),
	(853, 'Danielle', 'B.', 'Corets', 'PG914364T', '1976-09-25', 'HR'),
	(854, 'Greg', 'M.', 'Cooper', 'UO855948O', '1974-02-06', 'Commercial'),
	(855, 'Barry', NULL, 'Cook', 'IC145058X', '1969-12-13', 'Commercial'),
	(856, 'Brian', NULL, 'Cook', 'EO737600V', '1972-04-05', 'Commercial'),
	(857, 'David', NULL, 'Contreras', 'PI939649F', '1980-01-22', 'Customer Relations'),
	(858, 'Willis', NULL, 'Consentino', 'XT632292C', '1976-06-22', 'Customer Relations'),
	(859, 'Tamara', NULL, 'Conroy', 'AQ008764E', '1984-05-26', 'HR'),
	(860, 'Robert', 'E.', 'Conroy', 'RO358530M', '1992-09-25', 'Litigation'),
	(861, 'Brannon', NULL, 'Conner', 'KK696617I', '1973-01-30', 'Litigation'),
	(862, 'Jean', NULL, 'Connelly', 'MJ091082Q', '1968-08-27', 'HR'),
	(863, 'Peggy', 'J.', 'Connelly', 'OA840066O', '1975-11-02', 'HR'),
	(864, 'Diane', 'F.', 'Con', 'DQ580709D', '1993-12-03', 'Customer Relations'),
	(865, 'Scott', 'B.', 'Colvin', 'KM512175I', '1968-01-14', 'HR'),
	(866, 'Sandra', 'T.', 'Colon', 'FB705510T', '1994-05-18', 'Litigation'),
	(867, 'Wendy', NULL, 'Collins', 'PV803800H', '1980-07-03', 'Litigation'),
	(868, 'Sandeep', NULL, 'Coleman', 'GH806020F', '1975-08-18', 'Customer Relations'),
	(869, 'John', NULL, 'Coleman', 'CQ454533N', '1979-10-11', 'Litigation'),
	(870, 'Lori', NULL, 'Coleman', 'WN674424M', '1977-11-26', 'Commercial'),
	(871, 'Judith', 'F.', 'Cole', 'FJ618405G', '1986-02-11', 'Commercial'),
	(872, 'Kay', 'E.', 'Coffman', 'EB795635L', '1978-12-28', 'Commercial'),
	(873, 'Sandeep', NULL, 'Cobb', 'IN414027D', '1989-02-07', 'Litigation'),
	(874, 'Bonnie', NULL, 'Cleary', 'ER565315L', '1970-10-12', 'Litigation'),
	(875, 'Kendall', NULL, 'Clayton', 'DH050475A', '1985-01-28', 'Customer Relations'),
	(876, 'Victor', 'A.', 'Clark', 'RN743058Y', '1979-10-27', 'HR'),
	(877, 'John', NULL, 'Clark', 'VL841216F', '1980-12-16', 'Customer Relations'),
	(878, 'Robert', NULL, 'Clark', 'QD061604P', '1977-07-30', 'Litigation'),
	(879, 'Kevin', NULL, 'Ciccu', 'VV518879U', '1982-03-05', 'HR'),
	(880, 'Mary', 'R.', 'Christie', 'MC767616S', '1988-05-28', 'Customer Relations'),
	(881, 'Alice', 'L.', 'Christensen', 'OH046538G', '1975-09-10', 'Litigation'),
	(882, 'Elizabeth', NULL, 'Chow', 'JD090190N', '1993-06-11', 'Commercial'),
	(883, 'Tammy', 'J.', 'Chor', 'SZ178508L', '1986-05-09', 'HR'),
	(884, 'Imtiaz', NULL, 'Choin', 'SP155086F', '1987-10-15', 'HR'),
	(885, 'Karan', NULL, 'Choi', 'LC331821C', '1987-04-19', 'Litigation'),
	(886, 'Joe', NULL, 'Chisholm', 'KX185506S', '1982-05-03', 'HR'),
	(887, 'Jim', NULL, 'Chestnut', 'QL934142T', '1969-03-18', 'HR'),
	(888, 'Shane', 'S.', 'Chesnut', 'SN788734O', '1972-03-23', 'HR'),
	(889, 'Tim', NULL, 'Cheng', 'DM121766B', '1973-06-27', 'HR'),
	(890, 'Russell', NULL, 'Chen', 'QZ017917X', '1988-08-23', 'Customer Relations'),
	(891, 'Anton', NULL, 'Chen', 'FX074671I', '1980-06-06', 'Litigation'),
	(892, 'Christian', NULL, 'Chen', 'ZJ430561M', '1993-03-22', 'Customer Relations'),
	(893, 'Andrew', 'P.', 'Chen', 'IH379842N', '1973-04-28', 'Commercial'),
	(894, 'Reed', NULL, 'Charney', 'BM018513L', '1971-09-09', 'Commercial'),
	(895, 'Jim', NULL, 'Charncherngkha', 'KP535785R', '1970-07-18', 'HR'),
	(896, 'Kirk', 'T', 'Chapman', 'KJ411514D', '1975-07-25', 'Customer Relations'),
	(897, 'Eugene', NULL, 'Chapla', 'XF195304S', '1981-10-04', 'Commercial'),
	(898, 'Scott', NULL, 'Chandler', 'BN161090F', '1971-04-18', 'HR'),
	(899, 'Joy', 'R.', 'Chambers', 'MS549720X', '1968-07-01', 'Litigation'),
	(900, 'Pamala', 'M.', 'Chai', 'JR456486L', '1991-02-19', 'HR'),
	(901, 'Edward', 'J.', 'Chai', 'XP608676B', '1982-12-30', 'Customer Relations'),
	(902, 'James', 'D.', 'Cetinok', 'PD402852A', '1984-07-13', 'Customer Relations'),
	(903, 'Mitch', NULL, 'Cetinok', 'OL471107S', '1969-06-09', 'HR'),
	(904, 'James', 'J.', 'Cereghino', 'CE229476C', '1974-09-11', 'HR'),
	(905, 'Margaret', 'T.', 'Cencini', 'HF188072E', '1968-11-07', 'Customer Relations'),
	(906, 'Deepak', NULL, 'Cencini', 'PV639880Q', '1973-04-07', 'HR'),
	(907, 'Jeffrey', 'B.', 'Cavendish', 'YO060653N', '1991-01-10', 'Customer Relations'),
	(908, 'Vamsi', NULL, 'Cavallari', 'JR816360L', '1990-07-19', 'Customer Relations'),
	(909, 'Jeffrey', NULL, 'Catalano', 'WM540568R', '1989-01-04', 'Commercial'),
	(910, 'Peter', NULL, 'Casts', 'ZF191154Q', '1987-09-01', 'Customer Relations'),
	(911, 'Eric', NULL, 'Castellucio', 'KJ672849K', '1966-12-19', 'Customer Relations'),
	(912, 'Rebecca', NULL, 'Carson', 'IN066008A', '1979-02-11', 'Litigation'),
	(913, 'Cecilia', 'M.', 'Carroll', 'TK541678Y', '1993-10-14', 'HR'),
	(914, 'David', 'O', 'Carroll', 'UJ541326H', '1971-01-28', 'HR'),
	(915, 'Elsa', NULL, 'Carreras', 'OD422903I', '1987-07-24', 'HR'),
	(916, 'Michael', 'J.', 'Carothers', 'WX553384D', '1991-01-12', 'Commercial'),
	(917, 'Marjorie', 'M.', 'Caron', 'VI342149H', '1993-07-04', 'Litigation'),
	(918, 'Frank', NULL, 'Caron', 'NB686293C', '1970-03-11', 'Customer Relations'),
	(919, 'Mark', NULL, 'Caro', 'LA189735Z', '1968-07-06', 'HR'),
	(920, 'Robertson', NULL, 'Carnes', 'UL790978S', '1992-11-05', 'Customer Relations'),
	(921, 'Jolie', NULL, 'Carmody', 'XR359310F', '1969-06-26', 'HR'),
	(922, 'Roger', NULL, 'Carmichael', 'HF950512M', '1972-01-29', 'Commercial');
INSERT INTO Employee ( Emp_id, EmpFirstName, EmpMiddleName, EmpLastName, EmpGovernmentID, DateOfBirth, Department)
VALUES 	(923, 'A.', 'Francesca', 'Carlson', 'IZ304065C', '1975-01-30', 'Customer Relations'),
	(924, 'Bonnie', 'B.', 'Carlson', 'FJ141333U', '1974-02-22', 'Commercial'),
	(925, 'Gloria', 'J.', 'Carlisle', 'RG900948G', '1991-11-08', 'Litigation'),
	(926, 'Linda', NULL, 'Carey', 'NU596855S', '1976-11-12', 'Commercial'),
	(927, 'Steven', 'B.', 'Caprio', 'RC997572O', '1969-01-12', 'Litigation'),
	(928, 'Judy', NULL, 'Cao', 'AW056028N', '1988-02-15', 'Litigation'),
	(929, 'Elsie', 'L.', 'Cao', 'LF313641V', '1973-11-15', 'Litigation'),
	(930, 'George', 'Z.', 'Canuto', 'IL801291P', '1989-06-25', 'Customer Relations'),
	(931, 'Yale', NULL, 'Cantoni', 'JE287132T', '1982-08-21', 'Commercial'),
	(932, 'Yan', NULL, 'Cannon', 'BC097332I', '1970-08-18', 'Customer Relations'),
	(933, 'Yuhong', NULL, 'Campen', 'CL250786N', '1975-09-13', 'Litigation'),
	(934, 'Joseph', 'M.', 'Campbell', 'LL404684A', '1967-12-24', 'Customer Relations'),
	(935, 'Paulo', 'H.', 'Campbell', 'JX297349N', '1991-04-04', 'Customer Relations'),
	(936, 'David', 'J.', 'Campbell', 'XT868969E', '1982-09-29', 'HR'),
	(937, 'Jinghao', NULL, 'Campbell', 'JS334351D', '1985-06-28', 'Customer Relations'),
	(938, 'Kevin', NULL, 'Campbell', 'MF290137P', '1970-10-05', 'Litigation'),
	(939, 'Run', NULL, 'Cameron', 'YQ126706A', '1976-07-06', 'Customer Relations'),
	(940, 'Todd', 'R.', 'Camargo', 'DG527221J', '1988-02-16', 'Litigation'),
	(941, 'Kok-Ho', NULL, 'Camacho', 'LA170279Y', '1977-10-03', 'Litigation'),
	(942, 'John', 'K.', 'Calone', 'GO851372X', '1966-04-14', 'HR'),
	(943, 'Sharon', 'J.', 'Caldwell', 'WB260973Y', '1992-07-24', 'HR'),
	(944, 'Jeremy', NULL, 'Caldwell', 'QN802978Q', '1966-01-12', 'Commercial'),
	(945, 'Spencer', NULL, 'Calafato', 'WL297005D', '1987-10-24', 'HR'),
	(946, 'Anita', 'R.', 'Byrnes', 'UA764962F', '1979-04-11', 'Commercial'),
	(947, 'Jose', NULL, 'Byham', 'VB093520I', '1981-03-10', 'HR'),
	(948, 'Richard', NULL, 'Bustamante', 'ZD788959Z', '1967-05-24', 'Customer Relations'),
	(949, 'Judy', 'R.', 'Buskirk', 'JV255157D', '1993-07-19', 'Commercial'),
	(950, 'Sean', 'J.', 'Burton', 'UQ393247Z', '1992-11-12', 'Litigation'),
	(951, 'Helen', 'R.', 'Burnett', 'OU142404M', '1969-03-04', 'Commercial'),
	(952, 'Robert', 'P.', 'Burnett', 'RT777484O', '1980-02-22', 'Litigation'),
	(953, 'Sharon', 'F.', 'Burnell', 'GD033426N', '1976-08-07', 'Customer Relations'),
	(954, 'Robert', NULL, 'Burlacu', 'UY411512T', '1974-04-21', 'Commercial'),
	(955, 'Jenny', NULL, 'Burkhardt', 'HG313481P', '1981-04-06', 'Customer Relations'),
	(956, 'Denise', 'R.', 'Burkhardt', 'CL755050K', '1978-04-13', 'HR'),
	(957, 'Scott', NULL, 'Burke', 'RT527749E', '1975-01-24', 'Commercial'),
	(958, 'Walter', 'J.', 'Buensalido', 'AD225477Q', '1979-07-08', 'Litigation'),
	(959, 'Patrick', 'J.', 'Bueno', 'GC303740T', '1982-06-15', 'Litigation'),
	(960, 'Kimberly', 'N.', 'Bueno', 'OF438613Y', '1986-12-31', 'Customer Relations'),
	(961, 'Ajay', NULL, 'Buchanan', 'OO558713J', '1988-12-17', 'Commercial'),
	(962, 'Parul', NULL, 'Bruno', 'JZ067275X', '1986-01-31', 'Litigation'),
	(963, 'Tomas', 'M.', 'Brunner', 'DO412736A', '1973-07-21', 'HR'),
	(964, 'Kathy', 'R.', 'Bruner', 'HA718713D', '1966-05-09', 'HR'),
	(965, 'Jill', 'K.', 'Brundage', 'BT223522L', '1978-02-02', 'Litigation'),
	(966, 'Melissa', 'R.', 'Brummer', 'ZW134573L', '1986-06-08', 'Litigation'),
	(967, 'Cecelia', 'L.', 'Brumfield', 'OH846201B', '1988-01-26', 'HR'),
	(968, 'Benjamin', NULL, 'Browqett', 'IL220870V', '1984-01-14', 'Litigation'),
	(969, 'Linda', NULL, 'Browning', 'KE037025O', '1982-11-12', 'HR'),
	(970, 'Mindy', NULL, 'Browning', 'HI644313Y', '1977-12-16', 'Customer Relations'),
	(971, 'Sandra', 'I.', 'Browne', 'GY433668L', '1993-01-11', 'HR'),
	(972, 'Frank', NULL, 'Brown', 'MJ524191N', '1975-04-30', 'Litigation'),
	(973, 'Steve', NULL, 'Brown', 'LG574238J', '1985-10-18', 'HR'),
	(974, 'Joseph', NULL, 'Brown', 'QE736186Z', '1979-07-31', 'HR'),
	(975, 'Jennifer', 'J.', 'Brown', 'MI851830G', '1984-12-16', 'Commercial'),
	(976, 'Chris', NULL, 'Brown', 'JJ081300T', '1967-12-20', 'Litigation'),
	(977, 'Sandra', 'B.', 'Brown', 'SY618314Q', '1983-01-08', 'Commercial'),
	(978, 'John', 'J.', 'Brown', 'WB393023J', '1991-01-16', 'Commercial'),
	(979, 'Robin', 'M.', 'Brooks', 'FX764226X', '1993-06-24', 'Litigation'),
	(980, 'Stacie', 'K.', 'Brooks', 'VC861814N', '1976-09-16', 'Customer Relations'),
	(981, 'Katie', NULL, 'Brink', 'GM483616M', '1993-03-26', 'Commercial'),
	(982, 'Lola', 'M.', 'Brink', 'BP005359W', '1967-12-15', 'Commercial'),
	(983, 'Jane', 'A.', 'Bright', 'SV606968Q', '1966-03-15', 'Litigation'),
	(984, 'Nikki', NULL, 'Brian', 'JW170834W', '1983-04-08', 'HR'),
	(985, 'James', 'L.', 'Brewer', 'DC658421N', '1986-12-15', 'HR'),
	(986, 'Christinia', 'A.', 'Brewer', 'SS876401B', '1973-02-05', 'Litigation'),
	(987, 'Alejandro', NULL, 'Bremer', 'PA787334T', '1983-06-17', 'Commercial'),
	(988, 'Yvonne', NULL, 'Breer', 'GQ821536H', '1970-01-15', 'Litigation'),
	(989, 'Nkenge', NULL, 'Bready', 'ZI103271Y', '1990-07-22', 'HR'),
	(990, 'Nancy', 'A.', 'Brandon', 'BB001609B', '1975-05-10', 'Litigation'),
	(991, 'Nellie', 'T.', 'Bradley', 'EH208014C', '1981-05-25', 'HR'),
	(992, 'Raquel', NULL, 'Bradley', 'FJ208941L', '1985-07-07', 'Litigation'),
	(993, 'Gladys', 'F.', 'Bowman', 'YS397078Q', '1989-03-06', 'Litigation'),
	(994, 'R. Morgan', 'L.', 'Bowen', 'PL719765J', '1974-07-25', 'HR'),
	(995, 'Tosh', NULL, 'Bourne', 'OE745237D', '1970-02-21', 'Commercial'),
	(996, 'Susan', NULL, 'Boseman', 'AN840317Q', '1993-12-05', 'HR'),
	(997, 'Stephen', 'A.', 'Booth', 'PC458859Y', '1976-02-14', 'HR'),
	(998, 'Eric', 'B.', 'Bonifaz', 'MN690602C', '1987-12-18', 'HR'),
	(999, 'Helen', 'M.', 'Bolender', 'SE175877G', '1987-06-28', 'Commercial'),
	(1000, 'Deanna', NULL, 'Bohling', 'CS003751K', '1989-12-16', 'Customer Relations'),
	(1001, 'Gary', 'P.', 'Bockenkamp', 'XX917557A', '1993-04-20', 'Customer Relations'),
	(1002, 'Ramesh', NULL, 'Blythe', 'DQ978384X', '1982-09-03', 'Customer Relations'),
	(1003, 'Thomas', 'R.', 'Blythe', 'QU204627W', '1968-09-16', 'HR'),
	(1004, 'Jan', NULL, 'Blanton', 'AE939693P', '1968-07-27', 'Litigation'),
	(1005, 'Virginia', 'L.', 'Blanco', 'BE601927W', '1976-10-13', 'Commercial'),
	(1006, 'Matthew', 'J.', 'Blackwell', 'WA379265Q', '1966-01-10', 'Commercial'),
	(1007, 'Emilo', 'R.', 'Black', 'VB465608K', '1974-06-17', 'Litigation'),
	(1008, 'Ben', NULL, 'Bishop', 'KW255668M', '1992-02-01', 'Customer Relations'),
	(1009, 'Dylan', NULL, 'Bischoff', 'ID888414A', '1972-07-14', 'HR'),
	(1010, 'Frank', NULL, 'Bischoff', 'QG773225E', '1977-11-23', 'Litigation'),
	(1011, 'Neva', 'M.', 'Billstrom', 'XC380671B', '1967-05-09', 'Customer Relations'),
	(1012, 'Linda', NULL, 'Bidelman', 'VS301989O', '1994-05-10', 'HR'),
	(1013, 'Scott', NULL, 'Berry', 'NT866170N', '1968-11-14', 'Commercial'),
	(1014, 'Robert', NULL, 'Berry', 'HB967859A', '1986-04-28', 'Customer Relations'),
	(1015, 'Joseph', 'P.', 'Berndt', 'ZQ346338A', '1983-09-13', 'Commercial'),
	(1016, 'Paula', 'B.', 'Berndt', 'DW819355U', '1994-02-03', 'Customer Relations'),
	(1017, 'Suchitra', NULL, 'Bernacchi', 'TU005635C', '1994-01-06', 'Commercial'),
	(1018, 'Jonathan', NULL, 'Berglund', 'CS653898E', '1994-07-16', 'Customer Relations'),
	(1019, 'William', 'J.', 'Berglund', 'SR792002J', '1980-09-09', 'Commercial'),
	(1020, 'Alan', 'L.', 'Bergin', 'XQ468558C', '1978-11-02', 'Litigation'),
	(1021, 'Hillaine', 'N.', 'Berger', 'TY832084I', '1980-09-04', 'Commercial'),
	(1022, 'Bobby', NULL, 'Berger', 'ER424299K', '1971-02-21', 'Commercial');
INSERT INTO Employee ( Emp_id, EmpFirstName, EmpMiddleName, EmpLastName, EmpGovernmentID, DateOfBirth, Department)
VALUES 	(1023, 'Barbara', NULL, 'Berge', 'NC102805F', '1976-03-02', 'Commercial'),
	(1024, 'Jon', NULL, 'Berge', 'HZ929919B', '1977-03-26', 'Commercial'),
	(1025, 'Julia', NULL, 'Berg', 'VP409994W', '1991-04-30', 'Litigation'),
	(1026, 'Marie', 'E.', 'Berch', 'UR180099N', '1990-05-27', 'HR'),
	(1027, 'Zheng', NULL, 'Bentley', 'MS974365J', '1966-10-10', 'Customer Relations'),
	(1028, 'Salman', NULL, 'Bent', 'WM640274Q', '1988-01-22', 'Customer Relations'),
	(1029, 'Albert', NULL, 'Benson', 'JX502384P', '1980-10-28', 'Litigation'),
	(1030, 'Stuart', NULL, 'Benson', 'CN063389X', '1973-06-02', 'Litigation'),
	(1031, 'Billie Jo', NULL, 'Benson', 'GJ019926O', '1980-05-15', 'Customer Relations'),
	(1032, 'Dorothy', 'J.', 'Benshoof', 'SO656875I', '1991-01-09', 'Customer Relations'),
	(1033, 'Ken', NULL, 'Ben-Sachar', 'CM175816G', '1975-08-09', 'Litigation'),
	(1034, 'Suzanne', NULL, 'Bennetts', 'DZ396929O', '1967-10-17', 'Litigation'),
	(1035, 'Mandar', NULL, 'Bendixen', 'AZ157827U', '1977-01-05', 'HR'),
	(1036, 'Greg', 'F.', 'Belli', 'GZ913040T', '1990-12-23', 'Customer Relations'),
	(1037, 'Mike', NULL, 'Beebe', 'MC067597G', '1976-07-10', 'Commercial'),
	(1038, 'Lorraine', NULL, 'Becker', 'NQ852758G', '1994-02-13', 'Litigation'),
	(1039, 'Alex', NULL, 'Beck', 'UC270361K', '1975-11-04', 'Litigation'),
	(1040, 'Jan', 'R.', 'Beck', 'KI613564S', '1974-03-25', 'Commercial'),
	(1041, 'Amir', 'T.', 'Beaver', 'JZ521596W', '1978-10-19', 'Litigation'),
	(1042, 'Donals', 'E.', 'Beasley', 'DO076495Q', '1988-01-22', 'Commercial'),
	(1043, 'Toby', NULL, 'Beanston', 'FZ283818Q', '1986-08-07', 'Customer Relations'),
	(1044, 'Laura', NULL, 'Bauer', 'LH806571H', '1981-08-12', 'Commercial'),
	(1045, 'Fred', NULL, 'Bates', 'IM473292D', '1970-07-10', 'Litigation'),
	(1046, 'Michael', 'J', 'Barzdukas', 'NI590831Y', '1990-09-30', 'HR'),
	(1047, 'Tim', NULL, 'Bartness', 'ZM777711V', '1968-01-19', 'Commercial'),
	(1048, 'Tina', 'Slone', 'Barreto de Mattos', 'OJ626412K', '1991-07-14', 'Litigation'),
	(1049, 'Robert', NULL, 'Barrera', 'JL924265N', '1977-12-09', 'Litigation'),
	(1050, 'Nino', 'E.', 'Barr', 'AP843581P', '1982-07-26', 'Litigation'),
	(1051, 'Lee', 'M.', 'Barnhill', 'AW943342N', '1989-01-22', 'Commercial'),
	(1052, 'Tad', NULL, 'Barlow', 'JQ557934J', '1991-10-30', 'Customer Relations'),
	(1053, 'Gloria', 'B.', 'Barley', 'DH215642N', '1981-10-24', 'Customer Relations'),
	(1054, 'Fred', 'A.', 'Barker', 'TT150540Z', '1979-08-14', 'HR'),
	(1055, 'John', 'E.', 'Barber', 'NY576557A', '1986-07-04', 'Commercial'),
	(1056, 'David', 'J.', 'Barber', 'NJ752114F', '1992-01-02', 'Litigation'),
	(1057, 'Michiko', NULL, 'Barbariol', 'FT180201A', '1977-06-24', 'Commercial'),
	(1058, 'Stu', 'J.', 'Barbariol', 'IY095198Y', '1979-03-12', 'Commercial'),
	(1059, 'Scott', NULL, 'Banks', 'SQ998241S', '1966-08-29', 'Commercial'),
	(1060, 'Lori', NULL, 'Banack', 'LC840336C', '1968-07-18', 'Customer Relations'),
	(1061, 'Jyothi', NULL, 'Baltazar', 'PA469885S', '1994-02-12', 'HR'),
	(1062, 'Cristian', 'B.', 'Bales', 'BO566967F', '1973-03-27', 'Customer Relations'),
	(1063, 'Mosha', 'M.', 'Baldwin', 'BZ645851A', '1989-07-01', 'Commercial'),
	(1064, 'Rajesh', 'M.', 'Baker', 'YP561899I', '1969-08-28', 'Customer Relations'),
	(1065, 'Shyamalan', NULL, 'Baker', 'DO092936I', '1966-02-11', 'HR'),
	(1066, 'Michael', NULL, 'Bailey', 'LO505145H', '1969-06-03', 'Litigation'),
	(1067, 'Trish', 'E.', 'Bacon', 'YB943177K', '1978-12-22', 'Customer Relations'),
	(1068, 'Frank', NULL, 'Bacalzo', 'RA314402X', '1969-12-20', 'Litigation'),
	(1069, 'Lionel', NULL, 'Ayers', 'FQ370178P', '1994-05-06', 'Customer Relations'),
	(1070, 'Elizabeth', 'M.', 'Avalos', 'JE561669D', '1978-10-23', 'HR'),
	(1071, 'John', NULL, 'Ault', 'JI807342D', '1994-01-28', 'Litigation'),
	(1072, 'Jonathan', NULL, 'Atkinson', 'UL027119G', '1978-07-10', 'Litigation'),
	(1073, 'Tina', 'A.', 'Ashton', 'AJ469079S', '1992-12-08', 'Commercial'),
	(1074, 'James', NULL, 'Arthur', 'QR853464O', '1968-01-10', 'Litigation'),
	(1075, 'Glin', 'J.', 'Armstrong', 'YV849506A', '1980-09-29', 'Customer Relations'),
	(1076, 'Sara', 'E.', 'Arifin', 'PS647304M', '1988-08-10', 'Commercial'),
	(1077, 'Carol', NULL, 'Arbelaez', 'RV029248P', '1984-02-26', 'Litigation'),
	(1078, 'Patricia', 'B.', 'Arakawa', 'FW768958S', '1977-09-17', 'Litigation'),
	(1079, 'Pat', 'R.', 'Appelbaum', 'OW217362W', '1974-07-01', 'Customer Relations'),
	(1080, 'Paulo', 'Sergio Da Silva', 'Antrim', 'VC400216G', '1993-03-16', 'HR'),
	(1081, 'Deborah', NULL, 'Ansman-Wolfe', 'MW560897X', '1985-01-03', 'Litigation'),
	(1082, 'Grigory', NULL, 'Anderson', 'VP526768T', '1985-02-24', 'HR'),
	(1083, 'Carole', NULL, 'Anderson', 'RH695659X', '1994-01-09', 'Commercial'),
	(1084, 'Cheryl', 'J.', 'Amland', 'DD358671E', '1987-03-27', 'Commercial'),
	(1085, 'Alma', 'B.', 'Alvaro', 'BY431401F', '1989-06-16', 'Litigation'),
	(1086, 'Ethel', 'J.', 'Alvarado', 'NV248550D', '1971-03-19', 'Commercial'),
	(1087, 'Constance', 'J.', 'Altman', 'JK760148U', '1983-05-13', 'Customer Relations'),
	(1088, 'Josh', NULL, 'Altamirano', 'RJ687256C', '1985-05-03', 'Commercial'),
	(1089, 'Betty', 'J.', 'Alpuerto', 'KK094988I', '1987-04-07', 'Commercial'),
	(1090, 'Fred', NULL, 'Allison', 'KJ033587B', '1988-07-28', 'Customer Relations'),
	(1091, 'Jeff', NULL, 'Allen', 'GV583995L', '1993-09-01', 'Customer Relations'),
	(1092, 'Milton', 'M.', 'Allen', 'WM609631E', '1989-10-07', 'Litigation'),
	(1093, 'Sean', NULL, 'Allen', 'VW916453K', '1983-09-23', 'Litigation'),
	(1094, 'Monica', 'L.', 'Alexander', 'KN465627X', '1966-01-14', 'Customer Relations'),
	(1095, 'Mary Lou', 'M.', 'Alexander', 'MO788270Y', '1979-07-30', 'HR'),
	(1096, 'Kim', NULL, 'Alexander', 'WD058793L', '1983-07-13', 'Litigation'),
	(1097, 'Susan', 'J.', 'Alexander', 'ZO304714B', '1968-02-09', 'HR'),
	(1098, 'Cynthia', NULL, 'Alderson', 'IR329222F', '1974-03-22', 'Commercial'),
	(1099, 'Arvind', 'B.', 'Alderson', 'EN565285P', '1981-08-05', 'Litigation'),
	(1100, 'Simon', NULL, 'Alcorn', 'EA250605E', '1986-08-29', 'Customer Relations'),
	(1101, 'Michael', 'S', 'Albury', 'OP318819A', '1994-07-29', 'Customer Relations'),
	(1102, 'Suzann', 'K.', 'Albright', 'XD840663H', '1993-02-04', 'Commercial'),
	(1103, 'Michelle', 'B.', 'Alberts', 'FZ432631V', '1990-11-06', 'Commercial'),
	(1104, 'Jamie', NULL, 'Alberts', 'BV219800A', '1979-08-05', 'HR'),
	(1105, 'Russell', 'A.', 'Alan', 'DH890532J', '1976-11-20', 'Litigation'),
	(1106, 'Celine', 'J.', 'Alameda', 'ZM987046H', '1990-06-17', 'Litigation'),
	(1107, 'Randy', NULL, 'Akers', 'TM416246X', '1974-10-24', 'Commercial'),
	(1108, 'Enoch', 'T', 'Ajenstat', 'EL950992N', '1969-06-21', 'Customer Relations'),
	(1109, 'Eric', 'E.', 'Ahlering', 'WU396296H', '1973-07-11', 'Litigation'),
	(1110, 'Adam', 'J.', 'Aguilar', 'ZK440292J', '1974-08-19', 'Commercial'),
	(1111, 'Constance', 'J.', 'Agcaoili', 'IH726684U', '1982-05-05', 'Commercial'),
	(1112, 'Albert', 'A.', 'Adina', 'YU941028F', '1977-09-12', 'Litigation'),
	(1113, 'Dave', NULL, 'Adams', 'BT838811S', '1980-07-30', 'Customer Relations'),
	(1114, 'Jack', 'S.', 'Adams', 'RM959786Z', '1969-10-12', 'Customer Relations'),
	(1115, 'Marie', 'M.', 'Adams', 'ZJ404659F', '1978-12-05', 'Customer Relations'),
	(1116, 'William', 'J.', 'Adams', 'SD789927F', '1976-03-15', 'Litigation'),
	(1117, 'Thomas', 'M.', 'Ackerman', 'BL295746T', '1986-11-09', 'Litigation'),
	(1118, 'Stacy', 'K.', 'Ackerman', 'PH247516E', '1974-09-15', 'HR'),
	(1119, 'Leota', 'J.', 'Achong', 'ZJ703888I', '1990-08-18', 'Customer Relations'),
	(1120, 'David', 'R.', 'Acevedo', 'KW702800W', '1974-08-07', 'Customer Relations'),
	(1121, 'Rebecca', 'A.', 'Abolrous', 'CW642373N', '1976-05-22', 'Customer Relations'),
	(1122, 'Dorothy', 'B.', 'Abercrombie', 'YI940573H', '1966-09-07', 'Litigation');
INSERT INTO Employee ( Emp_id, EmpFirstName, EmpMiddleName, EmpLastName, EmpGovernmentID, DateOfBirth, Department)
   VALUES 	(1123, 'Carol Ann', 'F.', 'Abercrombie', 'EV388053U', '1987-02-01', 'Litigation'),
	(1124, 'Scott', 'M.', 'Abel', 'LF569337J', '1983-09-13', 'HR'),
	(1125, 'Jim', NULL, 'Abbas', 'QC172094F', '1980-11-09', 'Litigation');

-- Populating EmpTransaction


	
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(-964.05, '20150526', 658),
	(-105.23, '20150914', 987),
	(-506.8, '20150505', 695),
	(239.55, '20141224', 766),
	(672.19, '20151031', 629),
	(38.63, '20141013', 109),
	(282.36, '20141115', 864),
	(72.03, '20151007', 804),
	(-283.63, '20150506', 245),
	(-1.07, '20140418', 1010),
	(839.73, '20140131', 1105),
	(-613.61, '20141019', 744),
	(-964.58, '20140705', 261),
	(-2.77, '20150515', 132),
	(-334.5, '20150904', 994),
	(-697.83, '20151205', 1007),
	(281.46, '20151021', 552),
	(478.3, '20140626', 388),
	(-495.4, '20150601', 40),
	(786.47, '20141226', 423),
	(656.65, '20140622', 1121),
	(-167.06, '20151120', 725),
	(-4.19, '20140726', 188),
	(-665.55, '20140109', 1062),
	(-485.6, '20140731', 825),
	(-263.27, '20140531', 1109),
	(552.03, '20150817', 652),
	(324.12, '20141001', 178),
	(898.56, '20141019', 1025),
	(614.83, '20150207', 831),
	(-309.04, '20150222', 1101),
	(591.86, '20140612', 140),
	(-105.61, '20141101', 563),
	(11.93, '20150805', 39),
	(224.83, '20140723', 13),
	(357.18, '20151204', 593),
	(-631.86, '20151025', 340),
	(-454.75, '20150925', 640),
	(-476.29, '20140928', 664),
	(670.42, '20150830', 303),
	(3.87, '20150409', 996),
	(482.08, '20140307', 235),
	(-527.78, '20140610', 700),
	(-106.81, '20141001', 732),
	(-868.56, '20150730', 782),
	(346.35, '20140325', 509),
	(803.01, '20150813', 1054),
	(893.38, '20141031', 928),
	(-379.69, '20151203', 351),
	(468.04, '20151224', 227),
	(775.33, '20140504', 873),
	(-463.25, '20151130', 307),
	(-158.78, '20150627', 1076),
	(296.07, '20150623', 170),
	(-369.69, '20150409', 129),
	(456.52, '20140124', 1102),
	(789.03, '20150713', 343),
	(51.59, '20150306', 787),
	(623.87, '20141201', 368),
	(-185.11, '20150519', 594),
	(554.05, '20150829', 1077),
	(-600.03, '20151010', 331),
	(-887.41, '20151005', 743),
	(314.44, '20150322', 407),
	(148.59, '20141115', 678),
	(959.44, '20140329', 982),
	(361.52, '20140701', 324),
	(-141.86, '20150601', 218),
	(-127.13, '20140824', 546),
	(18.65, '20150717', 827),
	(118.93, '20141117', 659),
	(-175.94, '20140319', 982),
	(461.88, '20150223', 21),
	(787.97, '20141115', 687),
	(61.96, '20150612', 11),
	(-329.15, '20151031', 411),
	(245.34, '20140610', 353),
	(-865.74, '20150409', 443),
	(98.35, '20140731', 905),
	(-643.77, '20151027', 151),
	(310.53, '20140211', 898),
	(-508.6, '20140819', 532),
	(896.07, '20141031', 321),
	(-364.94, '20140815', 100),
	(0.89, '20140130', 714),
	(628.69, '20140205', 295),
	(-821.17, '20150622', 386),
	(473.8, '20140319', 744),
	(642.72, '20140425', 80),
	(693.35, '20141120', 308),
	(958.94, '20150225', 200),
	(856.55, '20150122', 1026),
	(107.88, '20141118', 22),
	(-997.35, '20141125', 653),
	(828.05, '20141008', 810),
	(-547.78, '20150414', 303),
	(408.81, '20141213', 774),
	(-428.31, '20140925', 723),
	(643.94, '20141118', 564),
	(424.34, '20151022', 769);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(-349.52, '20140419', 486),
	(-783.89, '20151110', 722),
	(964.31, '20150610', 513),
	(-355.55, '20150706', 749),
	(201.78, '20140228', 1007),
	(112.6, '20141124', 905),
	(-116.16, '20151105', 569),
	(-787.64, '20150818', 702),
	(722.41, '20140929', 878),
	(276.09, '20150617', 1086),
	(33.65, '20140202', 53),
	(46.5, '20141030', 219),
	(886.75, '20150214', 696),
	(92.85, '20141211', 1045),
	(-763.39, '20151218', 1035),
	(937.37, '20140522', 588),
	(-405.23, '20151107', 1114),
	(572.55, '20150906', 77),
	(239.78, '20150928', 1),
	(414.87, '20150921', 466),
	(107.9, '20140928', 582),
	(954.48, '20150126', 221),
	(-811.21, '20140123', 119),
	(-215.53, '20150412', 576),
	(640.3, '20150802', 531),
	(-561.7, '20150721', 599),
	(-210.73, '20141128', 1121),
	(-442.27, '20140223', 985),
	(-930.72, '20150711', 955),
	(-68.27, '20151214', 307),
	(-132.42, '20140706', 32),
	(685.68, '20150110', 1069),
	(-668.14, '20150126', 120),
	(-543.44, '20140709', 72),
	(-435.16, '20141214', 170),
	(40.13, '20140311', 932),
	(856.38, '20140819', 741),
	(256.93, '20140105', 242),
	(-143.43, '20150524', 858),
	(-91.41, '20141015', 903),
	(-543.65, '20150213', 53),
	(-747.41, '20150419', 643),
	(819.52, '20150409', 918),
	(542.1, '20140428', 824),
	(-292.23, '20150811', 1044),
	(23.06, '20140201', 1084),
	(175.81, '20140715', 929),
	(-780.12, '20150704', 836),
	(515.1, '20140604', 471),
	(-763.58, '20141029', 795),
	(-522.14, '20140625', 735),
	(726.97, '20140528', 527),
	(642.53, '20150729', 625),
	(-449.54, '20150730', 592),
	(716.8, '20140828', 388),
	(644.9, '20141026', 704),
	(91.3, '20151104', 607),
	(-110.78, '20140601', 141),
	(45.44, '20140705', 1112),
	(-257.22, '20140317', 77),
	(-737.99, '20150205', 791),
	(-170.32, '20150719', 775),
	(-765.51, '20150216', 349),
	(764.87, '20150125', 887),
	(-486.61, '20140211', 386),
	(-768.58, '20140926', 848),
	(184.63, '20140406', 816),
	(240.53, '20141212', 924),
	(886.29, '20140119', 951),
	(-4.12, '20150907', 294),
	(-319.11, '20141225', 419),
	(-932.09, '20141012', 188),
	(994.31, '20141018', 280),
	(-356.08, '20141123', 629),
	(-293.19, '20140514', 44),
	(85.32, '20150710', 389),
	(606.53, '20150416', 493),
	(-73.84, '20140723', 801),
	(-736.17, '20140622', 633),
	(344.9, '20140202', 680),
	(-21.63, '20150828', 252),
	(-253.43, '20150709', 559),
	(969.48, '20150916', 968),
	(328.38, '20140619', 23),
	(874.36, '20140108', 938),
	(90.21, '20140827', 566),
	(525.16, '20140907', 727),
	(-452.14, '20150224', 832),
	(-146.88, '20140731', 98),
	(-105.76, '20150418', 1010),
	(-761.76, '20141122', 296),
	(-82.78, '20140622', 435),
	(330.23, '20151221', 308),
	(998.79, '20150801', 503),
	(145.2, '20140407', 434),
	(743.32, '20140105', 21),
	(-643.92, '20140318', 696),
	(-839.23, '20151022', 842),
	(807.47, '20150412', 552),
	(-396.34, '20140202', 812);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(-473.43, '20150721', 1125),
	(-573.11, '20150822', 640),
	(-53.13, '20140505', 49),
	(278.01, '20150512', 185),
	(273.32, '20150705', 833),
	(201.26, '20150607', 162),
	(787.56, '20141025', 1039),
	(-289.41, '20140212', 912),
	(82.62, '20151202', 427),
	(96.11, '20151118', 931),
	(778.29, '20140705', 335),
	(397.42, '20140508', 850),
	(-733.01, '20140420', 708),
	(877.03, '20140717', 877),
	(-519.49, '20150415', 332),
	(520.48, '20141205', 912),
	(390.87, '20141012', 871),
	(-258.8, '20150927', 77),
	(-977.09, '20140327', 989),
	(-973.32, '20140213', 269),
	(-222.84, '20141002', 442),
	(375.07, '20150630', 594),
	(-326.77, '20150709', 276),
	(-753.03, '20150802', 263),
	(-275.49, '20151223', 511),
	(14.77, '20141228', 825),
	(-523.6, '20140423', 203),
	(-367.62, '20150310', 792),
	(-358.23, '20140627', 261),
	(-930.35, '20140204', 871),
	(524.26, '20141129', 1035),
	(182.94, '20150731', 784),
	(-922.69, '20140227', 655),
	(-732.96, '20140609', 553),
	(192.3, '20140228', 538),
	(24.73, '20150204', 851),
	(280.97, '20141212', 314),
	(900.96, '20140424', 956),
	(854.02, '20140116', 514),
	(868.4, '20140822', 360),
	(609.86, '20151208', 458),
	(-552.75, '20141220', 327),
	(-710.57, '20140326', 839),
	(636.16, '20140527', 284),
	(-681.66, '20151119', 411),
	(-834.27, '20150717', 824),
	(-706.31, '20140608', 730),
	(71.44, '20150812', 317),
	(490.25, '20150524', 264),
	(-915.46, '20150315', 995),
	(185.78, '20150911', 984),
	(-496.42, '20140105', 920),
	(-393.59, '20141125', 639),
	(900.19, '20151116', 543),
	(-885.16, '20140807', 380),
	(20.14, '20150710', 688),
	(874.12, '20140701', 567),
	(944.83, '20140830', 911),
	(569.23, '20151002', 511),
	(999.03, '20150131', 305),
	(318.1, '20140717', 922),
	(58.38, '20140901', 1037),
	(-342.56, '20150222', 762),
	(392.14, '20140927', 806),
	(751.91, '20140606', 740),
	(535.48, '20150618', 966),
	(272.59, '20150529', 403),
	(264.72, '20140202', 146),
	(-916.8, '20150705', 589),
	(714.72, '20141219', 1002),
	(445.69, '20151115', 694),
	(981.18, '20150421', 131),
	(909.67, '20140822', 494),
	(-177.23, '20150630', 112),
	(-360.37, '20140723', 341),
	(-159.74, '20150819', 783),
	(-136.3, '20140103', 704),
	(17.21, '20140227', 541),
	(569.51, '20141121', 797),
	(330.64, '20150627', 385),
	(405.63, '20140226', 704),
	(-584.17, '20150724', 349),
	(999.98, '20141123', 673),
	(-441.13, '20150903', 1005),
	(338.19, '20150927', 292),
	(-848.97, '20150830', 155),
	(635.1, '20140708', 171),
	(175.64, '20140622', 720),
	(33.98, '20140430', 155),
	(508.28, '20140413', 431),
	(-642.23, '20150831', 1035),
	(-367.35, '20150714', 557),
	(733.02, '20140327', 222),
	(-969.43, '20140820', 773),
	(-451.44, '20140312', 28),
	(-876.77, '20151023', 508),
	(-325.55, '20150821', 220),
	(995.64, '20140319', 260),
	(-250.92, '20140913', 1082),
	(616.18, '20140103', 389);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(71.84, '20140212', 504),
	(243.73, '20150624', 282),
	(953.95, '20150203', 308),
	(155.49, '20140604', 651),
	(-531.63, '20150208', 1008),
	(-946.77, '20150530', 992),
	(22.67, '20150523', 84),
	(-197.35, '20150518', 1044),
	(-708.85, '20140502', 397),
	(333.02, '20150929', 714),
	(-423.51, '20140604', 289),
	(-710.89, '20140928', 877),
	(-601.87, '20150917', 441),
	(775.93, '20150729', 866),
	(-246.36, '20150818', 244),
	(866.12, '20140717', 144),
	(681.59, '20151013', 754),
	(-582.69, '20150829', 204),
	(-967.29, '20150626', 599),
	(123.79, '20150612', 368),
	(634.03, '20150512', 19),
	(-406.75, '20150206', 189),
	(-280.16, '20140410', 110),
	(981.54, '20140923', 969),
	(-343.5, '20140202', 182),
	(-887.54, '20140406', 315),
	(-186.35, '20140914', 383),
	(-4.23, '20150103', 553),
	(224.75, '20151121', 459),
	(670.27, '20150426', 568),
	(715.22, '20150824', 570),
	(-919.19, '20140709', 992),
	(-571, '20140820', 127),
	(-769.3, '20140320', 117),
	(407.56, '20140302', 68),
	(8.24, '20140430', 362),
	(644.54, '20140525', 610),
	(-468.16, '20140324', 797),
	(383.81, '20151017', 400),
	(-172.6, '20140105', 1109),
	(-489.94, '20150411', 513),
	(-849.88, '20150521', 503),
	(-523.75, '20140109', 546),
	(-991.78, '20140506', 616),
	(293.52, '20140721', 245),
	(889.91, '20150712', 562),
	(426.75, '20140118', 545),
	(-650.24, '20140913', 572),
	(454.34, '20150307', 726),
	(677.89, '20151119', 1050),
	(-36.32, '20150918', 147),
	(907.5, '20140526', 275),
	(-521.6, '20151107', 794),
	(356, '20150422', 1036),
	(838.94, '20150214', 409),
	(-465.7, '20150316', 441),
	(804.5, '20141115', 765),
	(994.79, '20151010', 770),
	(-757.73, '20141003', 432),
	(879.56, '20150215', 865),
	(336.53, '20150913', 1118),
	(-772.53, '20140302', 951),
	(-947.13, '20141013', 1024),
	(-780.38, '20150121', 179),
	(956.28, '20150525', 946),
	(-55, '20140511', 21),
	(259.63, '20150927', 699),
	(77.22, '20150512', 457),
	(-776.82, '20150301', 692),
	(-771.54, '20151211', 302),
	(-17.99, '20140705', 112),
	(-101.69, '20140623', 3),
	(-964.68, '20140225', 1018),
	(488.63, '20141220', 293),
	(-2.26, '20140714', 980),
	(-89.6, '20151118', 778),
	(-52.1, '20141229', 466),
	(-534.25, '20150331', 117),
	(610.63, '20141003', 12),
	(-778.16, '20150711', 383),
	(-337.75, '20150726', 43),
	(156.21, '20150312', 225),
	(945.74, '20151111', 1090),
	(228.51, '20151231', 126),
	(228.62, '20140223', 1037),
	(-38.59, '20151010', 904),
	(-314.4, '20140114', 289),
	(-205.07, '20150329', 921),
	(530.22, '20140406', 221),
	(723.14, '20140726', 1051),
	(152.02, '20140714', 1119),
	(245.04, '20140418', 556),
	(657.94, '20141130', 1079),
	(608.68, '20150517', 980),
	(-326.19, '20141114', 608),
	(471.57, '20141203', 440),
	(280.84, '20151027', 595),
	(684.68, '20150423', 632),
	(137.22, '20140710', 916),
	(-482.6, '20151011', 488);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(108.73, '20151031', 805),
	(998.29, '20150427', 196),
	(580.85, '20150814', 100),
	(419.69, '20140907', 1083),
	(379.48, '20150713', 509),
	(269.61, '20150302', 338),
	(471, '20140122', 967),
	(184.83, '20160101', 928),
	(242.14, '20140706', 565),
	(-52.65, '20151102', 930),
	(38.81, '20140704', 525),
	(743.86, '20140912', 459),
	(799.25, '20151116', 157),
	(-671.67, '20141204', 960),
	(-69.72, '20140213', 1053),
	(-681.91, '20140118', 943),
	(260.7, '20140201', 758),
	(195.29, '20140709', 1047),
	(-917.78, '20150612', 1085),
	(-668.15, '20150415', 658),
	(-699.85, '20140317', 701),
	(887.84, '20140306', 5),
	(-851.56, '20140708', 144),
	(-812.46, '20150508', 586),
	(469.6, '20150120', 15),
	(288.64, '20140416', 1022),
	(589.81, '20150603', 951),
	(-891.74, '20150414', 994),
	(897.94, '20150327', 509),
	(-821, '20150129', 1074),
	(451.11, '20150521', 923),
	(312.25, '20150123', 394),
	(416.62, '20150729', 503),
	(635.41, '20141016', 1007),
	(-613.16, '20140107', 851),
	(-471.62, '20150419', 343),
	(-988.9, '20150312', 1053),
	(386.71, '20140302', 413),
	(-441.7, '20150613', 647),
	(956.81, '20150607', 720),
	(-650.2, '20150623', 251),
	(554.08, '20150427', 1119),
	(-110.97, '20150517', 419),
	(-986.89, '20140218', 662),
	(-775.25, '20141217', 946),
	(-720.49, '20151003', 407),
	(526.34, '20140724', 76),
	(927.58, '20140707', 1092),
	(277.34, '20141201', 815),
	(-934.77, '20150517', 84),
	(-540.53, '20150901', 1014),
	(-697.79, '20150401', 434),
	(-853.41, '20141121', 282),
	(-355.56, '20151205', 219),
	(-292.51, '20141212', 782),
	(700.99, '20141201', 697),
	(257.31, '20140710', 469),
	(-880.17, '20150807', 906),
	(-517.57, '20150720', 686),
	(-839.82, '20150613', 811),
	(-415.21, '20150309', 1023),
	(-430.04, '20141220', 787),
	(-335.58, '20150207', 811),
	(-462.45, '20150501', 815),
	(567.81, '20140107', 227),
	(248.78, '20140711', 114),
	(783.08, '20140905', 804),
	(-148.7, '20150915', 162),
	(367.15, '20140512', 345),
	(-415.81, '20150316', 582),
	(42.18, '20150921', 519),
	(612.42, '20150325', 676),
	(833.08, '20151005', 467),
	(176.47, '20140131', 16),
	(433.48, '20140401', 723),
	(-539.45, '20150713', 100),
	(-76.1, '20140220', 963),
	(897.37, '20140805', 667),
	(453.21, '20150827', 770),
	(136.85, '20150606', 271),
	(982.1, '20150518', 313),
	(-234.83, '20140916', 894),
	(298.26, '20150728', 915),
	(-672.08, '20140112', 953),
	(134.97, '20151104', 803),
	(900.77, '20150920', 281),
	(-64.2, '20150504', 319),
	(-189.11, '20151206', 166),
	(-453.78, '20150626', 944),
	(-849.93, '20160101', 653),
	(827.84, '20140826', 278),
	(3.42, '20140929', 164),
	(-164.4, '20140917', 982),
	(942.67, '20141216', 477),
	(913.08, '20150506', 149),
	(-579.31, '20141110', 1042),
	(-600.04, '20140817', 2),
	(26.85, '20150316', 22),
	(107.95, '20140914', 359),
	(914.66, '20140314', 595);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(844.77, '20141028', 930),
	(733.13, '20140306', 448),
	(-114.44, '20151020', 1068),
	(935.64, '20151022', 707),
	(-115.78, '20150228', 770),
	(-164.34, '20151109', 1125),
	(-778.99, '20141215', 332),
	(-957.19, '20151206', 549),
	(14.31, '20150816', 864),
	(853.4, '20140414', 619),
	(977.71, '20150628', 1088),
	(781.88, '20150419', 160),
	(-117.81, '20150423', 199),
	(118.35, '20151030', 72),
	(-655.17, '20140619', 278),
	(444.44, '20141229', 209),
	(83.87, '20140925', 539),
	(979.38, '20151016', 174),
	(438.47, '20150820', 251),
	(142.54, '20150712', 514),
	(405.63, '20151216', 789),
	(-7.14, '20150502', 269),
	(-574.21, '20150913', 373),
	(738.45, '20151205', 9),
	(-315.82, '20150525', 833),
	(123.59, '20151001', 49),
	(-653.95, '20150523', 103),
	(809.99, '20140424', 568),
	(218.47, '20140130', 610),
	(-580.88, '20140328', 765),
	(570.96, '20140811', 12),
	(-101.79, '20140513', 600),
	(608.49, '20151124', 311),
	(-161.51, '20151117', 677),
	(-785.62, '20151211', 674),
	(477.58, '20150322', 457),
	(40.75, '20140727', 287),
	(898.99, '20151108', 995),
	(-117.62, '20150529', 871),
	(234.55, '20140127', 655),
	(-790.57, '20150508', 257),
	(971.57, '20150722', 623),
	(935.36, '20140216', 1109),
	(721, '20151005', 112),
	(-431.62, '20140805', 955),
	(414.3, '20150315', 588),
	(-937.13, '20141028', 489),
	(150.21, '20140809', 16),
	(-294.56, '20140820', 1013),
	(526.33, '20141119', 17),
	(408.77, '20150819', 816),
	(-13.11, '20150115', 935),
	(723.23, '20150126', 1001),
	(704.53, '20150712', 668),
	(-637.46, '20150505', 1086),
	(228.38, '20150812', 339),
	(-399.14, '20151206', 319),
	(386.23, '20150807', 231),
	(507.66, '20140430', 268),
	(-834.97, '20150206', 280),
	(350.66, '20150513', 1098),
	(573.98, '20150323', 638),
	(-421.89, '20140910', 514),
	(818.17, '20150513', 787),
	(402.43, '20150307', 1003),
	(424.27, '20150214', 459),
	(225.92, '20150218', 509),
	(-50.21, '20151106', 1052),
	(528.89, '20141125', 215),
	(-230.06, '20150814', 362),
	(762.64, '20140728', 731),
	(-254.05, '20140330', 114),
	(96.52, '20141212', 311),
	(-456.62, '20140119', 170),
	(-647.83, '20140807', 699),
	(691.42, '20151114', 358),
	(781.34, '20140617', 547),
	(-142.38, '20150630', 503),
	(861.16, '20140521', 132),
	(542.28, '20150226', 918),
	(242.5, '20150606', 912),
	(-434.45, '20160101', 346),
	(-106.09, '20140611', 790),
	(276.96, '20150701', 656),
	(313.12, '20140311', 184),
	(835.16, '20140810', 108),
	(-998.51, '20141031', 828),
	(270.31, '20140430', 763),
	(143.1, '20140728', 217),
	(-564.79, '20150601', 1075),
	(991.96, '20150909', 45),
	(347.7, '20150910', 511),
	(-58.84, '20150107', 116),
	(-521.08, '20140410', 757),
	(48.83, '20150603', 467),
	(895.71, '20140926', 3),
	(94.86, '20150416', 944),
	(177.95, '20151213', 1076),
	(469.99, '20151230', 486),
	(986.76, '20140916', 6);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(609.03, '20150307', 927),
	(16.69, '20150113', 961),
	(364.46, '20150820', 985),
	(642.34, '20140205', 1087),
	(295.2, '20150726', 150),
	(170.32, '20150709', 776),
	(-419.2, '20151030', 543),
	(-815.05, '20140208', 721),
	(-240.4, '20150621', 618),
	(992.26, '20150514', 1053),
	(-395.87, '20140506', 653),
	(-140.82, '20140503', 366),
	(-803.33, '20140701', 1032),
	(-943.13, '20141103', 405),
	(-300.6, '20140718', 324),
	(562.61, '20140218', 380),
	(482.31, '20150624', 1050),
	(-357.68, '20150805', 984),
	(388.37, '20140918', 582),
	(-700.75, '20150410', 1107),
	(662.86, '20140214', 629),
	(-9.08, '20140520', 462),
	(324.62, '20151020', 680),
	(900.87, '20150906', 885),
	(-619.49, '20150927', 37),
	(-857.23, '20150712', 375),
	(476.05, '20140525', 444),
	(-160.6, '20140116', 1062),
	(448.89, '20150801', 936),
	(913.36, '20150412', 202),
	(-815.11, '20140630', 419),
	(-870.73, '20140831', 1068),
	(250.6, '20150106', 802),
	(788.72, '20150422', 221),
	(-356.63, '20140127', 819),
	(487.16, '20150602', 978),
	(662.03, '20140111', 548),
	(743.3, '20140902', 1023),
	(-540.08, '20150728', 763),
	(-689.59, '20150806', 965),
	(315.55, '20141225', 317),
	(202.8, '20150401', 84),
	(176.94, '20140109', 699),
	(644.32, '20140319', 467),
	(728.95, '20140619', 564),
	(-205.4, '20150324', 75),
	(-555.43, '20140807', 315),
	(-640.54, '20150527', 81),
	(-187.83, '20150321', 420),
	(-748.94, '20140529', 799),
	(-588.3, '20151210', 283),
	(301.87, '20151202', 291),
	(-702.87, '20150106', 611),
	(-983.68, '20150406', 468),
	(-619.61, '20150120', 628),
	(398.67, '20141217', 656),
	(504.26, '20150509', 1058),
	(523.06, '20140403', 285),
	(-71.93, '20150104', 455),
	(-761.07, '20141108', 142),
	(-407.44, '20141224', 668),
	(334.91, '20141005', 328),
	(774.02, '20141124', 354),
	(-180.71, '20140117', 461),
	(312.53, '20150824', 24),
	(-650.05, '20141011', 651),
	(-403.34, '20140518', 990),
	(691.91, '20140828', 877),
	(-803.83, '20141213', 107),
	(-648.67, '20140731', 520),
	(-24.73, '20141202', 758),
	(156.32, '20140622', 818),
	(-702.68, '20141104', 900),
	(-114.09, '20140212', 1074),
	(-631.3, '20151201', 1003),
	(353.19, '20140922', 348),
	(-366.99, '20140626', 270),
	(-308.99, '20140327', 859),
	(413.86, '20141116', 396),
	(456.58, '20140427', 251),
	(-515.17, '20151111', 1106),
	(275.26, '20150809', 196),
	(807.91, '20150418', 636),
	(-602.01, '20140717', 290),
	(-444.99, '20140512', 880),
	(571.13, '20150202', 655),
	(468.3, '20151211', 49),
	(889.05, '20150124', 214),
	(126.75, '20141228', 961),
	(-645.52, '20140924', 719),
	(478.05, '20150118', 197),
	(-481.27, '20140122', 188),
	(769.31, '20151013', 536),
	(-858.03, '20150304', 440),
	(701.18, '20141107', 974),
	(804.77, '20150403', 220),
	(390.84, '20150220', 1094),
	(-866.33, '20141113', 319),
	(-596.94, '20150507', 382),
	(-860.66, '20150611', 1076);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(-488.58, '20150822', 912),
	(-652.29, '20140209', 811),
	(-295.04, '20151001', 279),
	(-567.66, '20140615', 46),
	(-574.21, '20150127', 921),
	(-504.6, '20150710', 450),
	(-50.06, '20150613', 949),
	(63.66, '20141128', 538),
	(517.4, '20150131', 1066),
	(399.34, '20141019', 844),
	(163.85, '20151016', 1002),
	(-435.46, '20140726', 657),
	(293.92, '20141031', 297),
	(-239.27, '20150723', 990),
	(783.75, '20150319', 598),
	(858.16, '20140810', 122),
	(-924.11, '20141214', 429),
	(576.69, '20140731', 834),
	(-591.29, '20151007', 704),
	(203.5, '20140429', 632),
	(-977.03, '20140411', 782),
	(652.1, '20141204', 75),
	(937.75, '20141201', 657),
	(-479.61, '20150915', 426),
	(852.67, '20140517', 1011),
	(159.61, '20140905', 205),
	(818.69, '20150803', 179),
	(-284.14, '20140409', 1062),
	(-944.21, '20150710', 927),
	(-419.49, '20140524', 63),
	(709.65, '20141010', 1073),
	(-351.53, '20140511', 219),
	(-587.45, '20141007', 646),
	(563.32, '20140823', 929),
	(275.57, '20151229', 965),
	(-478.26, '20140225', 905),
	(901.81, '20141031', 893),
	(541.87, '20150527', 3),
	(-180.69, '20140813', 4),
	(471.48, '20140331', 1025),
	(-899.87, '20151027', 628),
	(-529.04, '20141226', 655),
	(-794.97, '20151027', 78),
	(-545.16, '20150804', 418),
	(417.02, '20140809', 50),
	(374.47, '20141231', 228),
	(814.14, '20140330', 1112),
	(-916.8, '20140530', 939),
	(-821.55, '20150720', 990),
	(374.77, '20140903', 869),
	(-684.32, '20140327', 901),
	(365.72, '20150601', 903),
	(-652.36, '20140310', 106),
	(-351.41, '20140414', 201),
	(200.17, '20140827', 544),
	(244.49, '20150519', 783),
	(890.46, '20140921', 796),
	(702.64, '20150910', 380),
	(793.18, '20150321', 1084),
	(311.9, '20140102', 184),
	(738.58, '20151019', 542),
	(543.58, '20150718', 330),
	(-894.77, '20140910', 358),
	(-703.51, '20150919', 809),
	(679.18, '20150818', 611),
	(725.97, '20140922', 13),
	(748.89, '20150201', 564),
	(423.88, '20150126', 174),
	(-115.56, '20140822', 601),
	(-35.93, '20150331', 1027),
	(-156.91, '20140606', 845),
	(-962.77, '20150628', 210),
	(712.36, '20151221', 262),
	(200.15, '20150711', 366),
	(-283.85, '20151105', 762),
	(810.52, '20140429', 212),
	(-137.51, '20150604', 887),
	(-322.37, '20141003', 791),
	(913.97, '20150218', 1025),
	(-876.25, '20140113', 504),
	(-186.47, '20150616', 538),
	(-893.23, '20140918', 201),
	(-457.39, '20150410', 773),
	(602.03, '20150131', 359),
	(-59.7, '20150507', 976),
	(25.91, '20150301', 778),
	(658.55, '20150403', 409),
	(143.06, '20150611', 1083),
	(683.91, '20150111', 778),
	(-648.85, '20140918', 267),
	(462.55, '20140120', 391),
	(-49.1, '20150509', 522),
	(-71.89, '20150927', 484),
	(-951.55, '20150108', 70),
	(-509.53, '20140514', 64),
	(879.82, '20150404', 243),
	(-55.55, '20140120', 274),
	(-370, '20140324', 787),
	(-831.61, '20140726', 438),
	(-510.27, '20140420', 1021);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(441.37, '20150314', 914),
	(366.62, '20140720', 27),
	(-130.88, '20150612', 735),
	(11.41, '20141209', 1024),
	(39.03, '20150926', 847),
	(-552.63, '20150127', 609),
	(114.77, '20140526', 291),
	(891.95, '20151112', 633),
	(182.76, '20150916', 603),
	(105.18, '20151029', 693),
	(-37.34, '20150613', 538),
	(-677.77, '20141106', 775),
	(-800.65, '20150831', 620),
	(651.87, '20150209', 1003),
	(467.09, '20140127', 703),
	(-214.11, '20150930', 817),
	(58.31, '20150727', 400),
	(-98.52, '20150110', 747),
	(367.04, '20151231', 5),
	(-65.99, '20151027', 1111),
	(416.26, '20151128', 629),
	(326.82, '20140601', 1006),
	(-790.66, '20151204', 91),
	(846.33, '20150119', 391),
	(-18.49, '20150203', 695),
	(435.55, '20140628', 572),
	(368.56, '20150216', 917),
	(-938.48, '20151022', 117),
	(-175.94, '20140407', 876),
	(650.02, '20151225', 278),
	(722.63, '20140505', 883),
	(353.94, '20150120', 733),
	(949.77, '20150811', 975),
	(793.97, '20140807', 732),
	(605.39, '20150109', 693),
	(-787.48, '20151225', 851),
	(195.96, '20150904', 324),
	(129.2, '20150809', 611),
	(974.46, '20140114', 679),
	(857.9, '20150317', 262),
	(393.48, '20150215', 502),
	(999.22, '20140804', 140),
	(552.14, '20150413', 819),
	(733.06, '20150121', 602),
	(59.64, '20141224', 548),
	(-875.39, '20141201', 551),
	(637.05, '20151128', 944),
	(-550.41, '20140816', 144),
	(179.87, '20141017', 946),
	(271.45, '20150907', 190),
	(-304.77, '20141102', 565),
	(-265.04, '20140917', 212),
	(100.21, '20140819', 552),
	(-214.92, '20140910', 205),
	(-24.38, '20140819', 370),
	(338.13, '20150812', 1087),
	(-786.77, '20150326', 977),
	(-524.73, '20150902', 1033),
	(744.41, '20150604', 403),
	(-930.16, '20151117', 883),
	(553, '20150713', 25),
	(502.23, '20140820', 15),
	(711.77, '20151208', 554),
	(566.03, '20140622', 441),
	(416.09, '20150401', 904),
	(889.05, '20140519', 889),
	(-95.66, '20150213', 415),
	(-588.58, '20150507', 860),
	(-575.14, '20150628', 356),
	(-604.2, '20150513', 993),
	(711.87, '20151004', 327),
	(-707.82, '20150709', 1055),
	(-670.85, '20151006', 253),
	(-183.34, '20140829', 375),
	(694.36, '20140307', 1055),
	(975.26, '20140217', 96),
	(706.37, '20151206', 317),
	(992.56, '20140507', 699),
	(928.69, '20140523', 536),
	(-504.53, '20150713', 719),
	(778.53, '20141012', 913),
	(547.29, '20151006', 101),
	(322.48, '20140915', 819),
	(-876.73, '20151030', 485),
	(616.48, '20141031', 797),
	(-210.83, '20151004', 223),
	(-912.11, '20140714', 132),
	(498.52, '20140503', 350),
	(521.35, '20141103', 545),
	(-845.76, '20140925', 1008),
	(632.52, '20140225', 520),
	(622.1, '20140812', 407),
	(-227.78, '20140222', 1086),
	(-443.72, '20150811', 1034),
	(-349.35, '20140916', 387),
	(534.8, '20150525', 1116),
	(-163.64, '20150508', 401),
	(280.26, '20141017', 68),
	(110.46, '20150203', 689),
	(846.59, '20150417', 390);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(358.09, '20151223', 149),
	(-503.04, '20140519', 617),
	(-120.02, '20140421', 950),
	(14.02, '20151001', 508),
	(-874.14, '20140414', 829),
	(879.01, '20150310', 911),
	(912.14, '20141221', 554),
	(-550.86, '20150829', 515),
	(162.19, '20140408', 958),
	(561.28, '20150515', 570),
	(-670.74, '20141225', 526),
	(-136.79, '20141025', 163),
	(-578.97, '20140531', 1034),
	(137.14, '20151007', 751),
	(-504.19, '20140526', 528),
	(29.54, '20140806', 408),
	(-415.28, '20140711', 966),
	(-561.56, '20141222', 502),
	(-80.99, '20151208', 501),
	(944.6, '20150304', 331),
	(-551.99, '20141102', 81),
	(677.69, '20140414', 646),
	(-920.27, '20150107', 133),
	(-530.78, '20150923', 908),
	(39.55, '20150808', 753),
	(517.46, '20150731', 115),
	(884.07, '20150522', 609),
	(-989.27, '20150718', 1029),
	(-621.47, '20141118', 1036),
	(-246.51, '20150609', 965),
	(615.56, '20150210', 417),
	(673.63, '20140112', 954),
	(-320.09, '20150808', 118),
	(-877.79, '20150724', 593),
	(335.41, '20150928', 104),
	(81.48, '20140926', 840),
	(554.43, '20140117', 148),
	(-451.09, '20140627', 800),
	(-384.71, '20150620', 525),
	(519.37, '20140614', 727),
	(-519.96, '20141215', 530),
	(-217.91, '20140215', 427),
	(-416.27, '20140928', 217),
	(262.45, '20150310', 702),
	(166.59, '20141105', 1030),
	(889.71, '20140131', 251),
	(-924.76, '20140709', 116),
	(863.18, '20140407', 816),
	(27.68, '20151210', 804),
	(415.28, '20140614', 500),
	(-964.59, '20150402', 738),
	(431.91, '20150412', 245),
	(135.07, '20140226', 892),
	(-57.65, '20150313', 534),
	(-185.56, '20150401', 1078),
	(-494.95, '20140917', 874),
	(-493.97, '20150303', 779),
	(-45.96, '20150804', 7),
	(-660.19, '20140106', 602),
	(312.14, '20150904', 331),
	(606.85, '20140702', 1033),
	(314.81, '20150716', 945),
	(-268.08, '20140327', 114),
	(613, '20151011', 364),
	(731.2, '20150703', 191),
	(-565.42, '20140720', 25),
	(-724.5, '20140726', 24),
	(805.98, '20140409', 1089),
	(767.34, '20150106', 656),
	(-542.9, '20150710', 813),
	(-7.26, '20151122', 891),
	(203.25, '20150608', 468),
	(-556.36, '20150108', 1119),
	(-68.84, '20140112', 785),
	(-873.05, '20140719', 534),
	(837.06, '20141114', 278),
	(-102.2, '20150504', 998),
	(-208.85, '20151229', 319),
	(-122.26, '20140321', 408),
	(-664.43, '20140626', 835),
	(789.79, '20140626', 801),
	(748.85, '20141230', 473),
	(-471.95, '20151124', 1078),
	(976.48, '20151210', 1023),
	(-704.29, '20150227', 465),
	(-794.96, '20150228', 534),
	(-913.62, '20150604', 663),
	(-545.13, '20150724', 510),
	(586.38, '20151230', 329),
	(-652.7, '20140722', 926),
	(289.12, '20151030', 790),
	(482.54, '20151104', 607),
	(-851.14, '20150520', 2),
	(-392.99, '20140926', 255),
	(34.33, '20150413', 856),
	(-465.44, '20150613', 625),
	(310.06, '20140628', 748),
	(67.3, '20140817', 332),
	(28.15, '20140119', 893),
	(83.36, '20150623', 6);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(49.43, '20150830', 992),
	(386.46, '20140617', 554),
	(406.18, '20141008', 156),
	(526.13, '20151223', 977),
	(-167.28, '20150906', 440),
	(-294.9, '20151231', 581),
	(665.66, '20150220', 339),
	(951.38, '20150804', 479),
	(489.8, '20140211', 629),
	(-406.49, '20140702', 534),
	(-562.2, '20141029', 401),
	(189.93, '20140330', 548),
	(846.97, '20140306', 491),
	(-24.06, '20150521', 880),
	(-939.64, '20140504', 396),
	(-618.93, '20151225', 965),
	(-484.79, '20140101', 866),
	(-125.8, '20150213', 758),
	(-645.53, '20141103', 796),
	(629.42, '20151104', 741),
	(442.31, '20140109', 1122),
	(491.83, '20140131', 754),
	(-301.82, '20151020', 196),
	(-262.64, '20150419', 910),
	(-743.74, '20140611', 141),
	(932.76, '20140212', 523),
	(-788.09, '20140722', 506),
	(-723.6, '20140927', 360),
	(-594.31, '20150304', 1008),
	(-851.12, '20150912', 230),
	(32.25, '20150608', 576),
	(-767.04, '20150820', 426),
	(-978.41, '20140104', 14),
	(-733.71, '20150713', 48),
	(131.46, '20141226', 1064),
	(-10.98, '20151014', 729),
	(-575, '20140615', 692),
	(-736.41, '20151206', 576),
	(-796.02, '20141130', 30),
	(542.6, '20150330', 269),
	(-861.48, '20150626', 368),
	(-952.29, '20150716', 1113),
	(-905.25, '20150815', 646),
	(-778.26, '20140607', 299),
	(659.78, '20141227', 275),
	(-108.94, '20150911', 631),
	(-852.72, '20140423', 957),
	(211.08, '20141028', 979),
	(-693.26, '20141124', 125),
	(377.68, '20140519', 1022),
	(-918.11, '20150302', 1007),
	(-912.67, '20140929', 37),
	(-357.65, '20151222', 508),
	(-349.8, '20141207', 472),
	(136.45, '20150723', 645),
	(233.39, '20140103', 52),
	(711.8, '20151007', 1047),
	(-172.06, '20150219', 1104),
	(570.18, '20140929', 1067),
	(-646.61, '20151215', 205),
	(586.38, '20140812', 905),
	(389.68, '20140622', 611),
	(-505.33, '20150917', 307),
	(463.74, '20151127', 470),
	(-467.38, '20150812', 1110),
	(-385.83, '20150105', 208),
	(-633.59, '20140905', 789),
	(42.52, '20140123', 441),
	(-689.43, '20140307', 725),
	(-804.7, '20150117', 195),
	(-212.67, '20151015', 1015),
	(-973.96, '20141210', 68),
	(-399.68, '20140410', 1),
	(622.51, '20150329', 945),
	(-872.59, '20150708', 348),
	(-116.86, '20150405', 143),
	(289.15, '20151217', 913),
	(-608.64, '20150215', 253),
	(-367.91, '20140513', 191),
	(-696.15, '20140530', 955),
	(873.3, '20140923', 398),
	(135.21, '20141218', 27),
	(932.59, '20151120', 738),
	(670.19, '20151027', 958),
	(-398.28, '20141124', 642),
	(-134.67, '20140911', 626),
	(495.36, '20140611', 421),
	(-121.09, '20150120', 1104),
	(-364.93, '20140524', 787),
	(307.87, '20151011', 210),
	(-456.96, '20141112', 186),
	(-549.49, '20150501', 25),
	(282.73, '20141209', 1123),
	(370.42, '20140822', 1004),
	(-781.24, '20140704', 389),
	(-507.01, '20151209', 840),
	(99.05, '20150630', 1015),
	(-72.52, '20140302', 593),
	(474.49, '20140214', 577),
	(-242.76, '20150610', 843);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(915.79, '20151023', 815),
	(969.61, '20140905', 657),
	(989.83, '20150317', 1101),
	(835.91, '20141230', 592),
	(198.52, '20150725', 463),
	(-932.23, '20150316', 426),
	(926.61, '20150615', 851),
	(661.04, '20150908', 1015),
	(67.69, '20150715', 615),
	(902.21, '20141211', 545),
	(-267.15, '20140816', 782),
	(451.82, '20140123', 391),
	(58.14, '20141113', 905),
	(445.17, '20140219', 955),
	(805.63, '20151203', 677),
	(-927.68, '20150726', 554),
	(835.71, '20140319', 689),
	(743.66, '20150413', 225),
	(401.25, '20150416', 510),
	(509.44, '20150528', 1045),
	(-938.48, '20150728', 455),
	(-910.79, '20141217', 718),
	(387.31, '20140804', 1019),
	(703.86, '20150704', 407),
	(-590.63, '20151012', 258),
	(225.17, '20150718', 248),
	(-140.32, '20141115', 43),
	(868.18, '20150312', 454),
	(781.34, '20140807', 886),
	(477.4, '20150922', 608),
	(210.87, '20150405', 515),
	(-804.25, '20150502', 991),
	(-767.39, '20140225', 457),
	(-368.02, '20151209', 694),
	(-147.69, '20150121', 817),
	(-773.18, '20150801', 700),
	(320.72, '20151006', 697),
	(821, '20141130', 960),
	(-528.84, '20150122', 268),
	(-252.9, '20150322', 280),
	(-724.41, '20151219', 296),
	(700.31, '20150830', 134),
	(744.39, '20140103', 1006),
	(-566.1, '20150227', 278),
	(-555.94, '20140724', 663),
	(-671.59, '20150626', 507),
	(-246.48, '20140720', 714),
	(462.83, '20150813', 951),
	(492.12, '20140609', 526),
	(104.12, '20140908', 1124),
	(123.84, '20140726', 438),
	(-245.79, '20150420', 448),
	(182.35, '20151020', 890),
	(829.41, '20150712', 843),
	(202.75, '20151227', 998),
	(306.2, '20150717', 726),
	(884.46, '20150221', 748),
	(821.51, '20150131', 761),
	(699.2, '20151003', 1064),
	(202.55, '20150615', 1024),
	(-591.89, '20150114', 694),
	(172.19, '20140222', 795),
	(707.04, '20141210', 169),
	(597.94, '20150706', 34),
	(-210.04, '20150405', 709),
	(70.77, '20150313', 144),
	(-502.35, '20150919', 653),
	(535.99, '20150716', 652),
	(-966.43, '20150615', 1078),
	(342.37, '20150524', 566),
	(-331.83, '20150821', 771),
	(-468.4, '20150228', 533),
	(-951.79, '20150511', 427),
	(-489.01, '20141102', 440),
	(-642.29, '20150919', 8),
	(737.14, '20140608', 1051),
	(-845.78, '20150618', 924),
	(-345.25, '20150107', 387),
	(-185.7, '20150312', 443),
	(122.29, '20151231', 362),
	(-806.82, '20141220', 731),
	(-507.95, '20151213', 369),
	(-51.71, '20150705', 612),
	(-850.11, '20151222', 786),
	(-103.66, '20150501', 352),
	(434.41, '20140719', 154),
	(109.79, '20140826', 887),
	(540.49, '20150922', 376),
	(876.12, '20141108', 178),
	(790.25, '20150514', 170),
	(-589.77, '20150214', 132),
	(315.68, '20150723', 695),
	(326.75, '20140912', 206),
	(160.49, '20140430', 1013),
	(367.34, '20150818', 320),
	(-129.82, '20150326', 1070),
	(-494.6, '20141201', 346),
	(579.59, '20150715', 595),
	(882.56, '20150815', 719),
	(-910.7, '20141117', 1122);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(-554.01, '20150709', 498),
	(150.85, '20151124', 795),
	(-884.6, '20150524', 947),
	(780.32, '20150612', 280),
	(204.83, '20141121', 214),
	(906.05, '20151220', 420),
	(122.28, '20140618', 1044),
	(721.86, '20150410', 428),
	(-350.25, '20140803', 95),
	(-188.76, '20150429', 756),
	(495.23, '20140418', 986),
	(788.74, '20150325', 946),
	(488.7, '20140523', 27),
	(111.24, '20150205', 914),
	(-579.19, '20150711', 1083),
	(-396.67, '20150423', 908),
	(804.4, '20150105', 122),
	(239.49, '20140817', 249),
	(581.51, '20151122', 1056),
	(-987.1, '20150114', 481),
	(816.24, '20140115', 431),
	(-803, '20140909', 980),
	(-222.87, '20151111', 902),
	(610.21, '20140508', 383),
	(-856.53, '20141120', 946),
	(8.65, '20150728', 225),
	(644.83, '20150924', 259),
	(213.22, '20150919', 287),
	(-809.88, '20150208', 796),
	(-491.37, '20140117', 127),
	(358.22, '20140508', 811),
	(-878.17, '20141227', 227),
	(27.54, '20150803', 641),
	(879.03, '20140730', 536),
	(-779.35, '20140127', 286),
	(471.24, '20141221', 55),
	(-268.43, '20140730', 1049),
	(-151.86, '20150927', 4),
	(420.37, '20150815', 1010),
	(461.46, '20150423', 1077),
	(-983.48, '20140614', 1113),
	(320.53, '20140813', 615),
	(82.61, '20150311', 192),
	(-756.94, '20140507', 501),
	(-319.33, '20141116', 208),
	(-809.53, '20150531', 590),
	(732.49, '20140829', 299),
	(957.7, '20150102', 552),
	(892.1, '20150921', 646),
	(530.51, '20140125', 678),
	(593.48, '20150329', 71),
	(123.15, '20150107', 668),
	(647.44, '20150705', 652),
	(652.59, '20140311', 1003),
	(56.14, '20150509', 693),
	(-876.14, '20150829', 327),
	(-35.62, '20151005', 439),
	(27.03, '20140913', 612),
	(360.29, '20140519', 495),
	(662.03, '20151031', 446),
	(-294.87, '20140409', 138),
	(715.06, '20150321', 333),
	(932.17, '20140107', 524),
	(-794.49, '20150922', 98),
	(-522.23, '20150912', 1117),
	(-907.08, '20140629', 8),
	(239.52, '20150315', 570),
	(66.24, '20140227', 116),
	(-427.2, '20141211', 218),
	(-680.21, '20141218', 652),
	(314.5, '20140407', 972),
	(-49.95, '20141030', 1125),
	(877.19, '20140403', 1089),
	(-726.04, '20140927', 668),
	(669.8, '20140807', 399),
	(856.18, '20150213', 134),
	(514.97, '20150621', 876),
	(-515.54, '20150419', 659),
	(524.05, '20141119', 425),
	(325.57, '20150316', 1069),
	(-703.34, '20151121', 416),
	(-441.27, '20150225', 252),
	(-656.22, '20140905', 394),
	(563.48, '20150623', 1101),
	(-179.82, '20150721', 464),
	(81.87, '20141023', 269),
	(-884.94, '20140719', 170),
	(-436.82, '20141225', 802),
	(956.43, '20151014', 348),
	(884.92, '20151216', 335),
	(646.72, '20150702', 719),
	(-303.73, '20150520', 281),
	(833.86, '20150903', 574),
	(-533.72, '20140807', 361),
	(-572.12, '20151027', 426),
	(-223.79, '20150902', 634),
	(736.32, '20151010', 344),
	(414.23, '20150215', 185),
	(992.31, '20151019', 581),
	(-489.62, '20150421', 921);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(-335.85, '20140315', 543),
	(-397.57, '20140723', 745),
	(-614.29, '20150219', 203),
	(421.5, '20151011', 214),
	(466.49, '20150330', 339),
	(-153.38, '20141112', 548),
	(314.64, '20140219', 810),
	(958.05, '20141123', 280),
	(818.92, '20140929', 1044),
	(-179.47, '20150318', 123),
	(-556.3, '20150405', 13),
	(-251.17, '20141019', 818),
	(539.38, '20141011', 883),
	(834.5, '20151113', 776),
	(946.34, '20150906', 241),
	(-471.26, '20151129', 359),
	(-246.08, '20140919', 934),
	(-904.79, '20141202', 1112),
	(-359.2, '20140924', 150),
	(748.55, '20150403', 486),
	(-912.49, '20150131', 648),
	(-394.06, '20140520', 862),
	(611.86, '20150217', 214),
	(-706.1, '20151010', 602),
	(-99.25, '20150309', 302),
	(471.63, '20150302', 80),
	(789.47, '20141010', 440),
	(-334.95, '20150613', 620),
	(-279.38, '20150817', 89),
	(-639.82, '20150510', 891),
	(-757.02, '20140422', 500),
	(-320.17, '20151130', 679),
	(-13.93, '20140307', 1105),
	(-289.54, '20150207', 188),
	(-637.93, '20140927', 676),
	(828.32, '20151104', 73),
	(568.01, '20151113', 951),
	(489.56, '20150601', 255),
	(10.44, '20151229', 365),
	(-553.58, '20150425', 145),
	(480.55, '20150615', 662),
	(358.02, '20150103', 401),
	(-834.78, '20150113', 928),
	(-565.17, '20140905', 17),
	(182.69, '20140527', 87),
	(520.41, '20150106', 274),
	(250.48, '20150410', 715),
	(-754.32, '20150819', 486),
	(-648.97, '20150228', 335),
	(972.01, '20150114', 211),
	(271.11, '20140611', 819),
	(750.14, '20140705', 205),
	(896.13, '20151109', 300),
	(155.23, '20140708', 485),
	(689.76, '20150201', 454),
	(42.81, '20150811', 759),
	(879.12, '20140324', 554),
	(278.81, '20150401', 868),
	(102.7, '20141005', 575),
	(-891.53, '20150902', 575),
	(88.53, '20141225', 505),
	(-343.3, '20150304', 43),
	(-880.62, '20150929', 810),
	(993.23, '20151111', 512),
	(775.71, '20141009', 381),
	(-364.73, '20140804', 495),
	(-405.63, '20140401', 963),
	(163.27, '20140921', 968),
	(-141.93, '20140515', 399),
	(-330.05, '20151109', 980),
	(421.91, '20140123', 270),
	(491.92, '20140630', 88),
	(819.86, '20150316', 636),
	(-125.38, '20151102', 561),
	(584.28, '20140123', 1101),
	(-120.83, '20150320', 1117),
	(251.73, '20140327', 465),
	(644.55, '20140704', 681),
	(-503.71, '20150623', 53),
	(425.43, '20150705', 477),
	(-292.5, '20140407', 104),
	(-174.93, '20151209', 850),
	(-478.88, '20141217', 137),
	(278.84, '20150628', 339),
	(285.19, '20150423', 694),
	(263.05, '20140726', 747),
	(635.72, '20140305', 332),
	(-414.55, '20150312', 2),
	(605.68, '20141010', 475),
	(-778.09, '20141119', 571),
	(-543.6, '20150309', 1044),
	(428.58, '20141206', 353),
	(-573.18, '20150509', 129),
	(-235.81, '20150719', 489),
	(243.86, '20140920', 81),
	(496.86, '20140409', 852),
	(125.51, '20140109', 630),
	(-418.91, '20150328', 51),
	(530.54, '20150605', 901),
	(-492.19, '20150523', 751);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(90.57, '20150910', 258),
	(-667.67, '20151221', 351),
	(245.34, '20140802', 207),
	(117.21, '20140531', 131),
	(-524.12, '20140725', 375),
	(-685.17, '20140804', 1109),
	(797.94, '20150613', 744),
	(-81.98, '20140618', 321),
	(609.93, '20150714', 289),
	(700.79, '20150117', 82),
	(-798.41, '20150902', 591),
	(-837.09, '20140225', 540),
	(-364.29, '20141231', 199),
	(-347.46, '20140306', 51),
	(-510.3, '20150715', 460),
	(68.69, '20151113', 443),
	(-604.81, '20151024', 649),
	(-432.03, '20150120', 1099),
	(-342.36, '20150831', 1101),
	(175.99, '20151012', 804),
	(-325.26, '20150720', 849),
	(-211.64, '20150302', 267),
	(-16.46, '20151217', 955),
	(449.68, '20140707', 197),
	(-737.96, '20141104', 1044),
	(728.63, '20150511', 262),
	(781.43, '20140209', 164),
	(949.55, '20150419', 943),
	(495.56, '20140103', 240),
	(971.89, '20150417', 571),
	(-113.6, '20151027', 298),
	(172.15, '20150720', 625),
	(-516.29, '20140226', 212),
	(602.19, '20141219', 860),
	(-798.28, '20141228', 1117),
	(107.73, '20150926', 105),
	(122.92, '20141116', 948),
	(859.08, '20150127', 168),
	(322.17, '20150927', 505),
	(-798.1, '20140903', 637),
	(-189.21, '20140313', 214),
	(639.22, '20150406', 2),
	(637.8, '20150818', 878),
	(954.38, '20150501', 443),
	(-355.8, '20140211', 439),
	(651.6, '20140520', 694),
	(-351.21, '20150201', 234),
	(-695.73, '20140927', 370),
	(-532.91, '20150904', 1075),
	(171.37, '20150703', 1111),
	(-138.86, '20150923', 1078),
	(-682.12, '20141116', 213),
	(-977.18, '20140321', 399),
	(998.32, '20150813', 770),
	(721.96, '20140401', 191),
	(406.57, '20150520', 374),
	(658.23, '20150912', 53),
	(-792.7, '20150607', 364),
	(86.51, '20140209', 728),
	(-388.3, '20140215', 40),
	(-81.44, '20150131', 416),
	(-388.59, '20140304', 546),
	(979.02, '20140904', 82),
	(-179.38, '20140614', 519),
	(669.05, '20150814', 497),
	(-519.09, '20151119', 739),
	(786.39, '20150117', 507),
	(-81.75, '20141225', 138),
	(-789.85, '20140101', 590),
	(-329.11, '20150619', 857),
	(-947.63, '20151101', 341),
	(601.83, '20140621', 139),
	(-276.41, '20141124', 641),
	(934.05, '20140928', 414),
	(897.94, '20140205', 964),
	(-236.44, '20150405', 337),
	(-363.62, '20150525', 1033),
	(-681.85, '20151126', 156),
	(683.95, '20150911', 1082),
	(755.53, '20150623', 52),
	(-653.62, '20150713', 629),
	(-393.63, '20140816', 552),
	(-901.35, '20140706', 104),
	(930.13, '20140415', 728),
	(527.75, '20150712', 245),
	(335.03, '20150525', 1041),
	(-929.43, '20150111', 317),
	(-264.9, '20141020', 840),
	(-210.69, '20150525', 236),
	(596.2, '20150712', 85),
	(527.89, '20151211', 1098),
	(37, '20140727', 1055),
	(947.83, '20150610', 534),
	(879.92, '20150917', 84),
	(267.85, '20150330', 108),
	(-414.32, '20151219', 380),
	(707.75, '20150330', 1051),
	(-151.98, '20140405', 453),
	(-510.22, '20150530', 240),
	(394.59, '20150921', 799);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
   VALUES 	(950.69, '20150504', 1097),
	(20.46, '20140406', 294),
	(786.22, '20141114', 123),
	(-166.13, '20150826', 104),
	(942.04, '20150920', 300),
	(676.92, '20140324', 967),
	(836.52, '20150702', 658),
	(-457.16, '20141016', 907),
	(-770.86, '20151107', 838),
	(-263.17, '20140917', 380),
	(226.58, '20140918', 974),
	(855.23, '20140629', 548),
	(-599.27, '20151220', 425),
	(-687.78, '20151019', 599),
	(399.62, '20140112', 342),
	(-502.84, '20151214', 690),
	(237.45, '20141015', 557),
	(-788.86, '20140624', 1028),
	(-373.68, '20140714', 275),
	(687.94, '20140627', 337),
	(-589.54, '20140819', 564),
	(-689.68, '20150110', 580),
	(-124.73, '20150525', 695),
	(-586.44, '20151207', 303),
	(815.11, '20140406', 704),
	(-81.45, '20150117', 558),
	(-165.04, '20140417', 767),
	(137.53, '20141107', 292),
	(-483.18, '20140205', 54),
	(-670.22, '20140816', 418),
	(841.08, '20151002', 474),
	(545.11, '20150314', 988),
	(663.13, '20150904', 105),
	(607.9, '20140120', 915),
	(750.05, '20151125', 351),
	(30.07, '20150924', 1040),
	(-774.91, '20151103', 337),
	(-96.78, '20141125', 280),
	(908.46, '20150303', 785),
	(374.72, '20140206', 526),
	(-73.94, '20150221', 810),
	(100.45, '20140204', 3),
	(-541.4, '20151227', 144),
	(-416.76, '20150828', 376),
	(62.01, '20141229', 118),
	(-640.07, '20151231', 434),
	(-305.33, '20140914', 616),
	(553.81, '20150602', 246),
	(-160.89, '20150419', 959),
	(-932.54, '20151205', 262),
	(355.79, '20150906', 823),
	(361.83, '20150308', 757),
	(-349.58, '20150701', 948),
	(880.42, '20150424', 168),
	(-220.2, '20150618', 24),
	(-111.55, '20140221', 935),
	(407.06, '20141217', 1060),
	(731.9, '20150703', 707),
	(413.69, '20141212', 1047),
	(310.6, '20140802', 396),
	(-303.17, '20140917', 217),
	(680.76, '20150807', 366),
	(802.68, '20150805', 1079),
	(13.32, '20150121', 630),
	(700.05, '20150901', 99),
	(570.52, '20140529', 793),
	(-808.17, '20151102', 122),
	(-126.57, '20140324', 411),
	(575.62, '20150417', 764),
	(673.9, '20141205', 1005),
	(-627.57, '20140721', 52),
	(-731.79, '20150511', 432),
	(-898.12, '20150826', 732),
	(-641.02, '20140607', 454),
	(848.11, '20141123', 436),
	(254.55, '20140929', 569),
	(-419.7, '20140919', 827),
	(-879.63, '20151001', 146),
	(891.87, '20140727', 314),
	(-446.64, '20151226', 765),
	(-581.31, '20140714', 341),
	(-208.94, '20140622', 586),
	(449.48, '20150501', 675),
	(631.01, '20140117', 820),
	(-106.29, '20140907', 1034),
	(783.31, '20140504', 107),
	(-659.94, '20151222', 828),
	(333.6, '20150909', 512),
	(316.5, '20151010', 424),
	(749.47, '20140213', 410),
	(759.06, '20140804', 79),
	(78.65, '20141218', 724),
	(548.67, '20151109', 1024),
	(672.13, '20151225', 179),
	(-809.01, '20140816', 483),
	(400.33, '20140714', 336),
	(907.77, '20140304', 776),
	(-861.57, '20140301', 507),
	(358.9, '20140410', 377),
	(81.33, '20140310', 400);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(-366.99, '20141214', 327),
	(883.61, '20151023', 177),
	(-103.94, '20150829', 770),
	(390.11, '20150201', 591),
	(-829.67, '20141021', 160),
	(456.99, '20150417', 482),
	(819.47, '20140528', 724),
	(779.78, '20140629', 445),
	(-338.54, '20140521', 620),
	(914.43, '20140624', 191),
	(436.78, '20150403', 997),
	(-2.1, '20140315', 366),
	(688.86, '20141203', 800),
	(912.3, '20150419', 1102),
	(209.68, '20140703', 11),
	(162.44, '20140612', 757),
	(-491.94, '20141004', 621),
	(224.69, '20151030', 533),
	(68.11, '20151024', 280),
	(574.37, '20140105', 842),
	(705.54, '20140330', 225),
	(-26, '20140919', 117),
	(51.9, '20141115', 974),
	(222.16, '20140517', 702),
	(-917.03, '20150426', 612),
	(905.74, '20140812', 598),
	(-5.09, '20150831', 200),
	(-546.05, '20151201', 23),
	(-683.78, '20150910', 1119),
	(-229.63, '20140913', 416),
	(427.35, '20150818', 1091),
	(867.57, '20140307', 899),
	(87.86, '20140404', 971),
	(805.05, '20140929', 434),
	(738.47, '20140123', 24),
	(342.69, '20140126', 222),
	(-273.16, '20140709', 915),
	(593.84, '20140524', 903),
	(952.82, '20140725', 896),
	(350.49, '20150412', 825),
	(-883.68, '20150507', 645),
	(412.32, '20150411', 176),
	(146.6, '20150811', 996),
	(-482.92, '20140510', 1069),
	(232.07, '20140820', 751),
	(653.41, '20151101', 205),
	(-999.28, '20150618', 841),
	(825.93, '20150925', 80),
	(-745.22, '20140724', 958),
	(738.18, '20140321', 89),
	(-650.22, '20150807', 356),
	(576.71, '20140912', 190),
	(459.88, '20150206', 187),
	(-444.94, '20150520', 470),
	(-388.17, '20150624', 994),
	(53.53, '20140219', 564),
	(712.78, '20150922', 174),
	(997.36, '20150322', 805),
	(-981.68, '20150317', 797),
	(562.39, '20140125', 1031),
	(-436.3, '20150905', 1103),
	(332.7, '20141221', 421),
	(-842.03, '20150223', 1116),
	(-562.83, '20140330', 264),
	(-974.59, '20141011', 469),
	(209.29, '20140813', 832),
	(133.36, '20140524', 979),
	(683.79, '20151216', 15),
	(-954.39, '20150918', 807),
	(142.34, '20140109', 425),
	(608.11, '20140224', 235),
	(-238.04, '20140726', 693),
	(-941.5, '20150306', 157),
	(471.77, '20141014', 550),
	(-493.59, '20140123', 164),
	(-452.18, '20140909', 107),
	(475.25, '20150829', 111),
	(-580.48, '20150630', 546),
	(-810.75, '20140404', 600),
	(626.75, '20140121', 1034),
	(-204.37, '20140719', 96),
	(-613.11, '20150530', 154),
	(427.78, '20150910', 221),
	(-418.09, '20150205', 46),
	(271.13, '20150413', 472),
	(98.84, '20140216', 977),
	(-338.1, '20140821', 721),
	(599.17, '20150518', 120),
	(-150.9, '20151102', 84),
	(629.29, '20150330', 304),
	(-850.37, '20141214', 991),
	(-463.2, '20150221', 595),
	(-475.12, '20141114', 861),
	(832.25, '20140828', 588),
	(274.6, '20141231', 826),
	(189.63, '20140621', 397),
	(-950.74, '20140623', 636),
	(-60.96, '20140420', 889),
	(-346.33, '20140322', 871),
	(492.74, '20151010', 719);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(-375.39, '20150530', 348),
	(-460.89, '20140709', 658),
	(-616.88, '20141017', 1011),
	(-111.28, '20141218', 86),
	(-744.62, '20150113', 874),
	(124.23, '20150116', 213),
	(-208.95, '20140205', 246),
	(817.72, '20150130', 448),
	(-742.36, '20141217', 489),
	(-971.37, '20140612', 1071),
	(874.57, '20150929', 805),
	(-888.58, '20140301', 213),
	(378.8, '20140801', 421),
	(555.65, '20150105', 157),
	(266.65, '20140308', 8),
	(-436.85, '20150411', 440),
	(-250.31, '20150514', 487),
	(470.97, '20140318', 1059),
	(-71.09, '20141102', 247),
	(-931.75, '20150814', 366),
	(-544.74, '20151224', 71),
	(-201.31, '20150306', 726),
	(-509.65, '20140923', 696),
	(-349.67, '20150724', 956),
	(-515.14, '20150828', 498),
	(-484.92, '20140408', 1006),
	(777.92, '20150219', 685),
	(191.79, '20150424', 334),
	(722.9, '20140408', 897),
	(-268.49, '20151021', 622),
	(-388.23, '20140120', 972),
	(778.72, '20150808', 1069),
	(667.76, '20141115', 930),
	(387.58, '20140510', 1030),
	(-6.4, '20150820', 955),
	(499.34, '20151224', 722),
	(813.86, '20150106', 401),
	(994.08, '20150324', 819),
	(-98.24, '20150111', 202),
	(950.47, '20150416', 494),
	(269.9, '20150809', 840),
	(104.58, '20151009', 698),
	(-198.64, '20140423', 410),
	(-73.07, '20151123', 989),
	(481.57, '20140705', 476),
	(155.86, '20140509', 341),
	(692.47, '20140521', 341),
	(-663.86, '20140903', 1065),
	(369.51, '20141128', 417),
	(809.02, '20140311', 708),
	(-117.39, '20140528', 1065),
	(-382.4, '20150623', 176),
	(-266.32, '20151124', 256),
	(-626.65, '20141008', 737),
	(671.89, '20150909', 685),
	(-769.02, '20140516', 192),
	(745.55, '20150814', 364),
	(-183.45, '20140509', 854),
	(282.49, '20150310', 783),
	(825.15, '20150322', 101),
	(-354.44, '20140216', 736),
	(-273.85, '20150815', 821),
	(-12.95, '20140608', 803),
	(630.01, '20151007', 997),
	(312.61, '20150301', 863),
	(102.21, '20140610', 84),
	(422.83, '20141105', 993),
	(-15.67, '20140709', 808),
	(700.85, '20150824', 913),
	(203.68, '20140331', 52),
	(-94.48, '20151024', 1100),
	(-245.63, '20150405', 801),
	(602.78, '20150106', 204),
	(-209.42, '20150323', 959),
	(-751.85, '20151221', 829),
	(-696.68, '20151216', 350),
	(377.12, '20140403', 480),
	(933.25, '20140325', 382),
	(-570.15, '20140423', 160),
	(17.02, '20140414', 87),
	(986.88, '20150430', 219),
	(926.95, '20140404', 995),
	(-407.78, '20150518', 279),
	(116.68, '20150809', 74),
	(-113.05, '20140803', 458),
	(550.21, '20150411', 143),
	(-171.78, '20150623', 352),
	(97.98, '20150311', 1114),
	(-768.81, '20150222', 326),
	(787.24, '20140317', 77),
	(-681.8, '20140919', 213),
	(-745.29, '20140203', 91),
	(-415.54, '20140320', 34),
	(-182.31, '20151225', 426),
	(677.8, '20150114', 1101),
	(720.04, '20140528', 340),
	(-717.19, '20150416', 410),
	(-793.48, '20140515', 497),
	(993.36, '20151202', 275),
	(-271.57, '20150818', 93);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(450.73, '20141124', 1072),
	(-867.65, '20140112', 118),
	(697.38, '20140208', 592),
	(75.45, '20150223', 893),
	(-434.41, '20150723', 29),
	(857.63, '20140130', 841),
	(-726.21, '20150722', 809),
	(819.11, '20150914', 844),
	(535, '20151008', 145),
	(187.81, '20140204', 670),
	(-428.09, '20140322', 692),
	(143.43, '20140929', 467),
	(241.06, '20141119', 275),
	(497.4, '20150707', 248),
	(-688.07, '20151210', 788),
	(-912.62, '20141028', 903),
	(-418.37, '20150322', 390),
	(-788.73, '20150319', 715),
	(424.47, '20140918', 1001),
	(800.81, '20150905', 578),
	(508.06, '20151103', 148),
	(-140.15, '20140509', 565),
	(-691.23, '20150105', 1107),
	(57.22, '20151215', 498),
	(-15.44, '20140204', 377),
	(943.95, '20140625', 1097),
	(-767.43, '20140924', 334),
	(921.87, '20150330', 1117),
	(491.83, '20150619', 681),
	(-257.71, '20141231', 994),
	(882.48, '20150316', 437),
	(865.44, '20140623', 907),
	(165.3, '20150312', 374),
	(-836.3, '20151009', 541),
	(572.85, '20150319', 968),
	(-708.01, '20140420', 102),
	(941.05, '20151217', 1026),
	(288.55, '20140718', 39),
	(-87.05, '20150304', 840),
	(-731.81, '20150527', 1077),
	(-693.56, '20140321', 315),
	(-711.73, '20140130', 663),
	(-612.43, '20140812', 835),
	(-131.89, '20150519', 843),
	(-468.33, '20150204', 830),
	(-394.7, '20141228', 848),
	(-471.17, '20150904', 331),
	(-334.06, '20150812', 1110),
	(-726.11, '20150606', 1068),
	(-685.9, '20151006', 1024),
	(-379.08, '20140612', 833),
	(319.18, '20150226', 1027),
	(411.28, '20140411', 26),
	(427.92, '20151203', 210),
	(-671.19, '20140824', 255),
	(-24.78, '20141121', 429),
	(875.4, '20140522', 1106),
	(-884.03, '20140317', 560),
	(-651.63, '20150103', 118),
	(253.09, '20160101', 444),
	(-965.4, '20150908', 363),
	(-607.47, '20141230', 15),
	(438.46, '20151224', 738),
	(732.98, '20150621', 669),
	(-45.3, '20140714', 298),
	(-938.39, '20151121', 1052),
	(266.89, '20141128', 1076),
	(357.19, '20140315', 978),
	(-883.28, '20151113', 989),
	(971.07, '20150614', 786),
	(665.95, '20140519', 527),
	(-891.96, '20141117', 53),
	(-230.6, '20150901', 418),
	(-159.7, '20140616', 451),
	(716.64, '20150418', 597),
	(70.22, '20150330', 245),
	(-973.49, '20141217', 834),
	(-33.84, '20150619', 240),
	(749.53, '20141008', 76),
	(570.49, '20140722', 360),
	(720.9, '20140606', 28),
	(801.11, '20150704', 967),
	(371.92, '20140921', 298),
	(-424.66, '20150318', 975),
	(-761.93, '20151116', 677),
	(122.4, '20141127', 286),
	(642.99, '20151211', 182),
	(-203.77, '20141123', 157),
	(491.76, '20150222', 402),
	(-685.35, '20141206', 314),
	(411.63, '20150519', 326),
	(-849.51, '20151027', 751),
	(-92.32, '20150924', 458),
	(197.8, '20151116', 927),
	(310.1, '20150114', 339),
	(135.22, '20150125', 894),
	(-746, '20150420', 176),
	(-576.77, '20151115', 124),
	(-514.98, '20150423', 54),
	(-630.93, '20140903', 661);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(858.12, '20150306', 461),
	(-113.19, '20151020', 208),
	(-905.71, '20140915', 678),
	(461.24, '20150226', 574),
	(-436.27, '20140113', 778),
	(-519.31, '20151003', 371),
	(-972.88, '20150810', 498),
	(691.26, '20140109', 1113),
	(651.49, '20151207', 349),
	(290.84, '20150415', 96),
	(181.06, '20140322', 766),
	(-868.11, '20140725', 525),
	(151.5, '20150202', 413),
	(235.28, '20150515', 386),
	(-30.68, '20150822', 664),
	(-569.73, '20151018', 505),
	(-873.02, '20150209', 1039),
	(814.48, '20151105', 50),
	(159.38, '20141001', 974),
	(28.24, '20150416', 142),
	(95.56, '20150502', 984),
	(483.13, '20151110', 517),
	(969.15, '20150411', 409),
	(-687.45, '20141110', 362),
	(-140.11, '20140522', 88),
	(779.15, '20150121', 665),
	(461.54, '20150724', 191),
	(407.11, '20140605', 569),
	(-75.21, '20140625', 370),
	(531.78, '20140412', 121),
	(-475.3, '20141205', 638),
	(-330.46, '20141112', 1020),
	(529.71, '20150425', 877),
	(-118.5, '20140808', 64),
	(-118.76, '20141207', 517),
	(955.36, '20140427', 489),
	(-394.12, '20140114', 57),
	(164.69, '20140528', 858),
	(464.2, '20141129', 389),
	(-388.2, '20140820', 1124),
	(-79.76, '20141015', 1036),
	(80.06, '20140925', 112),
	(-67.31, '20150303', 228),
	(-432.69, '20140511', 1086),
	(650.19, '20150811', 968),
	(-450.52, '20150415', 991),
	(695.22, '20141230', 332),
	(-639.96, '20151123', 545),
	(-979.41, '20140830', 221),
	(239.15, '20150801', 10),
	(-806.67, '20140908', 1085),
	(58.43, '20140629', 247),
	(754.41, '20151125', 857),
	(-41.63, '20140425', 889),
	(688.23, '20140923', 294),
	(-456.53, '20140106', 398),
	(921.95, '20140215', 925),
	(126.85, '20140809', 864),
	(-915.96, '20140504', 11),
	(738.93, '20141210', 577),
	(-259.61, '20140213', 732),
	(739.87, '20141023', 237),
	(-679.85, '20140207', 758),
	(-332.23, '20151017', 202),
	(892.64, '20141121', 1118),
	(-221, '20150404', 1020),
	(382.12, '20140112', 215),
	(-184.84, '20150805', 1090),
	(826.54, '20150427', 1054),
	(-931.08, '20141112', 760),
	(976.68, '20140821', 918),
	(365.81, '20151001', 368),
	(297.61, '20150614', 114),
	(782.69, '20151222', 763),
	(-656.57, '20150727', 590),
	(69.13, '20140625', 655),
	(595.28, '20150507', 445),
	(-842.1, '20140712', 1082),
	(-679.99, '20140610', 316),
	(-965.47, '20150619', 505),
	(225.19, '20141030', 258),
	(-890.63, '20150116', 391),
	(813.56, '20140518', 138),
	(688.77, '20150424', 115),
	(138.64, '20140213', 23),
	(200.52, '20150609', 443),
	(562.62, '20150317', 489),
	(-872.79, '20141128', 423),
	(-327.87, '20140519', 724),
	(-166.18, '20150820', 165),
	(660.97, '20150224', 773),
	(912.93, '20141214', 849),
	(126.63, '20150112', 567),
	(-924.67, '20150521', 598),
	(-132.45, '20150127', 364),
	(171, '20150209', 591),
	(913.61, '20141122', 98),
	(-600.01, '20150909', 49),
	(-454.35, '20150820', 451),
	(576.26, '20150714', 968);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(442.59, '20140902', 157),
	(944.21, '20141228', 821),
	(-946.12, '20150624', 132),
	(876.64, '20150421', 308),
	(128.91, '20140124', 911),
	(911.56, '20140316', 635),
	(813.38, '20140424', 184),
	(946.74, '20141110', 272),
	(992.76, '20140213', 366),
	(-920.82, '20150809', 864),
	(470.49, '20150425', 485),
	(-589.25, '20150128', 119),
	(-932.84, '20141024', 143),
	(344.27, '20150520', 14),
	(-545.22, '20140131', 585),
	(-155.35, '20140202', 459),
	(-740.86, '20140525', 833),
	(-967.36, '20151025', 123),
	(653.77, '20141027', 1022),
	(453.7, '20140720', 1058),
	(947.52, '20150609', 798),
	(773.88, '20150220', 648),
	(-109.71, '20140618', 112),
	(948.12, '20140505', 871),
	(817.11, '20150719', 128),
	(-759.71, '20140421', 108),
	(354.81, '20141201', 534),
	(242.28, '20141011', 1051),
	(-442.89, '20140119', 863),
	(-988.68, '20141031', 158),
	(631.92, '20140425', 70),
	(-214.38, '20140929', 509),
	(-322.37, '20151122', 646),
	(-26.78, '20141208', 46),
	(925.98, '20140317', 860),
	(-568.73, '20140901', 710),
	(12.81, '20140103', 701),
	(-748.86, '20140306', 711),
	(-488.54, '20151030', 363),
	(-316.04, '20150216', 695),
	(-312.99, '20150116', 812),
	(699.32, '20140102', 613),
	(634.07, '20140804', 110),
	(-479.45, '20151025', 376),
	(816.24, '20140317', 88),
	(-70.38, '20150218', 712),
	(860.75, '20140912', 72),
	(656.47, '20141109', 823),
	(-661.73, '20151109', 386),
	(-457.96, '20141210', 359),
	(720.57, '20150912', 686),
	(-415.48, '20140113', 433),
	(-749.45, '20140613', 1078),
	(289.12, '20140822', 631),
	(-652.65, '20150822', 427),
	(-445.97, '20140806', 605),
	(-758.29, '20150119', 883),
	(803.58, '20140910', 1092),
	(0.9, '20140531', 59),
	(588.56, '20160101', 893),
	(899.02, '20150515', 90),
	(0.83, '20140216', 63),
	(35.12, '20140715', 505),
	(-65.95, '20150818', 196),
	(-544.36, '20150603', 285),
	(806, '20151025', 19),
	(-859.61, '20150313', 956),
	(-548.2, '20140817', 675),
	(-586.09, '20140502', 646),
	(-531.36, '20140718', 893),
	(551.46, '20150507', 186),
	(608.03, '20150404', 1007),
	(-835.98, '20140906', 962),
	(-747.65, '20151025', 254),
	(61.75, '20150906', 881),
	(-482.34, '20151219', 92),
	(-835.91, '20150206', 88),
	(-125.14, '20150526', 996),
	(96.72, '20141007', 781),
	(-446.95, '20150527', 717),
	(957.03, '20140523', 123),
	(-951.47, '20141213', 828),
	(-205.06, '20140205', 410),
	(901.28, '20150630', 793),
	(649.41, '20140929', 616),
	(-981.52, '20140618', 289),
	(-24.47, '20140625', 446),
	(-24.25, '20150422', 1109),
	(386.79, '20140528', 920),
	(-140.08, '20150830', 724),
	(916.93, '20141123', 97),
	(-479.3, '20150226', 260),
	(-988.49, '20150402', 190),
	(564.56, '20150523', 698),
	(302.4, '20150721', 354),
	(-395.54, '20150224', 251),
	(250.84, '20151023', 756),
	(853.2, '20140403', 503),
	(33.94, '20141209', 538),
	(-598.12, '20150510', 443);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(915.19, '20150120', 229),
	(928.77, '20140811', 473),
	(163, '20150623', 472),
	(470.63, '20150302', 1080),
	(149.31, '20140825', 1099),
	(79.55, '20150202', 924),
	(846.25, '20150207', 442),
	(-549.32, '20150922', 649),
	(842.88, '20140904', 711),
	(-53.92, '20140505', 1016),
	(-100.47, '20150406', 953),
	(-7.81, '20150708', 581),
	(222.51, '20141207', 549),
	(756.02, '20151205', 936),
	(-814.43, '20151004', 524),
	(-692.76, '20140522', 429),
	(329.6, '20140804', 338),
	(138.16, '20150425', 333),
	(-727.38, '20150430', 815),
	(-697.56, '20150712', 367),
	(-2.19, '20140306', 107),
	(10.13, '20140115', 84),
	(84.85, '20150521', 185),
	(-85.37, '20140611', 1032),
	(245.74, '20140531', 424),
	(-308.2, '20150607', 492),
	(-137.54, '20150408', 961),
	(985.35, '20140614', 187),
	(44.27, '20140306', 689),
	(157.31, '20140219', 317),
	(-102.21, '20151129', 803),
	(673.17, '20151001', 464),
	(-329.16, '20150812', 156),
	(594.78, '20140606', 550),
	(800.19, '20150903', 1017),
	(618.73, '20151210', 1000),
	(-270.29, '20140724', 190),
	(-840.22, '20151112', 981),
	(-79.52, '20150127', 465),
	(-750.09, '20150826', 633),
	(-591.43, '20150805', 177),
	(-311.94, '20150423', 228),
	(-7.08, '20141222', 616),
	(-324.07, '20150706', 651),
	(710.75, '20150219', 1053),
	(-215.82, '20140521', 1075),
	(108.04, '20150717', 15),
	(-785.7, '20140511', 146),
	(-978.38, '20150402', 162),
	(-485.29, '20150529', 916),
	(-69.55, '20140724', 210),
	(472.84, '20150126', 172),
	(-933.37, '20140620', 40),
	(-136.05, '20140330', 519),
	(116.96, '20140120', 317),
	(188.35, '20140416', 422),
	(-379.26, '20140402', 730),
	(875.18, '20151102', 222),
	(702.16, '20150405', 378),
	(226.17, '20140124', 338),
	(-451.9, '20150221', 47),
	(777.58, '20141230', 633),
	(-456.75, '20140718', 664),
	(240.61, '20140915', 43),
	(-94.43, '20150402', 596),
	(-217.48, '20151123', 315),
	(-287.37, '20141028', 7),
	(855.23, '20151026', 507),
	(-726.89, '20150630', 708),
	(613.81, '20151208', 725),
	(-556.52, '20150708', 111),
	(-962.36, '20140426', 1043),
	(-601.14, '20151215', 423),
	(-395.07, '20141212', 1075),
	(453.07, '20140326', 114),
	(284.74, '20150318', 717),
	(-208.27, '20140327', 252),
	(-393.25, '20150911', 603),
	(435.83, '20150521', 358),
	(-276.71, '20150915', 642),
	(-887.91, '20141022', 12),
	(-356.83, '20150817', 23),
	(-636.73, '20150811', 957),
	(-93.22, '20150406', 995),
	(-444.51, '20150911', 1121),
	(-566.69, '20140525', 568),
	(-108.26, '20141221', 514),
	(647.17, '20150121', 734),
	(-671.11, '20150115', 61),
	(-953.97, '20150623', 841),
	(507.81, '20150523', 240),
	(390.52, '20141202', 126),
	(95.5, '20150205', 339),
	(-728.92, '20150206', 958),
	(-276.06, '20150212', 1044),
	(-317.11, '20150611', 111),
	(540.9, '20150408', 585),
	(-781.12, '20140926', 873),
	(48.49, '20140530', 871),
	(414.24, '20141111', 803);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
VALUES 	(863.02, '20140907', 884),
	(753.49, '20150716', 1081),
	(648.38, '20141229', 191),
	(401.43, '20150616', 988),
	(-884.99, '20141031', 1068),
	(367.97, '20141112', 1021),
	(999.83, '20150515', 780),
	(459.42, '20150111', 63),
	(-927.22, '20151123', 920),
	(-675.31, '20151010', 88),
	(99.22, '20141128', 506),
	(200.37, '20151108', 802),
	(866.23, '20150607', 210),
	(-631.74, '20140829', 845),
	(979.19, '20150722', 210),
	(298.21, '20140918', 1067),
	(-500.73, '20150918', 126),
	(395.55, '20150831', 361),
	(-480.53, '20140108', 69),
	(-215.23, '20150617', 1122),
	(-509.05, '20150103', 933),
	(-297.09, '20141021', 350),
	(71.47, '20140722', 814),
	(-676.49, '20141125', 896),
	(-603.51, '20140215', 1023),
	(-622.65, '20150712', 885),
	(858.06, '20150326', 884),
	(822.98, '20140920', 595),
	(-129.65, '20151018', 582),
	(135.69, '20140224', 1002),
	(-285.77, '20150318', 1037),
	(88.34, '20150812', 368),
	(-686.43, '20141227', 179),
	(335.22, '20140828', 526),
	(-110.05, '20140111', 615),
	(136.3, '20150501', 479),
	(-929.18, '20150702', 966),
	(841.9, '20140203', 991),
	(530.11, '20150831', 943),
	(-933.92, '20150311', 49),
	(-571.27, '20150427', 819),
	(605.35, '20150407', 744),
	(-691.08, '20141230', 760),
	(-452.91, '20150624', 636),
	(813.02, '20150611', 466),
	(554.82, '20150426', 1042),
	(457.53, '20150824', 116),
	(-965.74, '20151024', 1125),
	(-822.91, '20140526', 429),
	(698.01, '20150823', 1052),
	(696.37, '20150201', 78),
	(940.18, '20140121', 35),
	(-423.2, '20150805', 920),
	(819.4, '20140614', 322),
	(-592.79, '20140209', 905),
	(-270.38, '20140103', 594),
	(915.65, '20150610', 711),
	(-621.12, '20150727', 889),
	(432.47, '20140710', 744),
	(303.35, '20141206', 281),
	(-956.58, '20141229', 248),
	(-267.42, '20141005', 235),
	(122.72, '20150918', 778),
	(33.68, '20140211', 212),
	(113.66, '20140202', 295),
	(83.07, '20150819', 467),
	(-261.15, '20140813', 506),
	(-597.1, '20150524', 354),
	(-605.64, '20150907', 557),
	(-429.3, '20160101', 666),
	(67.92, '20150429', 1005),
	(-714.36, '20140921', 465),
	(572.35, '20140531', 378),
	(69.65, '20141121', 139),
	(430.36, '20150624', 82),
	(591.71, '20151104', 466),
	(-382.93, '20151103', 314),
	(-701.9, '20150930', 90),
	(-980.07, '20141027', 1033),
	(-485.17, '20150712', 963),
	(-781.08, '20150806', 956),
	(480.96, '20151207', 343),
	(-915.14, '20140619', 211),
	(569.79, '20140627', 903),
	(-482.87, '20140126', 1025),
	(807.06, '20140128', 989),
	(867.32, '20150220', 180),
	(491.34, '20150513', 990),
	(717.71, '20150602', 93),
	(127.59, '20140108', 905),
	(-808.82, '20150722', 411),
	(699.45, '20150721', 1073),
	(21.96, '20150523', 1108),
	(-742.84, '20140704', 843),
	(-73.28, '20150726', 990),
	(-419.05, '20140815', 411),
	(-82.39, '20151108', 825),
	(-685.13, '20150427', 482),
	(-842.47, '20141003', 853),
	(677.74, '20140113', 1090);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
    VALUES 	(-112.39, '20141106', 789),
	(-251.76, '20150907', 504),
	(-473.35, '20150905', 114),
	(309.51, '20140905', 213),
	(-551.4, '20160101', 868),
	(296.32, '20140629', 802),
	(832.7, '20140303', 310),
	(691.83, '20150610', 307),
	(812.48, '20141105', 47),
	(87.16, '20140122', 946),
	(299.74, '20140118', 891),
	(931.57, '20151031', 803),
	(254.84, '20140413', 439),
	(-885.41, '20150401', 713),
	(374.8, '20150810', 850),
	(385.73, '20140825', 226),
	(175.87, '20150627', 895),
	(-261.14, '20151125', 1033),
	(-26.41, '20140825', 1081),
	(455.62, '20141017', 782),
	(-838.36, '20150524', 304),
	(-11.92, '20151029', 99),
	(-818.71, '20140524', 523),
	(131.58, '20141127', 514),
	(-246.11, '20150221', 695),
	(-956.91, '20151029', 195),
	(-42.75, '20150502', 1006),
	(-397.8, '20150818', 624),
	(252.65, '20140605', 148),
	(94.09, '20150622', 64),
	(-134.85, '20150710', 736),
	(-992.75, '20151223', 263),
	(-691.57, '20151111', 62),
	(95.22, '20151104', 337),
	(-212.2, '20141124', 827),
	(125.26, '20151220', 834),
	(-844.51, '20140212', 550),
	(-743.35, '20140602', 1122),
	(-22.37, '20140904', 1012),
	(11.82, '20140406', 275),
	(-245.27, '20141222', 238),
	(-680.71, '20141219', 166),
	(288.62, '20140114', 991),
	(360.84, '20140129', 264),
	(-889.89, '20150122', 1090),
	(-506.45, '20140318', 219),
	(-538.76, '20141213', 566),
	(267.08, '20140804', 647),
	(-75.98, '20150430', 359),
	(394.89, '20140331', 627),
	(-536.44, '20151214', 504),
	(-84.08, '20150711', 582),
	(374.72, '20140525', 776),
	(-268.43, '20150330', 1061),
	(313.06, '20140413', 602),
	(84.17, '20150502', 343),
	(-419.86, '20140608', 283),
	(927.18, '20150312', 317),
	(-202.07, '20151013', 394),
	(-626.39, '20140912', 253),
	(-63.82, '20150307', 1047),
	(-642.96, '20151122', 1028),
	(539.87, '20141214', 647),
	(-358.18, '20140630', 1121),
	(-200.67, '20140615', 371),
	(-548.74, '20141225', 429),
	(350.88, '20150117', 413),
	(-40.33, '20150817', 714),
	(-611.39, '20150715', 454),
	(-254.85, '20140130', 289),
	(77.27, '20151112', 416),
	(481.84, '20151109', 314),
	(-263.12, '20140513', 302),
	(-487.89, '20140324', 1040),
	(-979.92, '20150401', 178),
	(513.43, '20140708', 517),
	(-111.3, '20150716', 1038),
	(-159.58, '20140328', 284),
	(246.97, '20151111', 760),
	(-892.75, '20140325', 605),
	(-309.49, '20150213', 357),
	(-18.97, '20150415', 891),
	(581.41, '20140820', 916),
	(-383.79, '20140427', 614),
	(-479.68, '20150803', 670),
	(-241.75, '20150721', 416),
	(597.9, '20151210', 5),
	(-68.41, '20150424', 188),
	(802.41, '20150209', 1061),
	(-647.84, '20150501', 1017),
	(-754.13, '20150428', 423),
	(782.82, '20140721', 814),
	(-865.04, '20150724', 1035),
	(915, '20150130', 254),
	(-284.56, '20140812', 259),
	(868.52, '20150314', 806),
	(525.05, '20150715', 798),
	(216.35, '20150901', 172),
	(-118.96, '20150625', 145),
	(-845.26, '20150606', 925);
INSERT INTO EmpTransaction  (Amount, DateOfTransaction, Emp_id) 
   VALUES 	(868.26, '20150526', 698),
	(721.2, '20140301', 928),
	(768.78, '20140801', 667),
	(350.59, '20150228', 615),
	(380.48, '20151021', 335),
	(-352.67, '20150724', 575),
	(508.89, '20140410', 891),
	(346.01, '20150715', 920),
	(-859.22, '20140507', 245),
	(-978.18, '20150124', 443),
	(-555.71, '20140505', 1073),
	(-218.18, '20140423', 300),
	(-902.09, '20140411', 277),
	(-991.89, '20140622', 950),
	(-245.41, '20140312', 854),
	(601.01, '20140609', 341),
	(-44.45, '20151006', 267),
	(7.77, '20140827', 449),
	(991.52, '20140130', 1028),
	(985.29, '20140923', 120),
	(-431.84, '20150328', 957),
	(451.92, '20140723', 636),
	(740.25, '20141217', 801),
	(703.9, '20140827', 164),
	(-972.69, '20150905', 408),
	(-394.71, '20140605', 1083),
	(-234.56, '20140619', 537),
	(-187.01, '20150318', 792),
	(-294.31, '20151024', 494),
	(-493.01, '20140518', 81),
	(-78.42, '20150329', 594),
	(84.31, '20150207', 277),
	(809.45, '20140918', 734),
	(-831.44, '20140321', 422),
	(705.89, '20140210', 188),
	(505.21, '20140812', 432),
	(221.96, '20140218', 667),
	(-908.49, '20150521', 248),
	(498.17, '20141221', 157),
	(626.64, '20150404', 791),
	(370.77, '20140923', 731),
	(-174.72, '20140313', 153),
	(974.24, '20140902', 641),
	(294.64, '20150619', 932),
	(852.18, '20150906', 193),
	(-803.14, '20140403', 397),
	(-278.19, '20140605', 106),
	(166.3, '20141108', 1051),
	(-922.38, '20141002', 239),
	(-149.87, '20151014', 997),
	(300.85, '20150428', 8),
	(-594.16, '20151129', 895),
	(-263.17, '20141227', 567),
	(-889.9, '20141206', 822),
	(-104.14, '20150625', 1039),
	(-542.25, '20140819', 712),
	(284.22, '20140310', 840),
	(-684.58, '20141218', 773),
	(982.79, '20150415', 898),
	(731.85, '20151003', 101),
	(887.92, '20150206', 424),
	(57.42, '20151020', 1079),
	(123.05, '20141029', 752),
	(-831.08, '20150224', 829),
	(856.18, '20140702', 902),
	(-998.09, '20151114', 1115),
	(510.72, '20140506', 905),
	(130.38, '20150127', 978),
	(108.3, '20150418', 649),
	(-736.43, '20151229', 663),
	(646.55, '20140814', 307),
	(-226.93, '20140613', 994),
	(394.49, '20140630', 66),
	(-413.52, '20140821', 170),
	(423.06, '20151011', 196),
	(-556.22, '20150815', 977),
	(350.75, '20140415', 976),
	(510.62, '20150315', 931),
	(40.35, '20150804', 249),
	(-948.71, '20140716', 516),
	(508.49, '20151213', 391),
	(-505.11, '20141113', 875),
	(984.99, '20150312', 302),
	(423.61, '20141003', 537),
	(-494.07, '20140906', 756),
	(899.32, '20150824', 16),
	(988.02, '20150523', 937),
	(-573.43, '20150302', 535),
	(334.64, '20140617', 1025),
	(845.82, '20140506', 360),
	(621.84, '20150715', 544),
	(-784.42, '20141122', 743),
	(83.41, '20150710', 34),
	(563.41, '20140223', 11),
	(-168.87, '20141016', 578),
	(-839.82, '20140428', 791),
	(819.06, '20150815', 92),
	(-275.64, '20141008', 471),
	(-868.51, '20150623', 764),
	(-909.29, '20140628', 526);

--- Create and populate Department


INSERT INTO Department ( Dept_Name, DepartmentHead) 
    VALUES 
	('Litigation', 'M. Davidson'),
	('Customer Relations', 'Randy S. Hayden'),
	('Commercial', 'Hayat K. Khan'),
	('HR', 'Nargis N. Phakri');