1. Ustawienia ⚙️ - ritaly/wprowadzenie-do-sql GitHub Wiki

Na start potrzebujesz narzędzia online, które zastąpi nam lokalne środowisko, oszczędzi czas, który konieczny byłby na instalowanie i ustawianie bazy lokalnie. Na potrzeby warsztatów skorzystamy ze strony 👉 www.db-fiddle.com

1. W lewym górny rogu wybierz PostgreSQL np. v11

2. Stwórzmy dane początkowe - schemat bazy wypełniony przykładowymi danymi. W pole Schema SQL wklej poniższy kod, a następnie go uruchom poleceniem Run na górnym pasku menu

CREATE TABLE department (
  department_id INT,
  department_name VARCHAR(100),
  CONSTRAINT pk_dept PRIMARY KEY (department_id)
);


CREATE TABLE employee (
  employee_id INT,
  first_name VARCHAR(100),
  last_name VARCHAR(100),
  salary INT,
  department_id INT,
  manager_id INT,
  hire_date TIMESTAMP(0),
  CONSTRAINT pk_emp PRIMARY KEY (employee_id),
  CONSTRAINT fk_emp_dept FOREIGN KEY (department_id) REFERENCES department(department_id)
);


CREATE TABLE product (
  product_id INT,
  product_name VARCHAR(100),
  price DECIMAL(10, 2),
  department_id INT,
  CONSTRAINT pk_prod PRIMARY KEY (product_id),
  CONSTRAINT fk_prod_dept FOREIGN KEY (department_id) REFERENCES department(department_id)
);

CREATE TABLE customer (
  customer_id INT,
  first_name VARCHAR(100),
  last_name VARCHAR(100),
  address_state VARCHAR(10),
  email_address VARCHAR(350),
  CONSTRAINT pk_cust PRIMARY KEY (customer_id)
);

CREATE TABLE customer_order (
  order_id INT,
  customer_id INT,
  product_id INT,
  order_date TIMESTAMP(0),
  CONSTRAINT pk_order PRIMARY KEY (order_id),
  CONSTRAINT fk_order_cust FOREIGN KEY (customer_id) REFERENCES customer(customer_id),
  CONSTRAINT fk_order_prod FOREIGN KEY (product_id) REFERENCES product(product_id)
);


/*
Przykladowe dane
*/

--Department
INSERT INTO department (department_id, department_name) VALUES (1, 'Executive');
INSERT INTO department (department_id, department_name) VALUES (2, 'Sales');
INSERT INTO department (department_id, department_name) VALUES (3, 'Customer Support');
INSERT INTO department (department_id, department_name) VALUES (4, 'Hardware Development');
INSERT INTO department (department_id, department_name) VALUES (5, 'Software Development');
INSERT INTO department (department_id, department_name) VALUES (6, 'Marketing');
INSERT INTO department (department_id, department_name) VALUES (7, 'Finance');
INSERT INTO department (department_id, department_name) VALUES (8, 'Legal');
INSERT INTO department (department_id, department_name) VALUES (9, 'Maintenance');



