CREATE SCHEMA lec8;
CREATE TABLE lec8.employees (
  id TEXT,
  first_name TEXT,
  last_name TEXT,
  birthday DATE,
  reports_to TEXT
);
INSERT INTO lec8.employees VALUES
('1', 'Mary', 'Prince', '2012-04-03', '118'),
('2', 'Bonnie', 'Church', '1925-01-24', '103'),
('3', 'Erin', 'Long', '2008-11-25', '65'),
('4', 'Ryan', 'Spencer', '2024-02-28', '3'),
('5', 'Claudia', 'Ortiz', '2023-12-17', '3'),
('6', 'John', 'Sutton', '2007-06-28', '2'),
('7', 'John', 'Austin', '1931-02-27', '44'),
('8', 'Bradley', 'Jones', '2014-06-26', '92'),
('9', 'Lauren', 'Sutton', '2009-06-16', '133'),
('10', 'Katie', 'Allison', '1935-11-09', '28'),
('11', 'Courtney', 'Lee', '1956-12-19', '118'),
('12', 'Angela', 'Andrews', '1961-12-23', '103'),
('13', 'David', 'Walsh', '2016-08-23', '67'),
('14', 'Anne', 'Brown', '1928-04-26', '38'),
('15', 'Amanda', 'Wagner', '1989-07-04', '146'),
('16', 'Pamela', 'Chandler', '1909-01-18', '10'),
('17', 'Claudia', 'Santana', '1947-06-02', '94'),
('18', 'Julia', 'Montoya', '1932-06-17', '195'),
('19', 'Adam', 'Wood', '1924-07-26', '85'),
('20', 'Robin', 'Mitchell', '1918-01-24', '85'),
('21', 'Marie', 'Scott', '1943-04-15', '146'),
('22', 'Jonathan', 'Meyer', '2017-02-19', '101'),
('23', 'Amy', 'Knight', '1940-03-11', '37'),
('24', 'Michael', 'Deleon', '1950-10-07', '131'),
('25', 'Amanda', 'Lee', '1999-07-24', '95'),
('26', 'Matthew', 'Russell', '1935-11-06', '2'),
('27', 'Bradley', 'Stevens', '1939-10-27', '23'),
('28', 'Michelle', 'Patel', '1987-10-24', '144'),
('29', 'Rachel', 'Griffin', '1971-07-10', '158'),
('30', 'Michael', 'Marks', '1991-07-21', '96'),
('31', 'Robin', 'Dunn', '1970-03-07', '133'),
('32', 'Margaret', 'James', '2023-11-05', '106'),
('33', 'William', 'Carroll', '1967-05-25', '127'),
('34', 'Matthew', 'Schroeder', '1917-04-01', '171'),
('35', 'Kenneth', 'Wong', '2021-01-06', '135'),
('36', 'Timothy', 'Webster', '1927-06-06', '171'),
('37', 'Laura', 'May', '1950-05-25', '105'),
('38', 'Jennifer', 'Brown', '1938-12-26', '39'),
('39', 'Jennifer', 'Miller', '2021-03-18', '63'),
('40', 'Morgan', 'Lopez', '1940-11-01', '10'),
('41', 'Michelle', 'King', '1959-05-04', '135'),
('42', 'Taylor', 'Wright', '1981-04-04', '103'),
('43', 'Teresa', 'York', '1954-02-19', '75'),
('44', 'Kenneth', 'Wise', '1912-10-17', '101'),
('45', 'Rachel', 'Ayala', '1915-10-13', '92'),
('46', 'Amber', 'Anderson', '1967-10-13', '170'),
('47', 'Martha', 'White', '2007-10-15', '127'),
('48', 'Cheryl', 'Thomas', '1970-04-27', '149'),
('49', 'Stephanie', 'Holden', '1981-08-26', '95'),
('50', 'Jessica', 'Lawrence', '1957-09-08', '96'),
('51', 'Beth', 'Riley', '1967-09-05', '91'),
('52', 'Anthony', 'Snyder', '1975-03-26', '23'),
('53', 'Bianca', 'Mcdonald', '1978-11-16', '38'),
('54', 'Christina', 'Cox', '1928-07-20', '85'),
('55', 'Garrett', 'Duncan', '2004-07-11', '115'),
('56', 'Samantha', 'Fitzpatrick', '1968-06-16', '177'),
('57', 'Ariel', 'Ingram', '1971-03-08', '109'),
('58', 'James', 'Ayala', '1925-07-19', '177'),
('59', 'Meghan', 'Hess', '1939-07-21', '109'),
('60', 'Elizabeth', 'Gonzalez', '1972-07-15', '91'),
('61', 'Robert', 'Hayes', '1970-06-13', '133'),
('62', 'Jason', 'Collins', '1908-12-29', '178'),
('63', 'Christopher', 'Henry', '1929-06-20', '133'),
('64', 'Jennifer', 'Watkins', '1972-06-29', '109'),
('65', 'Evelyn', 'Crosby', '1994-04-09', '67'),
('66', 'Michael', 'Baker', '1971-10-12', '28'),
('67', 'Samantha', 'Mendoza', '1969-06-26', '134'),
('68', 'Chad', 'Jenkins', '1959-01-18', '177'),
('69', 'Dennis', 'Pacheco', '2007-03-26', '105'),
('70', 'Deborah', 'Sanchez', '1957-12-05', '75'),
('71', 'Heather', 'West', '2017-11-02', '144'),
('72', 'Jessica', 'Coleman', '1946-01-15', '120'),
('73', 'Andrew', 'Watson', '2005-11-22', '94'),
('74', 'Jay', 'Esparza', '2010-11-11', '178'),
('75', 'Cathy', 'Nelson', '1955-07-19', '60'),
('76', 'Dana', 'Smith', '1971-08-08', '91'),
('77', 'Kaylee', 'Waller', '1981-07-21', '65'),
('78', 'Caitlyn', 'Santiago', '1956-12-01', '127'),
('79', 'Jason', 'Johnson', '1984-01-01', '92'),
('80', 'Tamara', 'Dixon', '1935-08-16', '34'),
('81', 'Dominic', 'Martinez', '1916-11-19', '75'),
('82', 'James', 'Sosa', '1909-04-14', '175'),
('83', 'Bradley', 'Flores', '1989-03-12', '62'),
('84', 'Danielle', 'Thomas', '1932-09-29', '102'),
('85', 'Michael', 'Lambert', '2004-09-12', '96'),
('86', 'Nathan', 'Rodriguez', '1982-11-06', '54'),
('87', 'Ashley', 'Cohen', '2020-12-21', '118'),
('88', 'Jamie', 'Donaldson', '2011-12-13', '10'),
('89', 'Jessica', 'Barnes', '2013-01-26', '62'),
('90', 'Zachary', 'Rogers', '1913-09-06', '135'),
('91', 'Cameron', 'Cannon', '2023-07-21', '193'),
('92', 'Tyler', 'Hernandez', '1927-11-08', '169'),
('93', 'Tammy', 'King', '1977-08-24', '193'),
('94', 'Rita', 'Johnston', '1975-07-11', '10'),
('95', 'Andrea', 'Coleman', '1950-05-26', '3'),
('96', 'Carolyn', 'Jacobs', '1927-09-14', 'None'),
('97', 'Robert', 'Acosta', '1966-02-17', '63'),
('98', 'Elizabeth', 'Hubbard', '2020-08-09', '146'),
('99', 'John', 'Mccall', '1991-11-19', '115'),
('100', 'Christine', 'Hughes', '1920-12-31', '95'),
('101', 'Justin', 'Robertson', '1939-11-04', '135'),
('102', 'Mary', 'Garcia', '1985-10-05', '100'),
('103', 'Brandon', 'Hill', '1921-05-01', '120'),
('104', 'Ryan', 'Carter', '1915-09-08', '34'),
('105', 'Jerome', 'Deleon', '1916-08-18', '175'),
('106', 'Chris', 'Hayes', '2024-08-11', '54'),
('107', 'Collin', 'Mcdonald', '1990-07-04', '101'),
('108', 'Jeffrey', 'Morrison', '2004-03-12', '85'),
('109', 'Alyssa', 'Lopez', '2008-05-03', '177'),
('110', 'Jennifer', 'Serrano', '1964-11-20', '65'),
('111', 'Bobby', 'Rice', '1930-11-08', '37'),
('112', 'Anthony', 'Riley', '1923-05-30', '37'),
('113', 'Wayne', 'Taylor', '1954-12-10', '103'),
('114', 'Rachel', 'Clark', '2006-01-29', '96'),
('115', 'Annette', 'Hancock', '1976-12-11', '131'),
('116', 'Brian', 'Houston', '1916-10-02', '146'),
('117', 'Jeanette', 'Johnson', '1963-12-26', '3'),
('118', 'Kristen', 'Baird', '2000-02-15', '158'),
('119', 'Tara', 'Stone', '1963-01-12', '100'),
('120', 'Jeffrey', 'Gonzalez', '2014-01-02', '94'),
('121', 'Andrew', 'Sanchez', '1986-08-15', '54'),
('122', 'Sheila', 'Foster', '1978-11-17', '149'),
('123', 'Carol', 'Grant', '1964-12-05', '37'),
('124', 'Carl', 'Grimes', '1994-12-07', '10'),
('125', 'Ryan', 'Gonzalez', '1983-07-21', '28'),
('126', 'Alan', 'Thomas', '1909-01-09', '63'),
('127', 'Scott', 'Johnson', '2023-01-09', '149'),
('128', 'Brianna', 'Fleming', '1940-03-09', '79'),
('129', 'Madeline', 'Johnson', '1993-04-02', '64'),
('130', 'Jonathan', 'Jones', '1941-05-15', '95'),
('131', 'Alexander', 'Higgins', '1964-12-10', '2'),
('132', 'James', 'Velazquez', '1938-10-01', '178'),
('133', 'Michael', 'Holland', '1947-04-01', '145'),
('134', 'Frank', 'Ritter', '2016-04-13', '23'),
('135', 'Thomas', 'Schmidt', '1934-02-26', '115'),
('136', 'Anna', 'Johnson', '2001-11-09', '62'),
('137', 'Marie', 'Nunez', '1993-09-22', '92'),
('138', 'Timothy', 'Zavala', '1973-04-24', '169'),
('139', 'Corey', 'Guzman', '1968-06-25', '193'),
('140', 'Brianna', 'Reynolds', '1936-02-15', '38'),
('141', 'Vincent', 'Blair', '1946-09-13', '60'),
('142', 'Bobby', 'Krueger', '1980-08-04', '39'),
('143', 'Anna', 'Hansen', '1930-02-01', '131'),
('144', 'Danny', 'Rodriguez', '1931-01-17', '127'),
('145', 'Thomas', 'Boyle', '1914-04-27', '79'),
('146', 'Kayla', 'Watson', '1914-08-05', '7'),
('147', 'Matthew', 'Ruiz', '1927-10-12', '62'),
('148', 'Olivia', 'White', '1955-12-13', '64'),
('149', 'Melissa', 'Moore', '1988-07-28', '34'),
('150', 'Beth', 'Johnson', '1951-08-15', '178'),
('151', 'Debra', 'Holden', '1939-01-28', '158'),
('152', 'Scott', 'Smith', '2019-06-19', '169'),
('153', 'Cody', 'Henderson', '1944-07-26', '193'),
('154', 'Michael', 'Green', '1914-05-09', '60'),
('155', 'Nancy', 'Haley', '1914-01-19', '102'),
('156', 'Leslie', 'King', '1923-06-01', '115'),
('157', 'Jeffrey', 'Burke', '2001-03-18', '106'),
('158', 'Maria', 'Mccullough', '1925-06-21', '146'),
('159', 'Timothy', 'Herring', '1941-06-07', '94'),
('160', 'Dawn', 'Anderson', '1991-08-17', '7'),
('161', 'Jeremy', 'Howell', '2012-02-24', '131'),
('162', 'Richard', 'Baxter', '1966-09-26', '94'),
('163', 'Jennifer', 'Grant', '1964-01-13', '134'),
('164', 'Jason', 'Salinas', '2024-01-24', '101'),
('165', 'Chelsea', 'Wood', '1942-09-20', '145'),
('166', 'Joseph', 'Myers', '1918-09-19', '39'),
('167', 'Kathleen', 'Sloan', '1978-08-21', '37'),
('168', 'Karen', 'Gould', '2024-07-04', '67'),
('169', 'Lindsay', 'Mcdonald', '1955-08-30', '170'),
('170', 'Vanessa', 'Hoover', '2011-05-13', '62'),
('171', 'Gregory', 'Wood', '1985-01-23', '64'),
('172', 'Ryan', 'Morris', '2020-11-18', '67'),
('173', 'Elizabeth', 'Palmer', '2009-09-02', '131'),
('174', 'Elizabeth', 'Turner', '1978-08-28', '193'),
('175', 'Gregory', 'Arnold', '1915-09-10', '118'),
('176', 'Kimberly', 'Carter', '1919-08-28', '64'),
('177', 'David', 'Hanna', '1925-07-17', '38'),
('178', 'Larry', 'Estrada', '1929-03-25', '195'),
('179', 'Elizabeth', 'Scott', '1973-08-17', '109'),
('180', 'Stephanie', 'Nichols', '1995-12-21', '103'),
('181', 'Jessica', 'Day', '1999-11-09', '115'),
('182', 'William', 'Shaffer', '1975-06-07', '85'),
('183', 'Justin', 'Wallace', '2002-07-18', '44'),
('184', 'Cody', 'Salazar', '1911-10-07', '169'),
('185', 'Justin', 'Meyers', '1981-12-05', '96'),
('186', 'Cynthia', 'Foster', '2008-03-31', '133'),
('187', 'Jennifer', 'Thompson', '1969-09-17', '149'),
('188', 'Taylor', 'Smith', '1934-05-22', '79'),
('189', 'Damon', 'Green', '2012-07-01', '7'),
('190', 'Brittany', 'Dunn', '1964-05-10', '60'),
('191', 'Caitlyn', 'Benson', '1914-02-08', '134'),
('192', 'Todd', 'Moore', '1947-10-03', '178'),
('193', 'Steve', 'Willis', '2005-07-11', '106'),
('194', 'Christopher', 'Smith', '2018-04-29', '28'),
('195', 'Martha', 'Lewis', '2003-05-04', '75'),
('196', 'Stephanie', 'Mcgee', '1946-12-02', '23'),
('197', 'Kristina', 'Villarreal', '1979-11-26', '135'),
('198', 'Brian', 'Wells', '1984-02-09', '64'),
('199', 'Charles', 'Alexander', '1975-12-31', '175'),
('200', 'Jason', 'Banks', '1908-12-08', '177')
;
