create table proj_stg (Emp_ID varchar(8),
Emp_NM varchar(50),
Email varchar(100),
hire_dt date,
job_title varchar(100),
salary int,
department_nm varchar(50),
manager varchar(50),
start_dt date,
end_dt date,
location varchar(50),
address varchar(100),
city varchar(50),
state varchar(2),
education_lvl varchar(50));
insert into proj_stg (Emp_ID, Emp_NM, email, hire_dt, job_title, salary, department_nm, manager, start_dt, end_dt, location, address, city, state, education_lvl)
values
('E17469', 'Haifa Hajiri', '[email protected]',' 2003-12-17 ','Administrative Assistant', 47418 , 'Distribution', 'Allison Gentle',' 2003-12-17 ',' 2100-01-01 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'No College'),
('E27621', 'Wendell Mobley', '[email protected]',' 2013-11-27 ','Administrative Assistant', 28969 , 'Distribution', 'Allison Gentle',' 2013-11-27 ',' 2100-01-02 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Some College'),
('E27909', 'Michael Sperduti', '[email protected]',' 2014-06-20 ','Administrative Assistant', 43778 , 'Distribution', 'Allison Gentle',' 2014-06-20 ',' 2100-01-03 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Associates Degree'),
('E35053', 'Ashley Bergman', '[email protected]',' 2009-03-01 ','Administrative Assistant', 41090 , 'Distribution', 'Allison Gentle',' 2009-03-01 ',' 2100-01-04 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'No College'),
('E51723', 'Carlos Lopez', '[email protected]',' 2014-05-23 ','Administrative Assistant', 35825 , 'Distribution', 'Allison Gentle',' 2014-05-23 ',' 2100-01-05 ','East Coast', '165 Broadway', 'New York City', 'NY', 'No College'),
('E59688', 'Jason Wingard', '[email protected]',' 2006-01-11 ','Administrative Assistant', 34809 , 'Distribution', 'Allison Gentle',' 2006-01-11 ',' 2100-01-06 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Some College'),
('E18697', 'Anita Deluise', '[email protected]',' 1995-06-01 ','Administrative Assistant', 45325 , 'HQ', 'Tyrone Hutchison',' 1995-06-01 ',' 2100-01-07 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Associates Degree'),
('E25640', 'Joseph Donohue', '[email protected]',' 2007-12-27 ','Administrative Assistant', 40647 , 'HQ', 'Tyrone Hutchison',' 2007-12-27 ',' 2100-01-08 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'No College'),
('E35075', 'John Certa', '[email protected]',' 2007-08-29 ','Administrative Assistant', 51633 , 'HQ', 'Tyrone Hutchison',' 2007-08-29 ',' 2100-01-09 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Some College'),
('E56459', 'Raven Landis', '[email protected]',' 2016-04-21 ','Administrative Assistant', 42313 , 'HQ', 'Tyrone Hutchison',' 2016-04-21 ',' 2100-01-10 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Associates Degree'),
('E78732', 'Randy Myers', '[email protected]',' 2020-01-24 ','Administrative Assistant', 34084 , 'HQ', 'Tyrone Hutchison',' 2020-01-24 ',' 2100-01-11 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Associates Degree'),
('E90407', 'Danny Godiksen', '[email protected]',' 2010-12-15 ','Administrative Assistant', 28373 , 'HQ', 'Tyrone Hutchison',' 2010-12-15 ',' 2100-01-12 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Associates Degree'),
('E45824', 'Raj Prudvi', '[email protected]',' 2017-10-03 ','Administrative Assistant', 51052 , 'IT', 'Jacob Lauber',' 2017-10-03 ',' 2100-01-13 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Associates Degree'),
('E48148', 'Alexis Fitzpatrick', '[email protected]',' 2013-02-19 ','Administrative Assistant', 39450 , 'IT', 'Jacob Lauber',' 2013-02-19 ',' 2100-01-14 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'No College'),
('E50012', 'Ann Roberto', '[email protected]',' 2009-10-01 ','Administrative Assistant', 37136 , 'IT', 'Jacob Lauber',' 2009-10-01 ',' 2100-01-15 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'No College'),
('E81502', 'Danny Laxton', '[email protected]',' 1999-10-24 ','Administrative Assistant', 34677 , 'IT', 'Jacob Lauber',' 1999-10-24 ',' 2100-01-16 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Some College'),
('E83558', 'Laura McKenna', '[email protected]',' 1997-10-15 ','Administrative Assistant', 45210 , 'IT', 'Jacob Lauber',' 1997-10-15 ',' 2100-01-17 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Associates Degree'),
('E99949', 'William Graf', '[email protected]',' 2005-05-26 ','Administrative Assistant', 50043 , 'IT', 'Jacob Lauber',' 2005-05-26 ',' 2100-01-18 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E12562', 'Keith Ingram', '[email protected]',' 1996-04-14 ','Administrative Assistant', 48910 , 'Product Development', 'Conner Kinch',' 1996-04-14 ',' 2100-01-19 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Some College'),
('E16346', 'Jill Fram', '[email protected]',' 2007-12-16 ','Administrative Assistant', 50462 , 'Product Development', 'Conner Kinch',' 2007-12-16 ',' 2100-01-20 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Associates Degree'),
('E37523', 'Alan Mecklet', '[email protected]',' 2017-12-02 ','Administrative Assistant', 35638 , 'Product Development', 'Conner Kinch',' 2017-12-02 ',' 2100-01-21 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E57987', 'Nicole Lee', '[email protected]',' 2016-05-15 ','Administrative Assistant', 49786 , 'Product Development', 'Conner Kinch',' 2016-05-15 ',' 2100-01-22 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'No College'),
('E73518', 'Cheryl Pike', '[email protected]',' 2001-03-24 ','Administrative Assistant', 51207 , 'Product Development', 'Conner Kinch',' 2001-03-24 ',' 2100-01-23 ','South', '422 Broadway', 'Nashville', 'TN', 'No College'),
('E74296', 'Krishna Burli', '[email protected]',' 2016-12-19 ','Administrative Assistant', 47909 , 'Product Development', 'Conner Kinch',' 2016-12-19 ',' 2100-01-24 ','South', '422 Broadway', 'Nashville', 'TN', 'Some College'),
('E77317', 'Kathy Abiskaroon', '[email protected]',' 2015-05-20 ','Administrative Assistant', 34693 , 'Product Development', 'Conner Kinch',' 2015-05-20 ',' 2100-01-25 ','South', '422 Broadway', 'Nashville', 'TN', 'Associates Degree'),
('E91791', 'Aaron Richman', '[email protected]',' 2017-06-02 ','Administrative Assistant', 29593 , 'Product Development', 'Conner Kinch',' 2017-06-02 ',' 2100-01-26 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Associates Degree'),
('E94358', 'Muhammed Rubel', '[email protected]',' 2007-07-08 ','Administrative Assistant', 48239 , 'Product Development', 'Conner Kinch',' 2007-07-08 ',' 2100-01-27 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Associates Degree'),
('E34496', 'Tony Hughes', '[email protected]',' 2009-01-27 ','Administrative Assistant', 31405 , 'Sales', 'Jennifer De La Garza',' 2009-01-27 ',' 2100-01-28 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Associates Degree'),
('E87219', 'Jorge Moscoso', '[email protected]',' 2017-09-20 ','Administrative Assistant', 34826 , 'Sales', 'Jennifer De La Garza',' 2017-09-20 ',' 2100-01-29 ','South', '422 Broadway', 'Nashville', 'TN', 'No College'),
('E89540', 'Amit Hardiya', '[email protected]',' 2017-06-01 ','Administrative Assistant', 38176 , 'Sales', 'Jennifer De La Garza',' 2017-06-01 ',' 2100-01-30 ','East Coast', '165 Broadway', 'New York City', 'NY', 'No College'),
('E13160', 'Eric Baxter', 'Eric [email protected]',' 2008-10-06 ','Database Administrator', 102614 , 'IT', 'Jacob Lauber',' 2008-10-06 ',' 2100-01-31 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Associates Degree'),
('E16678', 'Abby Lockhart', '[email protected]',' 2005-11-25 ','Database Administrator', 84297 , 'IT', 'Jacob Lauber',' 2005-11-25 ',' 2100-02-01 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E27498', 'Toni Lembeck', '[email protected]',' 2001-07-18 ','Database Administrator', 78206 , 'IT', 'Jacob Lauber',' 2001-07-18 ',' 2100-02-02 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E37246', 'Paulius Mikalainis', '[email protected]',' 2013-10-23 ','Database Administrator', 103370 , 'IT', 'Jacob Lauber',' 2013-10-23 ',' 2100-02-03 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E49025', 'Mark Fiore', '[email protected]',' 2005-06-09 ','Database Administrator', 111308 , 'IT', 'Jacob Lauber',' 2005-06-09 ',' 2100-02-04 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E76443', 'Thanuja Polani', '[email protected]',' 2020-02-16 ','Database Administrator', 114582 , 'IT', 'Jacob Lauber',' 2020-02-16 ',' 2100-02-05 ','South', '422 Broadway', 'Nashville', 'TN', 'Masters Degree'),
('E86828', 'Philip Barnett', '[email protected]',' 2011-09-29 ','Database Administrator', 116831 , 'IT', 'Jacob Lauber',' 2011-09-29 ',' 2100-02-06 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Masters Degree'),
('E98891', 'Doris Venama', '[email protected]',' 2017-09-30 ','Database Administrator', 110704 , 'IT', 'Jacob Lauber',' 2017-09-30 ',' 2100-02-07 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters Degree'),
('E34500', 'Kathy Fedder', '[email protected]',' 1997-01-17 ','Design Engineer', 113744 , 'IT', 'Jacob Lauber',' 1997-01-17 ',' 2100-02-08 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E41635', 'James Aryeetey', '[email protected]',' 2005-03-26 ','Design Engineer', 134237 , 'IT', 'Jacob Lauber',' 2005-03-26 ',' 2100-02-09 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E51619', 'Tom Meola', '[email protected]',' 2011-10-05 ','Design Engineer', 122334 , 'IT', 'Jacob Lauber',' 2011-10-05 ',' 2100-02-10 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E98270', 'Jeff Barnhill', '[email protected]',' 1997-12-24 ','Design Engineer', 99218 , 'IT', 'Jacob Lauber',' 1997-12-24 ',' 2100-02-11 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E25710', 'Brent Robinson', '[email protected]',' 2005-08-14 ','Design Engineer', 77155 , 'Product Development', 'Conner Kinch',' 2005-08-14 ',' 2100-02-12 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Masters Degree'),
('E41712', 'Elaine Podwika', '[email protected]',' 2012-01-06 ','Design Engineer', 87465 , 'Product Development', 'Conner Kinch',' 2012-01-06 ',' 2100-02-13 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E42522', 'Fiona Morris', '[email protected]',' 2007-05-26 ','Design Engineer', 79694 , 'Product Development', 'Conner Kinch',' 2007-05-26 ',' 2100-02-14 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E45758', 'Walter Waddler', '[email protected]',' 2017-12-19 ','Design Engineer', 144623 , 'Product Development', 'Conner Kinch',' 2017-12-19 ',' 2100-02-15 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E48637', 'Joey Fulkerson', '[email protected]',' 1999-09-26 ','Design Engineer', 140231 , 'Product Development', 'Conner Kinch',' 1999-09-26 ',' 2100-02-16 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E60752', 'Michael Tholstrup', '[email protected]',' 2010-02-27 ','Design Engineer', 138695 , 'Product Development', 'Conner Kinch',' 2010-02-27 ',' 2100-02-17 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Masters Degree'),
('E77658', 'Hitesh Bhatt', '[email protected]',' 2012-03-15 ','Design Engineer', 113702 , 'Product Development', 'Conner Kinch',' 2012-03-15 ',' 2100-02-18 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Masters Degree'),
('E85476', 'Shawn Reynolds', '[email protected]',' 2003-07-22 ','Design Engineer', 71982 , 'Product Development', 'Conner Kinch',' 2003-07-22 ',' 2100-02-19 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Doctorate'),
('E38677', 'Michael Scilla', '[email protected]',' 2014-04-17 ','Legal Counsel', 201404 , 'Distribution', 'Allison Gentle',' 2014-04-17 ',' 2100-02-20 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Doctorate'),
('E45736', 'John Perez', '[email protected]',' 2015-04-04 ','Legal Counsel', 156298 , 'Distribution', 'Allison Gentle',' 2015-04-04 ',' 2100-02-21 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Doctorate'),
('E56144', 'Cassidy Clayton', '[email protected]',' 2013-01-28 ','Legal Counsel', 169184 , 'Distribution', 'Allison Gentle',' 2013-01-28 ',' 2100-02-22 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Doctorate'),
('E33486', 'Stephen Colluci', '[email protected]',' 2000-08-02 ','Legal Counsel', 153296 , 'HQ', 'Tyrone Hutchison',' 2000-08-02 ',' 2100-02-23 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Doctorate'),
('E38634', 'Zach Bratkovich', '[email protected]',' 2014-11-22 ','Legal Counsel', 144638 , 'HQ', 'Tyrone Hutchison',' 2014-11-22 ',' 2100-02-24 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Doctorate'),
('E53406', 'Janice Mayzlik', '[email protected]',' 2001-10-25 ','Legal Counsel', 81812 , 'HQ', 'Tyrone Hutchison',' 2001-10-25 ',' 2100-02-25 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters Degree'),
('E75081', 'Dennis Fredrich', '[email protected]',' 2008-10-08 ','Legal Counsel', 132436 , 'HQ', 'Tyrone Hutchison',' 2008-10-08 ',' 2100-02-26 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters Degree'),
('E79464', 'Anu Patel', '[email protected]',' 1999-05-01 ','Legal Counsel', 177673 , 'HQ', 'Tyrone Hutchison',' 1999-05-01 ',' 2100-02-27 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters Degree'),
('E96856', 'Tom Wilson', '[email protected]',' 2017-11-27 ','Legal Counsel', 127669 , 'HQ', 'Tyrone Hutchison',' 2017-11-27 ',' 2100-02-28 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters Degree'),
('E47655', 'Cody Holland', '[email protected]',' 1997-11-27 ','Legal Counsel', 207651 , 'IT', 'Jacob Lauber',' 1997-11-27 ',' 2100-03-01 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Doctorate'),
('E87210', 'Gary Boyd', '[email protected]',' 2014-04-18 ','Legal Counsel', 176207 , 'IT', 'Jacob Lauber',' 2014-04-18 ',' 2100-03-02 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Doctorate'),
('E95214', 'Faheem Ahmed', '[email protected]',' 2019-09-22 ','Legal Counsel', 93400 , 'IT', 'Jacob Lauber',' 2019-09-22 ',' 2100-03-03 ','South', '422 Broadway', 'Nashville', 'TN', 'Doctorate'),
('E21696', 'Mallory Russo', '[email protected]',' 1997-12-06 ','Legal Counsel', 167887 , 'Product Development', 'Conner Kinch',' 1997-12-06 ',' 2100-03-04 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E60929', 'Tanya Maheshwari', '[email protected]',' 2013-07-03 ','Legal Counsel', 195992 , 'Product Development', 'Conner Kinch',' 2013-07-03 ',' 2100-03-05 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Masters Degree'),
('E76053', 'Darryl Reamer', '[email protected]',' 1998-08-23 ','Legal Counsel', 83548 , 'Product Development', 'Conner Kinch',' 1998-08-23 ',' 2100-03-06 ','South', '422 Broadway', 'Nashville', 'TN', 'Doctorate'),
('E43694', 'Benyam Gizaw', '[email protected]',' 2016-10-28 ','Legal Counsel', 159035 , 'Sales', 'Jennifer De La Garza',' 2016-10-28 ',' 2100-03-07 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Doctorate'),
('E71792', 'Jesse Curiel', '[email protected]',' 2014-03-30 ','Legal Counsel', 123496 , 'Sales', 'Jennifer De La Garza',' 2014-03-30 ',' 2100-03-08 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Doctorate'),
('E93629', 'Tracy Emerson', '[email protected]',' 2013-07-22 ','Legal Counsel', 183807 , 'Sales', 'Jennifer De La Garza',' 2013-07-22 ',' 2100-03-09 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Doctorate'),
('E63041', 'Allison Gentle', '[email protected]',' 1995-08-22 ','Manager', 176000 , 'Distribution', 'Tyrone Hutchison',' 1995-08-22 ',' 2100-03-10 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Masters of Business Administration'),
('E44426', 'Jacob Lauber', '[email protected]',' 2007-05-02 ','Manager', 205000 , 'IT', 'Tyrone Hutchison',' 2007-05-02 ',' 2100-03-11 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters of Business Administration'),
('E77884', 'Conner Kinch', '[email protected]',' 2002-12-09 ','Manager', 187000 , 'Product Development', 'Tyrone Hutchison',' 2002-12-09 ',' 2100-03-12 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Masters of Business Administration'),
('E88667', 'Jennifer De La Garza', 'Jennifer.De La [email protected]',' 1995-12-21 ','Manager', 210000 , 'Sales', 'Tyrone Hutchison',' 1995-12-21 ',' 2100-03-13 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Masters Degree'),
('E22197', 'Oliver Jia', '[email protected]',' 2013-09-22 ','Network Engineer', 89618 , 'IT', 'Jacob Lauber',' 2013-09-22 ',' 2100-03-14 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters Degree'),
('E24100', 'Zondra Peck', '[email protected]',' 1997-03-06 ','Network Engineer', 98994 , 'IT', 'Jacob Lauber',' 1997-03-06 ',' 2100-03-15 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Masters Degree'),
('E26874', 'Tiffany Harrington', '[email protected]',' 2015-06-27 ','Network Engineer', 45412 , 'IT', 'Jacob Lauber',' 2015-06-27 ',' 2100-03-16 ','South', '422 Broadway', 'Nashville', 'TN', 'Masters Degree'),
('E34748', 'Holly Smith', '[email protected]',' 2011-04-28 ','Network Engineer', 71942 , 'IT', 'Jacob Lauber',' 2011-04-28 ',' 2100-03-17 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E36960', 'Ken Beer', '[email protected]',' 2008-04-26 ','Network Engineer', 101294 , 'IT', 'Jacob Lauber',' 2008-04-26 ',' 2100-03-18 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Bachelors Degree'),
('E48884', 'Stacey Lewis', '[email protected]',' 2008-06-01 ','Network Engineer', 103714 , 'IT', 'Jacob Lauber',' 2008-06-01 ',' 2100-03-19 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E62527', 'Barry Walsh', '[email protected]',' 2006-06-15 ','Network Engineer', 49816 , 'IT', 'Jacob Lauber',' 2006-06-15 ',' 2100-03-20 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E62634', 'Karen Lafler', '[email protected]',' 2014-08-19 ','Network Engineer', 65515 , 'IT', 'Jacob Lauber',' 2014-08-19 ',' 2100-03-21 ','South', '422 Broadway', 'Nashville', 'TN', 'Associates Degree'),
('E67793', 'Fausto Recalde', '[email protected]',' 2018-06-07 ','Network Engineer', 52924 , 'IT', 'Jacob Lauber',' 2018-06-07 ',' 2100-03-22 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E79552', 'Angela Masdary', '[email protected]',' 2008-02-05 ','Network Engineer', 84625 , 'IT', 'Jacob Lauber',' 2008-02-05 ',' 2100-03-23 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E81369', 'Kevin Soltis', '[email protected]',' 2019-05-29 ','Network Engineer', 93362 , 'IT', 'Jacob Lauber',' 2019-05-29 ',' 2100-03-24 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E83512', 'Tim Lawler', '[email protected]',' 1996-10-22 ','Network Engineer', 103110 , 'IT', 'Jacob Lauber',' 1996-10-22 ',' 2100-03-25 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E91075', 'Micah Vass', '[email protected]',' 2019-12-15 ','Network Engineer', 68127 , 'IT', 'Jacob Lauber',' 2019-12-15 ',' 2100-03-26 ','South', '422 Broadway', 'Nashville', 'TN', 'Associates Degree'),
('E11678', 'Colleen Alma', '[email protected]',' 2001-12-26 ','Network Engineer', 76913 , 'Product Development', 'Conner Kinch',' 2001-12-26 ',' 2100-03-27 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Associates Degree'),
('E12397', 'Daniel Matkovic', '[email protected]',' 2013-11-17 ','Network Engineer', 71846 , 'Product Development', 'Conner Kinch',' 2013-11-17 ',' 2100-03-28 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Associates Degree'),
('E14913', 'Aaron Gordon ', 'Aaron.Gordon @TechCorp.com',' 1998-07-15 ','Network Engineer', 103166 , 'Product Development', 'Conner Kinch',' 1998-07-15 ',' 2100-03-29 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E23669', 'Karen Brown', '[email protected]',' 2017-04-23 ','Network Engineer', 77370 , 'Product Development', 'Conner Kinch',' 2017-04-23 ',' 2100-03-30 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E30317', 'Siena Spitzer', '[email protected]',' 2019-01-03 ','Network Engineer', 66952 , 'Product Development', 'Conner Kinch',' 2019-01-03 ',' 2100-03-31 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E47926', 'Janice Canterbury', '[email protected]',' 2008-05-31 ','Network Engineer', 85880 , 'Product Development', 'Conner Kinch',' 2008-05-31 ',' 2100-04-01 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E66477', 'Dakeem Coleman', '[email protected]',' 2018-05-08 ','Network Engineer', 86055 , 'Product Development', 'Conner Kinch',' 2018-05-08 ',' 2100-04-02 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Masters Degree'),
('E80744', 'Ginger Logan', '[email protected]',' 2020-01-09 ','Network Engineer', 96416 , 'Product Development', 'Conner Kinch',' 2020-01-09 ',' 2100-04-03 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Masters Degree'),
('E17054', 'Tyrone Hutchison', '[email protected]',' 2006-09-07 ','President', 540000 , 'HQ', 'None', ' 2006-09-07 ',' 2100-04-04 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters of Business Administration'),
('E10407', 'Darshan Rathod', '[email protected]',' 2018-10-08 ','Sales Rep', 180692 , 'Product Development', 'Conner Kinch',' 2018-10-08 ',' 2100-04-05 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E13596', 'Kenneth Dewitt', '[email protected]',' 2012-04-09 ','Sales Rep', 180913 , 'Product Development', 'Conner Kinch',' 2012-04-09 ',' 2100-04-06 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E16995', 'Wilson Martinez', '[email protected]',' 2001-02-28 ','Sales Rep', 130161 , 'Product Development', 'Conner Kinch',' 2001-02-28 ',' 2100-04-07 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E22680', 'Cassidy Bancroft', '[email protected]',' 2013-10-26 ','Sales Rep', 196637 , 'Product Development', 'Conner Kinch',' 2013-10-26 ',' 2100-04-08 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E23429', 'Andrew Yoon', '[email protected]',' 2018-11-14 ','Sales Rep', 114616 , 'Product Development', 'Conner Kinch',' 2018-11-14 ',' 2100-04-09 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Associates Degree'),
('E25662', 'Doug Tomson', '[email protected]',' 1995-06-22 ','Sales Rep', 188080 , 'Product Development', 'Conner Kinch',' 1995-06-22 ',' 2100-04-10 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E28092', 'Tuan Yang', '[email protected]',' 2008-11-01 ','Sales Rep', 174651 , 'Product Development', 'Conner Kinch',' 2008-11-01 ',' 2100-04-11 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Bachelors Degree');
insert into proj_stg (Emp_ID, Emp_NM, email, hire_dt, job_title, salary, department_nm, manager, start_dt, end_dt, location, address, city, state, education_lvl)
values
('E28638', 'Marie Dumadara', '[email protected]',' 2004-06-02 ','Sales Rep', 123909 , 'Product Development', 'Conner Kinch',' 2004-06-02 ',' 2100-04-12 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E30058', 'Bertin Dakouo', '[email protected]',' 2013-09-24 ','Sales Rep', 81047 , 'Product Development', 'Conner Kinch',' 2013-09-24 ',' 2100-04-13 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E30678', 'Jody Hopkins', '[email protected]',' 2020-05-02 ','Sales Rep', 91389 , 'Product Development', 'Conner Kinch',' 2020-05-02 ',' 2100-04-14 ','South', '422 Broadway', 'Nashville', 'TN', 'Masters Degree'),
('E31241', 'Laura House', '[email protected]',' 2014-05-10 ','Sales Rep', 157102 , 'Product Development', 'Conner Kinch',' 2014-05-10 ',' 2100-04-15 ','South', '422 Broadway', 'Nashville', 'TN', 'Associates Degree'),
('E32058', 'Curtis Gibson', '[email protected]',' 2009-01-19 ','Sales Rep', 140534 , 'Product Development', 'Conner Kinch',' 2009-01-19 ',' 2100-04-16 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E34816', 'Roseann Martineeti', '[email protected]',' 2000-08-01 ','Sales Rep', 82192 , 'Product Development', 'Conner Kinch',' 2000-08-01 ',' 2100-04-17 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E35860', 'Vivian Kovach', '[email protected]',' 1999-08-18 ','Sales Rep', 125831 , 'Product Development', 'Conner Kinch',' 1999-08-18 ',' 2100-04-18 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E39652', 'Kyle Guilmartin', '[email protected]',' 2012-08-11 ','Sales Rep', 71867 , 'Product Development', 'Conner Kinch',' 2012-08-11 ',' 2100-04-19 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E42681', 'James Henderson', '[email protected]',' 1996-04-09 ','Sales Rep', 101469 , 'Product Development', 'Conner Kinch',' 1996-04-09 ',' 2100-04-20 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E46366', 'Johnathan Wayman', '[email protected]',' 2004-10-16 ','Sales Rep', 133564 , 'Product Development', 'Conner Kinch',' 2004-10-16 ',' 2100-04-21 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Associates Degree'),
('E49798', 'Greg Stirton', '[email protected]',' 1998-01-09 ','Sales Rep', 79408 , 'Product Development', 'Conner Kinch',' 1998-01-09 ',' 2100-04-22 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E54196', 'Phil Wisneski', 'Phil [email protected]',' 2004-12-18 ','Sales Rep', 156344 , 'Product Development', 'Conner Kinch',' 2004-12-18 ',' 2100-04-23 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Bachelors Degree'),
('E57502', 'Frank Debanco', '[email protected]',' 2016-07-21 ','Sales Rep', 162790 , 'Product Development', 'Conner Kinch',' 2016-07-21 ',' 2100-04-24 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Bachelors Degree'),
('E63930', 'Sonali Baidya', '[email protected]',' 2009-02-25 ','Sales Rep', 125439 , 'Product Development', 'Conner Kinch',' 2009-02-25 ',' 2100-04-25 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E67190', 'Nathan Hile ', 'Nathan.Hile @TechCorp.com',' 2007-07-24 ','Sales Rep', 86624 , 'Product Development', 'Conner Kinch',' 2007-07-24 ',' 2100-04-26 ','South', '422 Broadway', 'Nashville', 'TN', 'Masters Degree'),
('E87073', 'Yuesef Hosni', '[email protected]',' 2007-01-02 ','Sales Rep', 146429 , 'Product Development', 'Conner Kinch',' 2007-01-02 ',' 2100-04-27 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Associates Degree'),
('E91182', 'Nick Gowen', '[email protected]',' 2013-05-18 ','Sales Rep', 96015 , 'Product Development', 'Conner Kinch',' 2013-05-18 ',' 2100-04-28 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E93734', 'Melissa DeMaio', '[email protected]',' 2005-06-21 ','Sales Rep', 111114 , 'Product Development', 'Conner Kinch',' 2005-06-21 ',' 2100-04-29 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E93871', 'Travis Black', '[email protected]',' 2002-04-30 ','Sales Rep', 88910 , 'Product Development', 'Conner Kinch',' 2002-04-30 ',' 2100-04-30 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E94387', 'Erica Davis', '[email protected]',' 2003-07-25 ','Sales Rep', 191995 , 'Product Development', 'Conner Kinch',' 2003-07-25 ',' 2100-05-01 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E95199', 'Carlos Fernandes', '[email protected]',' 2017-01-09 ','Sales Rep', 153889 , 'Product Development', 'Conner Kinch',' 2017-01-09 ',' 2100-05-02 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters Degree'),
('E97273', 'Justin Hayes', '[email protected]',' 2004-06-05 ','Sales Rep', 137555 , 'Product Development', 'Conner Kinch',' 2004-06-05 ',' 2100-05-03 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E11920', 'Sharon Gillies', '[email protected]',' 2006-06-19 ','Sales Rep', 115719 , 'Sales', 'Jennifer De La Garza',' 2006-06-19 ',' 2100-05-04 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E16276', 'Analyn Braza', '[email protected]',' 1996-03-07 ','Sales Rep', 208554 , 'Sales', 'Jennifer De La Garza',' 1996-03-07 ',' 2100-05-05 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E17372', 'Greg Pratt', '[email protected]',' 2009-06-08 ','Sales Rep', 170741 , 'Sales', 'Jennifer De La Garza',' 2009-06-08 ',' 2100-05-06 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E20101', 'Zoey Bulter', '[email protected]',' 2012-12-03 ','Sales Rep', 157172 , 'Sales', 'Jennifer De La Garza',' 2012-12-03 ',' 2100-05-07 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E22785', 'Tami Smith', '[email protected]',' 1997-12-08 ','Sales Rep', 83535 , 'Sales', 'Jennifer De La Garza',' 1997-12-08 ',' 2100-05-08 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters Degree'),
('E24539', 'Grace Messinger', '[email protected]',' 2004-12-12 ','Sales Rep', 173443 , 'Sales', 'Jennifer De La Garza',' 2004-12-12 ',' 2100-05-09 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E27267', 'Preston Lilly', '[email protected]',' 2010-08-29 ','Sales Rep', 206383 , 'Sales', 'Jennifer De La Garza',' 2010-08-29 ',' 2100-05-10 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E29129', 'Belinda Van Loon', 'Belinda.Van [email protected]',' 2007-12-03 ','Sales Rep', 118753 , 'Sales', 'Jennifer De La Garza',' 2007-12-03 ',' 2100-05-11 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E32359', 'Jen Frangias', 'Jen [email protected]',' 2019-03-24 ','Sales Rep', 102779 , 'Sales', 'Jennifer De La Garza',' 2019-03-24 ',' 2100-05-12 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E36346', 'Tyrone Curtis', '[email protected]',' 1999-06-22 ','Sales Rep', 100092 , 'Sales', 'Jennifer De La Garza',' 1999-06-22 ',' 2100-05-13 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E37389', 'Becky Weaver', '[email protected]',' 1996-12-08 ','Sales Rep', 172479 , 'Sales', 'Jennifer De La Garza',' 1996-12-08 ',' 2100-05-14 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters Degree'),
('E38997', 'Roseann Clemente', '[email protected]',' 2007-09-21 ','Sales Rep', 173887 , 'Sales', 'Jennifer De La Garza',' 2007-09-21 ',' 2100-05-15 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E42061', 'Diana Teppen', '[email protected]',' 2013-11-04 ','Sales Rep', 212551 , 'Sales', 'Jennifer De La Garza',' 2013-11-04 ',' 2100-05-16 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Bachelors Degree'),
('E44136', 'Erica Siegal', '[email protected]',' 2002-01-09 ','Sales Rep', 70148 , 'Sales', 'Jennifer De La Garza',' 2002-01-09 ',' 2100-05-17 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Bachelors Degree'),
('E45236', 'Patti Hoeg', '[email protected]',' 2008-05-29 ','Sales Rep', 123476 , 'Sales', 'Jennifer De La Garza',' 2008-05-29 ',' 2100-05-18 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E52461', 'Lena Thorton', '[email protected]',' 2014-11-11 ','Sales Rep', 196705 , 'Sales', 'Jennifer De La Garza',' 2014-11-11 ',' 2100-05-19 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E55855', 'Parker Williams', '[email protected]',' 2018-05-20 ','Sales Rep', 175296 , 'Sales', 'Jennifer De La Garza',' 2018-05-20 ',' 2100-05-20 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E56444', 'Curtis Steward', '[email protected]',' 1999-06-10 ','Sales Rep', 87817 , 'Sales', 'Jennifer De La Garza',' 1999-06-10 ',' 2100-05-21 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E60901', 'Samantha Kramer', '[email protected]',' 2010-01-10 ','Sales Rep', 87887 , 'Sales', 'Jennifer De La Garza',' 2010-01-10 ',' 2100-05-22 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E61614', 'Elliot Foley', '[email protected]',' 1996-07-21 ','Sales Rep', 174060 , 'Sales', 'Jennifer De La Garza',' 1996-07-21 ',' 2100-05-23 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E61947', 'Charles Wirry', '[email protected]',' 2010-03-04 ','Sales Rep', 212353 , 'Sales', 'Jennifer De La Garza',' 2010-03-04 ',' 2100-05-24 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E65052', 'Leobrian Mason', '[email protected]',' 1995-09-15 ','Sales Rep', 103346 , 'Sales', 'Jennifer De La Garza',' 1995-09-15 ',' 2100-05-25 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E68807', 'Wes Tappan', '[email protected]',' 2010-11-10 ','Sales Rep', 175879 , 'Sales', 'Jennifer De La Garza',' 2010-11-10 ',' 2100-05-26 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E70374', 'Norman Guerrero', '[email protected]',' 2007-08-19 ','Sales Rep', 123946 , 'Sales', 'Jennifer De La Garza',' 2007-08-19 ',' 2100-05-27 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E70603', 'Soek Sohn', '[email protected]',' 2006-07-06 ','Sales Rep', 89696 , 'Sales', 'Jennifer De La Garza',' 2006-07-06 ',' 2100-05-28 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E72436', 'Eileen Chuss', '[email protected]',' 2013-05-11 ','Sales Rep', 134130 , 'Sales', 'Jennifer De La Garza',' 2013-05-11 ',' 2100-05-29 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E74490', 'Alejandro Scannapieco', '[email protected]',' 1999-05-22 ','Sales Rep', 196226 , 'Sales', 'Jennifer De La Garza',' 1999-05-22 ',' 2100-05-30 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E87230', 'Sara Erwin', '[email protected]',' 2014-11-10 ','Sales Rep', 144637 , 'Sales', 'Jennifer De La Garza',' 2014-11-10 ',' 2100-05-31 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E87370', 'Misha Tsidulko', '[email protected]',' 2013-11-18 ','Sales Rep', 105960 , 'Sales', 'Jennifer De La Garza',' 2013-11-18 ',' 2100-06-01 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Bachelors Degree'),
('E88864', 'Susan Woodruff', '[email protected]',' 2008-11-15 ','Sales Rep', 209418 , 'Sales', 'Jennifer De La Garza',' 2008-11-15 ',' 2100-06-02 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Bachelors Degree'),
('E90222', 'Yawer Ali', '[email protected]',' 2016-11-01 ','Sales Rep', 158549 , 'Sales', 'Jennifer De La Garza',' 2016-11-01 ',' 2100-06-03 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E93715', 'Charles Barker', '[email protected]',' 1998-04-29 ','Sales Rep', 196650 , 'Sales', 'Jennifer De La Garza',' 1998-04-29 ',' 2100-06-04 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E98559', 'Max Yish', '[email protected]',' 2006-11-11 ','Sales Rep', 101957 , 'Sales', 'Jennifer De La Garza',' 2006-11-11 ',' 2100-06-05 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E13085', 'Susan Cole ', 'Susan.Cole @TechCorp.com',' 2017-05-01 ','Shipping and Receiving', 27811 , 'Distribution', 'Allison Gentle',' 2017-05-01 ',' 2100-06-06 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E14737', 'Juan Cosme', '[email protected]',' 2012-07-22 ','Shipping and Receiving', 26050 , 'Distribution', 'Allison Gentle',' 2012-07-22 ',' 2100-06-07 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E15267', 'Shanteel Jackson', '[email protected]',' 1998-02-22 ','Shipping and Receiving', 40806 , 'Distribution', 'Allison Gentle',' 1998-02-22 ',' 2100-06-08 ','East Coast', '165 Broadway', 'New York City', 'NY', 'No College'),
('E31931', 'Leo Manhanga', '[email protected]',' 2013-09-26 ','Shipping and Receiving', 38206 , 'Distribution', 'Allison Gentle',' 2013-09-26 ',' 2100-06-09 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Some College'),
('E36988', 'Michelle Zietz', '[email protected]',' 2015-10-31 ','Shipping and Receiving', 48680 , 'Distribution', 'Allison Gentle',' 2015-10-31 ',' 2100-06-10 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Associates Degree'),
('E45405', 'Prashant Sharma', '[email protected]',' 2000-09-06 ','Shipping and Receiving', 40083 , 'Distribution', 'Allison Gentle',' 2000-09-06 ',' 2100-06-11 ','East Coast', '165 Broadway', 'New York City', 'NY', 'No College'),
('E49459', 'Courtney Newman', '[email protected]',' 2020-03-28 ','Shipping and Receiving', 42145 , 'Distribution', 'Allison Gentle',' 2020-03-28 ',' 2100-06-12 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Some College'),
('E52489', 'Kelly Price', '[email protected]',' 2002-12-05 ','Shipping and Receiving', 27045 , 'Distribution', 'Allison Gentle',' 2002-12-05 ',' 2100-06-13 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Associates Degree'),
('E53895', 'Kumar Durairaj', '[email protected]',' 2014-10-27 ','Shipping and Receiving', 28700 , 'Distribution', 'Allison Gentle',' 2014-10-27 ',' 2100-06-14 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'No College'),
('E55880', 'Alex Warring', '[email protected]',' 1995-07-18 ','Shipping and Receiving', 43410 , 'Distribution', 'Allison Gentle',' 1995-07-18 ',' 2100-06-15 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Some College'),
('E69297', 'Nilden Tutalar', '[email protected]',' 2013-03-21 ','Shipping and Receiving', 31349 , 'Distribution', 'Allison Gentle',' 2013-03-21 ',' 2100-06-16 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Associates Degree'),
('E71128', 'Stan Frank', '[email protected]',' 1998-01-28 ','Shipping and Receiving', 48749 , 'Distribution', 'Allison Gentle',' 1998-01-28 ',' 2100-06-17 ','South', '422 Broadway', 'Nashville', 'TN', 'No College'),
('E86238', 'Raymond Dorset', '[email protected]',' 2012-04-21 ','Shipping and Receiving', 30081 , 'Distribution', 'Allison Gentle',' 2012-04-21 ',' 2100-06-18 ','South', '422 Broadway', 'Nashville', 'TN', 'Some College'),
('E90435', 'Russell Morales', '[email protected]',' 2017-02-20 ','Shipping and Receiving', 52933 , 'Distribution', 'Allison Gentle',' 2017-02-20 ',' 2100-06-19 ','South', '422 Broadway', 'Nashville', 'TN', 'Associates Degree'),
('E95190', 'Christina Roth', '[email protected]',' 2016-04-26 ','Shipping and Receiving', 51407 , 'Distribution', 'Allison Gentle',' 2016-04-26 ',' 2100-06-20 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E15292', 'Melinda Fisher', '[email protected]',' 2011-02-06 ','Software Engineer', 117958 , 'IT', 'Jacob Lauber',' 2011-02-06 ',' 2100-06-21 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E20848', 'Edward Eslser', '[email protected]',' 2006-07-26 ','Software Engineer', 83732 , 'IT', 'Jacob Lauber',' 2006-07-26 ',' 2100-06-22 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E23295', 'Lori Scatchard', '[email protected]',' 2004-05-08 ','Software Engineer', 118941 , 'IT', 'Jacob Lauber',' 2004-05-08 ',' 2100-06-23 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Masters Degree'),
('E23590', 'Dennis Wooten', '[email protected]',' 2013-04-06 ','Software Engineer', 101850 , 'IT', 'Jacob Lauber',' 2013-04-06 ',' 2100-06-24 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Masters Degree'),
('E35856', 'Beth Sepkowski', '[email protected]',' 2017-05-03 ','Software Engineer', 99864 , 'IT', 'Jacob Lauber',' 2017-05-03 ',' 2100-06-25 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Masters Degree'),
('E40432', 'April Briggs', '[email protected]',' 2010-01-30 ','Software Engineer', 130129 , 'IT', 'Jacob Lauber',' 2010-01-30 ',' 2100-06-26 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E64494', 'Patricia DuBois', '[email protected]',' 2007-05-11 ','Software Engineer', 140024 , 'IT', 'Jacob Lauber',' 2007-05-11 ',' 2100-06-27 ','South', '422 Broadway', 'Nashville', 'TN', 'Doctorate'),
('E64920', 'Mary Wesson', '[email protected]',' 2019-05-11 ','Software Engineer', 153717 , 'IT', 'Jacob Lauber',' 2019-05-11 ',' 2100-06-28 ','South', '422 Broadway', 'Nashville', 'TN', 'Doctorate'),
('E75344', 'Michael Kapper', '[email protected]',' 2009-03-20 ','Software Engineer', 135656 , 'IT', 'Jacob Lauber',' 2009-03-20 ',' 2100-06-29 ','South', '422 Broadway', 'Nashville', 'TN', 'Masters of Business Administration'),
('E82137', 'Arup Das', '[email protected]',' 2006-10-04 ','Software Engineer', 97040 , 'IT', 'Jacob Lauber',' 2006-10-04 ',' 2100-06-30 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters of Business Administration'),
('E84122', 'Congkhanh Nguyen', '[email protected]',' 2017-10-28 ','Software Engineer', 78751 , 'IT', 'Jacob Lauber',' 2017-10-28 ',' 2100-07-01 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Bachelors Degree'),
('E85640', 'Tara Madison', '[email protected]',' 2001-02-03 ','Software Engineer', 126529 , 'IT', 'Jacob Lauber',' 2001-02-03 ',' 2100-07-02 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Bachelors Degree'),
('E90439', 'Janice McQueen', '[email protected]',' 2000-07-23 ','Software Engineer', 92788 , 'IT', 'Jacob Lauber',' 2000-07-23 ',' 2100-07-03 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E90990', 'Tammy Tieman', '[email protected]',' 2014-11-16 ','Software Engineer', 118125 , 'IT', 'Jacob Lauber',' 2014-11-16 ',' 2100-07-04 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Masters Degree'),
('E94552', 'Geraldine Staler', '[email protected]',' 2013-10-31 ','Software Engineer', 153362 , 'IT', 'Jacob Lauber',' 2013-10-31 ',' 2100-07-05 ','South', '422 Broadway', 'Nashville', 'TN', 'Masters Degree'),
('E96966', 'Lu Huang', '[email protected]',' 2014-12-19 ','Software Engineer', 134250 , 'IT', 'Jacob Lauber',' 2014-12-19 ',' 2100-07-06 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E97018', 'Jamie Foskett', '[email protected]',' 2000-09-08 ','Software Engineer', 151379 , 'IT', 'Jacob Lauber',' 2000-09-08 ',' 2100-07-07 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E10033', 'Jermaine Massey', '[email protected]',' 2016-03-07 ','Software Engineer', 111681 , 'Product Development', 'Conner Kinch',' 2016-03-07 ',' 2100-07-08 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E12890', 'Robert Brown', '[email protected]',' 2010-06-06 ','Software Engineer', 136384 , 'Product Development', 'Conner Kinch',' 2010-06-06 ',' 2100-07-09 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters Degree'),
('E18659', 'Arnold Hanson', '[email protected]',' 2008-01-27 ','Software Engineer', 124699 , 'Product Development', 'Conner Kinch',' 2008-01-27 ',' 2100-07-10 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Masters Degree'),
('E21348', 'Nital Thaker', '[email protected]',' 2016-09-28 ','Software Engineer', 148313 , 'Product Development', 'Conner Kinch',' 2016-09-28 ',' 2100-07-11 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E25144', 'Chandi Bhandari', '[email protected]',' 2007-10-25 ','Software Engineer', 148005 , 'Product Development', 'Conner Kinch',' 2007-10-25 ',' 2100-07-12 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E26322', 'Raisa Paulson', '[email protected]',' 2010-10-20 ','Software Engineer', 136509 , 'Product Development', 'Conner Kinch',' 2010-10-20 ',' 2100-07-13 ','West Coast', '705 James Way', 'San Francisco', 'CA', 'Bachelors Degree'),
('E29652', 'Jennifer Westin', '[email protected]',' 2007-06-14 ','Software Engineer', 115791 , 'Product Development', 'Conner Kinch',' 2007-06-14 ',' 2100-07-14 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Masters Degree'),
('E38959', 'Ludovic Bocken', '[email protected]',' 2006-09-16 ','Software Engineer', 83327 , 'Product Development', 'Conner Kinch',' 2006-09-16 ',' 2100-07-15 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Masters Degree'),
('E62100', 'Victoria Pruitt', '[email protected]',' 2000-02-15 ','Software Engineer', 122810 , 'Product Development', 'Conner Kinch',' 2000-02-15 ',' 2100-07-16 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E63937', 'Rachael Anderson', '[email protected]',' 2014-07-15 ','Software Engineer', 84143 , 'Product Development', 'Conner Kinch',' 2014-07-15 ',' 2100-07-17 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Bachelors Degree'),
('E87822', 'Anil Padala', '[email protected]',' 2014-04-02 ','Software Engineer', 90884 , 'Product Development', 'Conner Kinch',' 2014-04-02 ',' 2100-07-18 ','East Coast', '165 Broadway', 'New York City', 'NY', 'Bachelors Degree'),
('E13160', 'Eric Baxter', 'Eric [email protected]',' 2008-10-06 ','Network Engineer', 76345 , 'Product Development', 'Conner Kinch',' 2004-07-06 ',' 2008-10-05 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Associates Degree'),
('E16678', 'Abby Lockhart', '[email protected]',' 2005-11-25 ','Network Engineer', 65778 , 'IT', 'Jacob Lauber',' 1999-02-16 ',' 2005-11-25 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E27498', 'Toni Lembeck', '[email protected]',' 2001-07-18 ','Network Engineer', 72341 , 'IT', 'Jacob Lauber',' 1995-03-12 ',' 2001-07-18 ','South', '422 Broadway', 'Nashville', 'TN', 'Bachelors Degree'),
('E15292', 'Melinda Fisher', '[email protected]',' 2011-02-06 ','Shipping and Receiving', 32933 , 'Distribution', 'Allison Gentle',' 2007-02-22 ',' 2011-02-06 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E20848', 'Edward Eslser', '[email protected]',' 2006-07-26 ','Shipping and Receiving', 41407 , 'Distribution', 'Allison Gentle',' 2002-04-16 ',' 2006-07-26 ','HQ', '1 Tech ABC Corp Way', 'Dallas', 'TX', 'Bachelors Degree'),
('E23295', 'Lori Scatchard', '[email protected]',' 2004-05-08 ','Sales Rep', 57887 , 'Sales', 'Jennifer De La Garza',' 2003-04-08 ',' 2004-05-08 ','Midwest', '1300 Nicollet Mall', 'Minnapolis', 'MN', 'Masters Degree');
create table Educational_Lvl(
education_lvl_id serial primary key,
level_nm varchar(50)
);
create table Address(
address_id serial primary key,
address_nm varchar(100),
location varchar(50),
city varchar(50),
state varchar(50)
);
create table Job(
job_id serial primary key,
job_title varchar(100)
);
create table Employee(
employee_id varchar(6) primary key,
employee_nm varchar(50),
email varchar(100),
address_id int references Address(address_id),
education_lvl_id int references Educational_Lvl(education_lvl_id),
hire_dt date
);
create table Department(
department_id serial primary key,
department_nm varchar(50)
);
Create table Employee_Contract(
contract_id serial primary key,
start_dt date,
end_dt date,
department_id int references Department(department_id),
employee_id varchar(6) references Employee(employee_id),
job_id int references Job(job_id),
manager_id varchar(6) references Employee(employee_id)
);
Create table Employee_Salary(
contract_id int references Employee_contract(contract_id),
salary decimal,
primary key (contract_id)
);
Insert into Educational_Lvl(level_nm)
select distinct(education_lvl) from proj_stg;
Insert into Address(address_nm,location,city,state)
select distinct(address),location,city,state from proj_stg;
Insert into Job(job_title)
select distinct(job_title) from proj_stg;
Insert into Department(department_nm)
select distinct(department_nm) from proj_stg;
Insert into Employee(employee_id,employee_nm,email,hire_dt,address_id,education_lvl_id)
select distinct(ps.Emp_ID),ps.Emp_NM,ps.Email,ps.hire_dt,ad.address_id,ed.education_lvl_id from proj_stg as ps
Join Address as ad
on ps.address=ad.address_nm
Join Educational_Lvl as ed
on ps.education_lvl=ed.level_nm;
Insert into Employee_Contract(start_dt, end_dt,department_id,employee_id,manager_id,job_id)
select distinct(ps.start_dt),ps.end_dt,dp.department_id,em.employee_id,e.employee_id,j.job_id from proj_stg as ps
Join Department as dp
on ps.department_nm=dp.department_nm
Join Employee as em
on ps.Emp_NM=em.employee_nm
Join Employee as e
on ps.manager=e.employee_nm
Join Job as j
on ps.job_title=j.job_title
;
Insert into Employee_Salary(salary,contract_id)
select distinct(ps.salary),ec.contract_id from proj_stg as ps
Join Employee_Contract as ec
on ps.start_dt=ec.start_dt
;
select em.employee_nm as employee_name,j.job_title,d.department_nm as department_name from employee_contract as ec
Join Employee as em
on ec.employee_id=em.employee_id
Join Job as j
on ec.job_id=j.job_id
Join Department as d
on ec.department_id=d.department_id;
Update Job
set job_title='Web developer'
where job_title='Web Programmer';
delete from Job
where job_title='Web developer';
select department_id,count(employee_id) from employee_contract group by department_id ;
select em.employee_nm,j.job_title,d.department_nm,
e.employee_nm as Manager_Name,ec.start_dt as Start_Date,
ec.end_dt as End_date from Employee_Contract as ec
Join Employee as em
on ec.employee_id=em.employee_id
Join Job as j
on ec.job_id=j.job_id
Join Department as d
on ec.department_id=d.department_id
Join Employee as e
on ec.manager_id=e.employee_id
where em.employee_nm='Toni Lembeck';
create view employee_info as
select ec.employee_id,em.employee_nm,em.email,em.hire_dt,
el.level_nm,es.salary,j.job_title,d.department_nm,
e.employee_nm as Manager_Name,ec.start_dt as Start_Date,
ec.end_dt as End_date,ad.address_nm,ad.location,ad.state,
ad.city from Employee_Contract as ec
Join Employee as em
on ec.employee_id=em.employee_id
Join Educational_Lvl as el
on el.education_lvl_id=em.education_lvl_id
Join Employee_Salary as es
on es.contract_id=ec.contract_id
Join Job as j
on ec.job_id=j.job_id
Join Department as d
on ec.department_id=d.department_id
Join Employee as e
on ec.manager_id=e.employee_id
Join Address as ad
on em.address_id=ad.address_id;
create or replace procedure history(
employee_name varchar(50)
)
language plpgsql
as $$
begin
select em.employee_nm,j.job_title,d.department_nm,
e.employee_nm as Manager_Name,ec.start_dt as Start_Date,
ec.end_dt as End_date from Employee_Contract as ec
Join Employee as em
on ec.employee_id=em.employee_id
Join Job as j
on ec.job_id=j.job_id
Join Department as d
on ec.department_id=d.department_id
Join Employee as e
on ec.manager_id=e.employee_id
where em.employee_nm=employee_name;
end;$$
call history('Toni Lembeck'); Write, Run & Share PostgreSQL queries online using OneCompiler's PostgreSQL online editor and compiler for free. It's one of the robust, feature-rich online editor and compiler for PostgreSQL. Getting started with the OneCompiler's PostgreSQL editor is really simple and pretty fast. The editor shows sample boilerplate code when you choose database as 'PostgreSQL' and start writing queries to learn and test online without worrying about tedious process of installation.
PostgreSQL is a open source relational database system and is also knows as Postgres.
CREATE command is used to create a table, schema or an index.
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
....);
ALTER command is used to add, modify or delete columns or constraints from the database table.
ALTER TABLE Table_name ADD column_name datatype;
TRUNCATE command is used to delete the data present in the table but this will not delete the table.
TRUNCATE table table_name;
DROP command is used to delete the table along with its data.
DROP TABLE table_name;
RENAME command is used to rename the table name.
ALTER TABLE table_name1 RENAME to new_table_name1;
INSERT Statement is used to insert new records into the database table.
INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
Select statement is used to select data from database tables.
SELECT column1, column2, ...
FROM table_name;
UPDATE statement is used to modify the existing values of records present in the database table.
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
DELETE statement is used to delete the existing records present in the database table.
DELETE FROM table_name where condition;