--Employee
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (1, 'Michelle', 'Foster', 48000, 8, 162, TO_DATE('27-AUG-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (2, 'Cheryl', 'Turner', 79000, 3, 99, TO_DATE('2-JAN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (3, 'Carolyn', 'Hudson', 47000, 7, 199, TO_DATE('4-DEC-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (4, 'Patrick', 'Berry', 51000, 3, 159, TO_DATE('12-OCT-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (5, 'Doris', 'Powell', 117000, 1, NULL, TO_DATE('15-NOV-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (6, 'Jessica', 'Elliott', 21000, 7, 70, TO_DATE('2-JUL-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (7, 'Sean', 'Burns', 51000, 6, 37, TO_DATE('3-OCT-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (8, 'Ann', 'Bowman', 34000, 7, 187, TO_DATE('20-MAY-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (9, 'Kathleen', 'Jones', 92000, 7, 131, TO_DATE('15-MAR-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (10, 'Scott', 'Cruz', 32000, 8, 170, TO_DATE('3-JUL-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (11, 'Norma', 'Henry', 56000, 3, 8, TO_DATE('24-JUL-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (12, 'Evelyn', 'Gonzalez', 118000, 5, 177, TO_DATE('13-JUL-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (13, 'Stephen', 'Hudson', 63000, 4, 133, TO_DATE('22-DEC-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (14, 'Bruce', 'Mitchell', 71000, 5, 175, TO_DATE('17-AUG-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (15, 'Nicholas', 'Dixon', 24000, 5, 113, TO_DATE('9-FEB-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (16, 'Fred', 'Nichols', 70000, 3, 186, TO_DATE('7-APR-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (17, 'Barbara', 'Morales', 65000, 6, 85, TO_DATE('1-JUL-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (18, 'Ralph', 'Anderson', 34000, 4, 73, TO_DATE('21-JUL-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (19, 'Lois', 'Butler', 81000, 6, 140, TO_DATE('2-NOV-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (20, 'Johnny', 'Adams', 103000, 6, 170, TO_DATE('20-OCT-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (21, 'George', 'Burton', 43000, 4, 67, TO_DATE('14-MAR-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (22, 'Dorothy', 'Cook', 21000, 5, 95, TO_DATE('3-JAN-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (23, 'Teresa', 'Bell', 56000, 6, 200, TO_DATE('29-MAR-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (24, 'Anthony', 'Rice', NULL, 4, 155, TO_DATE('3-JAN-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (25, 'Joseph', 'Berry', 87000, 8, 142, TO_DATE('7-JAN-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (26, 'Alice', 'Perry', 106000, 1, 5, TO_DATE('28-SEP-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (27, 'Ralph', 'Montgomery', 49000, 3, 14, TO_DATE('5-DEC-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (28, 'Roy', 'Lane', 40000, 3, 95, TO_DATE('13-NOV-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (29, 'Kenneth', 'Bennett', 82000, 3, 169, TO_DATE('28-APR-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (30, 'Theresa', 'Lawson', 32000, 7, 170, TO_DATE('6-JAN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (31, 'Jesse', 'Hanson', 92000, 2, 82, TO_DATE('24-NOV-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (32, 'Diana', 'Armstrong', 37000, 8, 145, TO_DATE('27-NOV-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (33, 'Donna', 'Martinez', 51000, 2, 108, TO_DATE('23-MAY-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (34, 'Phyllis', 'Larson', 29000, 4, 23, TO_DATE('30-NOV-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (35, 'Robert', 'Gilbert', 102000, 3, 38, TO_DATE('18-DEC-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (36, 'Teresa', 'Graham', 61000, 6, 8, TO_DATE('14-OCT-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (37, 'Jessica', 'Sullivan', 21000, 2, 61, TO_DATE('2-SEP-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (38, 'David', 'Bailey', 102000, 8, 106, TO_DATE('30-APR-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (39, 'Fred', 'Wallace', 37000, 6, 117, TO_DATE('16-APR-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (40, 'Jason', 'Alvarez', 32000, 8, 149, TO_DATE('19-FEB-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (41, 'Angela', 'Lewis', 65000, 2, 8, TO_DATE('27-JUL-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (42, 'Justin', 'Nelson', 50000, 8, 145, TO_DATE('9-APR-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (43, 'Clarence', 'George', 85000, 5, 105, TO_DATE('10-MAR-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (44, 'Philip', 'Jordan', 43000, 7, 67, TO_DATE('21-AUG-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (45, 'Lori', 'Jacobs', 69000, 2, 114, TO_DATE('15-MAR-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (46, 'Jeremy', 'Porter', 99000, 6, 15, TO_DATE('19-JUN-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (47, 'Jessica', 'Bennett', 83000, 4, 145, TO_DATE('4-NOV-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (48, 'Ruth', 'Price', 27000, 8, 160, TO_DATE('4-MAY-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (49, 'Melissa', 'Cunningham', 67000, 2, 82, TO_DATE('3-JUN-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (50, 'Henry', 'Kennedy', 78000, 4, 60, TO_DATE('25-APR-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (51, 'Martha', 'Cruz', 52000, 7, 85, TO_DATE('4-NOV-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (52, 'Lori', 'Rogers', 27000, 7, 37, TO_DATE('13-AUG-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (53, 'Cynthia', 'Medina', 118000, 2, 114, TO_DATE('16-JUN-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (54, 'Russell', 'Payne', 104000, 2, 127, TO_DATE('18-DEC-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (55, 'Sarah', 'Richardson', 80000, 8, 23, TO_DATE('2-DEC-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (56, 'Susan', 'Henderson', 31000, 4, 46, TO_DATE('20-DEC-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (57, 'Diana', 'Spencer', 83000, 3, 45, TO_DATE('9-MAR-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (58, 'Louise', 'Bryant', 48000, 5, 54, TO_DATE('11-APR-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (59, 'Christine', 'Brooks', 40000, 6, 57, TO_DATE('6-JUN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (60, 'Ruby', 'Shaw', 25000, 4, 74, TO_DATE('7-MAY-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (61, 'Karen', 'Williams', 87000, 3, 70, TO_DATE('25-JAN-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (62, 'Brandon', 'Campbell', 47000, 5, 115, TO_DATE('29-MAR-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (63, 'Antonio', 'Andrews', 55000, 8, 134, TO_DATE('20-MAY-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (64, 'Gloria', 'Greene', 81000, 4, 132, TO_DATE('20-MAY-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (65, 'Melissa', 'Stevens', 80000, 4, 105, TO_DATE('23-DEC-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (66, 'Evelyn', 'Bailey', 78000, 3, 25, TO_DATE('31-JUL-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (67, 'Clarence', 'Welch', 41000, 3, 173, TO_DATE('30-OCT-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (68, 'Doris', 'Graham', 82000, 1, 5, TO_DATE('3-MAY-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (69, 'Cynthia', 'Howell', 102000, 4, 68, TO_DATE('17-JUL-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (70, 'Susan', 'Harris', 78000, 2, 159, TO_DATE('4-APR-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (71, 'Pamela', 'Allen', 87000, 6, 19, TO_DATE('27-NOV-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (72, 'Victor', 'Oliver', 36000, 5, 129, TO_DATE('4-JAN-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (73, 'Jennifer', 'Fisher', NULL, 8, 171, TO_DATE('14-FEB-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (74, 'Larry', 'Lawrence', 67000, 7, 101, TO_DATE('27-NOV-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (75, 'Janice', 'Morrison', 66000, 4, 12, TO_DATE('15-APR-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (76, 'Billy', 'Shaw', 42000, 5, 69, TO_DATE('14-OCT-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (77, 'David', 'Thompson', 112000, 8, 151, TO_DATE('7-APR-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (78, 'Cheryl', 'Castillo', 42000, 8, 161, TO_DATE('12-APR-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (79, 'Sean', 'Ramirez', 67000, 2, 8, TO_DATE('21-OCT-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (80, 'Joseph', 'Davis', 30000, 8, 182, TO_DATE('12-OCT-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (81, 'Joyce', 'Diaz', 113000, 2, 111, TO_DATE('3-NOV-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (82, 'Ann', 'Hill', 91000, 5, 157, TO_DATE('8-JUN-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (83, 'Harold', 'Spencer', 104000, 5, 42, TO_DATE('19-NOV-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (84, 'Jennifer', 'Long', 36000, NULL, 4, TO_DATE('25-NOV-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (85, 'Johnny', 'Reed', 22000, 7, 60, TO_DATE('12-JUN-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (86, 'Randy', 'Riley', 85000, 6, 196, TO_DATE('2-MAY-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (87, 'Nancy', 'Fuller', 26000, 6, 7, TO_DATE('29-JUN-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (88, 'Barbara', 'Reynolds', 67000, 6, 102, TO_DATE('27-JUN-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (89, 'Irene', 'Cox', 108000, 7, 68, TO_DATE('24-JAN-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (90, 'Earl', 'Grant', 68000, 2, 157, TO_DATE('6-NOV-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (91, 'Christopher', 'Collins', 77000, 8, 16, TO_DATE('8-JUN-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (92, 'Ruby', 'Clark', 35000, 2, 114, TO_DATE('26-OCT-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (93, 'Evelyn', 'Campbell', 88000, 5, 129, TO_DATE('6-FEB-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (94, 'Lisa', 'Williams', 101000, 5, 111, TO_DATE('17-JUN-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (95, 'Stephanie', 'Williams', 26000, 3, 44, TO_DATE('31-JAN-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (96, 'Craig', 'Lewis', 43000, 7, 174, TO_DATE('30-JUL-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (97, 'Justin', 'Little', 112000, 2, 181, TO_DATE('4-JUN-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (98, 'James', 'Rodriguez', 70000, 6, 18, TO_DATE('28-FEB-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (99, 'Mark', 'Jackson', 68000, 6, 57, TO_DATE('5-FEB-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (100, 'Robert', 'Hicks', 111000, 8, 182, TO_DATE('1-AUG-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (101, 'Earl', 'Butler', 55000, 8, 68, TO_DATE('2-MAY-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (102, 'Ralph', 'Woods', 22000, 4, 10, TO_DATE('5-FEB-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (103, 'Larry', 'Parker', 78000, 6, 137, TO_DATE('22-NOV-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (104, 'Debra', 'Roberts', 83000, 2, 93, TO_DATE('1-JUL-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (105, 'Tammy', 'Peterson', 45000, 2, 131, TO_DATE('18-APR-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (106, 'Bruce', 'Larson', 73000, 8, 181, TO_DATE('6-AUG-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (107, 'Shawn', 'Hunt', 105000, 3, 67, TO_DATE('3-SEP-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (108, 'Frank', 'Jones', 74000, 7, 93, TO_DATE('15-MAR-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (109, 'Paula', 'Dunn', 69000, 7, 175, TO_DATE('26-JAN-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (110, 'Janet', 'Watson', 90000, 7, 172, TO_DATE('8-DEC-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (111, 'Kenneth', 'Little', 29000, 8, 162, TO_DATE('12-JUN-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (112, 'Helen', 'Snyder', 63000, 3, 124, TO_DATE('18-JAN-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (113, 'Carolyn', 'Perkins', 99000, 2, 124, TO_DATE('13-MAR-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (114, 'James', 'Phillips', 87000, NULL, 88, TO_DATE('28-DEC-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (115, 'Clarence', 'Thomas', 25000, 3, 126, TO_DATE('1-JUN-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (116, 'John', 'Diaz', 75000, 2, 130, TO_DATE('25-MAY-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (117, 'Anna', 'Green', 61000, 3, 140, TO_DATE('2-FEB-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (118, 'Billy', 'Wagner', 46000, 3, 160, TO_DATE('12-SEP-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (119, 'Paula', 'Lynch', 73000, 5, 39, TO_DATE('27-NOV-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (120, 'Antonio', 'Banks', 77000, 6, 115, TO_DATE('26-JUN-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (121, 'Helen', 'Garza', 79000, 3, 120, TO_DATE('5-JUN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (122, 'Dorothy', 'Duncan', 45000, 4, 100, TO_DATE('6-JUN-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (123, 'Louis', 'Elliott', 33000, 3, 51, TO_DATE('29-OCT-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (124, 'Andrea', 'Watson', 46000, 7, 26, TO_DATE('9-SEP-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (125, 'Mark', 'Rogers', 111000, 5, 72, TO_DATE('30-JUN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (126, 'Christopher', 'Lawrence', 69000, 3, 187, TO_DATE('2-MAY-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (127, 'Todd', 'Larson', 106000, 2, 141, TO_DATE('28-APR-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (128, 'Janice', 'Vasquez', 82000, 3, 102, TO_DATE('4-SEP-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (129, 'Kelly', 'Gonzalez', 40000, 5, 111, TO_DATE('21-APR-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (130, 'Pamela', 'Medina', 107000, 5, 158, TO_DATE('22-JAN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (131, 'Roy', 'Oliver', 63000, 7, 134, TO_DATE('9-MAR-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (132, 'Sandra', 'Mason', 112000, 5, 177, TO_DATE('28-MAR-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (133, 'Pamela', 'Collins', 113000, 5, 199, TO_DATE('29-OCT-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (134, 'Gary', 'Greene', 100000, 3, 25, TO_DATE('3-JAN-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (135, 'Deborah', 'Harrison', 77000, 7, 180, TO_DATE('24-JUL-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (136, 'Andrew', 'Mccoy', 113000, 6, 54, TO_DATE('20-APR-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (137, 'Henry', 'Perez', 52000, 3, 38, TO_DATE('4-DEC-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (138, 'Matthew', 'Foster', 36000, 6, 19, TO_DATE('21-JAN-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (139, 'Kevin', 'Howell', 102000, 5, 121, TO_DATE('25-JAN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (140, 'Rebecca', 'Chapman', 89000, NULL, 195, TO_DATE('9-JAN-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (141, 'Lawrence', 'Garrett', 89000, 7, 142, TO_DATE('12-APR-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (142, 'Emily', 'Perry', 77000, 4, 194, TO_DATE('23-DEC-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (143, 'Earl', 'Simmons', 86000, 4, 32, TO_DATE('5-JUL-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (144, 'Shawn', 'Dixon', 120000, 8, 174, TO_DATE('6-JUL-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (145, 'Todd', 'Hawkins', 101000, 2, 60, TO_DATE('8-OCT-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (146, 'Marilyn', 'Russell', 27000, 5, 124, TO_DATE('25-DEC-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (147, 'Gregory', 'Bell', 68000, 3, 107, TO_DATE('11-MAR-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (148, 'Diana', 'Romero', 26000, 4, 62, TO_DATE('24-JAN-2017','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (149, 'Randy', 'Mitchell', 78000, 4, 183, TO_DATE('3-JUL-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (150, 'Heather', 'Diaz', 63000, 5, 192, TO_DATE('3-AUG-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (151, 'Kathleen', 'Arnold', 118000, 3, 85, TO_DATE('15-AUG-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (152, 'Tina', 'Sims', 32000, 4, 8, TO_DATE('15-OCT-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (153, 'Sara', 'Grant', 100000, 5, 140, TO_DATE('30-NOV-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (154, 'Brandon', 'Baker', 53000, 7, 66, TO_DATE('23-JUN-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (155, 'Timothy', 'Morgan', 118000, 2, 197, TO_DATE('31-JUL-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (156, 'Jack', 'Franklin', 78000, 5, 25, TO_DATE('15-JAN-2017','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (157, 'Carlos', 'Russell', 34000, 2, 3, TO_DATE('15-JUL-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (158, 'Donna', 'Andrews', 99000, 5, 185, TO_DATE('11-MAY-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (159, 'Gary', 'Knight', 81000, 5, 16, TO_DATE('12-SEP-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (160, 'Lawrence', 'Collins', 103000, 3, 61, TO_DATE('16-NOV-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (161, 'Randy', 'Ward', 77000, 2, 119, TO_DATE('16-JAN-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (162, 'Kimberly', 'Mendoza', 27000, 3, 191, TO_DATE('26-JUN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (163, 'Jacqueline', 'Peters', 27000, 4, 10, TO_DATE('17-MAY-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (164, 'Betty', 'Gutierrez', 23000, 8, 148, TO_DATE('2-NOV-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (165, 'Fred', 'Webb', 71000, 2, 152, TO_DATE('27-DEC-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (166, 'Wanda', 'Garza', 95000, 6, 11, TO_DATE('24-NOV-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (167, 'Norma', 'Wagner', 87000, 6, 84, TO_DATE('18-MAR-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (168, 'Amy', 'Wheeler', 31000, 7, 35, TO_DATE('28-JUL-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (169, 'Todd', 'Patterson', 72000, 8, 56, TO_DATE('15-JUN-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (170, 'Barbara', 'Stone', 108000, 3, 174, TO_DATE('29-JUN-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (171, 'Carolyn', 'Owens', 68000, 8, 27, TO_DATE('6-DEC-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (172, 'Ann', 'Romero', 71000, 7, 31, TO_DATE('21-JUN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (173, 'John', 'Hayes', 85000, 8, 18, TO_DATE('23-MAR-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (174, 'Judith', 'Richardson', 80000, 2, 57, TO_DATE('2-JAN-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (175, 'Shawn', 'Sanders', 27000, 7, 68, TO_DATE('20-MAR-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (176, 'Margaret', 'Wagner', 85000, 4, 64, TO_DATE('19-JUL-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (177, 'Craig', 'Diaz', 114000, 5, 194, TO_DATE('24-DEC-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (178, 'Justin', 'Fowler', 53000, 2, 191, TO_DATE('25-JUL-2013','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (179, 'Christina', 'Berry', 94000, 2, 181, TO_DATE('9-MAY-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (180, 'Daniel', 'Stevens', 50000, 4, 34, TO_DATE('15-MAY-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (181, 'Marie', 'Hanson', 84000, 5, 56, TO_DATE('4-JAN-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (182, 'Bobby', 'Gonzalez', 71000, 6, 72, TO_DATE('21-OCT-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (183, 'Nicole', 'Robinson', 66000, 3, 110, TO_DATE('7-JAN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (184, 'Jerry', 'Ward', 33000, 7, 69, TO_DATE('30-JAN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (185, 'Kathy', 'Sanders', 114000, 7, 181, TO_DATE('26-FEB-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (186, 'Pamela', 'Henderson', 120000, 3, 87, TO_DATE('18-AUG-2016','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (187, 'Chris', 'Boyd', 23000, 8, 37, TO_DATE('16-JUL-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (188, 'Barbara', 'Green', 46000, 2, 153, TO_DATE('26-JUL-2014','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (189, 'Adam', 'Stephens', 99000, 7, 82, TO_DATE('23-JUL-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (190, 'Anne', 'King', 120000, 5, 28, TO_DATE('12-FEB-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (191, 'Randy', 'Spencer', 80000, 5, 193, TO_DATE('6-JAN-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (192, 'Wanda', 'Stewart', 28000, 7, 184, TO_DATE('27-MAY-2011','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (193, 'Ashley', 'Cox', 41000, 5, 137, TO_DATE('7-OCT-2010','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (194, 'Carl', 'Baker', 64000, 6, 149, TO_DATE('28-JUL-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (195, 'Tina', 'Arnold', 77000, 6, 41, TO_DATE('26-JAN-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (196, 'Julia', 'Rogers', 35000, 7, 18, TO_DATE('19-DEC-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (197, 'Larry', 'Knight', 90000, 8, 48, TO_DATE('26-JUN-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (198, 'Ashley', 'Griffin', 64000, 3, 40, TO_DATE('15-JAN-2015','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (199, 'Lawrence', 'Henderson', 39000, 6, 47, TO_DATE('9-MAY-2012','DD-MON-YYYY'));
INSERT INTO employee (employee_id, first_name, last_name, salary, department_id, manager_id, hire_date) VALUES (200, 'Charles', 'Stone', 70000, 5, 153, TO_DATE('16-AUG-2015','DD-MON-YYYY'));


--Product
INSERT INTO product (product_id, product_name, price, department_id) VALUES (1, 'Monitor', 149.95, 4);
INSERT INTO product (product_id, product_name, price, department_id) VALUES (2, 'Desk', 110.9, 4);
INSERT INTO product (product_id, product_name, price, department_id) VALUES (3, 'Chair', 79.95, 4);
INSERT INTO product (product_id, product_name, price, department_id) VALUES (4, 'Accounting Plus', 60.45, 5);
INSERT INTO product (product_id, product_name, price, department_id) VALUES (5, 'Microsoft Office', 121.15, 5);
INSERT INTO product (product_id, product_name, price, department_id) VALUES (6, 'Antivirus Extreme', 48.5, 5);
INSERT INTO product (product_id, product_name, price, department_id) VALUES (7, 'Photo Editing Pro', 250, 5);
INSERT INTO product (product_id, product_name, price, department_id) VALUES (8, 'Web Tools 4', 202.5, 5);



--Customer
INSERT INTO customer (customer_id, first_name, last_name, address_state, email_address) VALUES (1, 'Teresa', 'Hudson', 'NY', '[email protected]');
INSERT INTO customer (customer_id, first_name, last_name, address_state, email_address) VALUES (2, 'Fred', 'Montgomery', 'CA', '[email protected]');
INSERT INTO customer (customer_id, first_name, last_name, address_state, email_address) VALUES (3, 'Lois', 'Lawson', 'OR', '[email protected]');
INSERT INTO customer (customer_id, first_name, last_name, address_state, email_address) VALUES (4, 'Alice', 'Perry', 'SC', 'aliceperry');
INSERT INTO customer (customer_id, first_name, last_name, address_state, email_address) VALUES (5, 'Ralph', 'Montgomery', 'TX', '[email protected]');
INSERT INTO customer (customer_id, first_name, last_name, address_state, email_address) VALUES (6, 'Dorothy', 'Armstrong', 'OR', '[email protected]');
INSERT INTO customer (customer_id, first_name, last_name, address_state, email_address) VALUES (7, 'Fred', 'Wallace', 'NY', '[email protected]');
INSERT INTO customer (customer_id, first_name, last_name, address_state, email_address) VALUES (8, 'Joseph', 'Bell', 'FL', '[email protected]');
INSERT INTO customer (customer_id, first_name, last_name, address_state, email_address) VALUES (9, 'Lois', 'Martinez', 'CALIF', '[email protected]');
INSERT INTO customer (customer_id, first_name, last_name, address_state, email_address) VALUES (10, 'Robert', 'Rice', 'IN', 'robrice123');



--Customer Order
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (1, 3, 2, TO_DATE('18-DEC-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (2, 5, 6, TO_DATE('1-JUN-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (3, 6, 5, TO_DATE('26-SEP-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (4, 9, 1, TO_DATE('8-SEP-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (5, 7, 2, TO_DATE('13-APR-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (6, 5, 7, TO_DATE('4-FEB-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (7, 9, 7, TO_DATE('11-APR-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (8, 6, 8, TO_DATE('27-JUN-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (9, 2, 7, TO_DATE('23-JAN-2017','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (10, 8, 7, TO_DATE('7-NOV-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (11, 2, 2, TO_DATE('9-JUN-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (12, 9, 7, TO_DATE('4-JAN-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (13, 5, 5, TO_DATE('22-APR-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (14, 9, 2, TO_DATE('14-SEP-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (15, 7, 1, TO_DATE('7-DEC-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (16, 5, 4, TO_DATE('17-OCT-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (17, 9, 6, TO_DATE('14-MAR-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (18, 9, 4, TO_DATE('9-JUL-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (19, 6, 2, TO_DATE('6-MAY-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (20, 3, 5, TO_DATE('10-JUL-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (21, 9, 5, TO_DATE('13-APR-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (22, 6, 7, TO_DATE('18-JAN-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (23, 7, 8, TO_DATE('1-AUG-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (24, 6, 2, TO_DATE('21-JAN-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (25, 6, 5, TO_DATE('12-APR-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (26, 8, 5, TO_DATE('7-SEP-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (27, 5, 1, TO_DATE('25-APR-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (28, 7, 5, TO_DATE('30-AUG-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (29, 5, 3, TO_DATE('27-AUG-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (30, 8, 3, TO_DATE('14-APR-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (31, 3, 3, TO_DATE('24-MAY-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (32, 7, 4, TO_DATE('4-MAY-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (33, 2, 1, TO_DATE('28-OCT-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (34, 8, 5, TO_DATE('4-APR-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (35, 5, 4, TO_DATE('12-OCT-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (36, 5, 4, TO_DATE('26-NOV-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (37, 6, 7, TO_DATE('31-DEC-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (38, 7, 6, TO_DATE('22-NOV-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (39, 6, 3, TO_DATE('8-FEB-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (40, 10, 4, TO_DATE('16-JAN-2017','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (41, 9, 4, TO_DATE('5-APR-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (42, 6, 1, TO_DATE('8-FEB-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (43, 8, 6, TO_DATE('30-SEP-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (44, 6, 2, TO_DATE('17-NOV-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (45, 6, 5, TO_DATE('5-JAN-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (46, 2, 3, TO_DATE('30-JAN-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (47, 3, 4, TO_DATE('15-DEC-2015','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (48, 9, 3, TO_DATE('21-JAN-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (49, 5, 1, TO_DATE('20-JUL-2016','DD-MON-YYYY'));
INSERT INTO customer_order (order_id, customer_id, product_id, order_date) VALUES (50, 7, 3, TO_DATE('14-JAN-2016','DD-MON-YYYY'));


COMMIT;

3. Wykonaj pierwsze zapytania SQL

SELECT * FROM employee;
SELECT * FROM department;
SELECT * FROM customer;
SELECT * FROM product;
SELECT * FROM customer_order;