text: USE employeeDB;
  
  INSERT INTO department (name)
  VALUES ('Sales'), ('Engineering'), ('Finance'), ('Legal');
  
  INSERT INTO role (title, salary, department_id)
  VALUES ('Sales Lead', 100000, 1), ('Salesperson', 80000, 1), ('Lead Engineer', 150000, 2), ('Software Engineer', 120000, 2), ('Accountant', 125000, 3), ('Legal Team Lead', 250000, 4), ('Lawyer', 190000, 4);
  
  INSERT INTO employee (first_name, last_name, role_id, manager_id) 
  VALUES ('Lauren', 'Jones', 1, null), ('Paul', 'Johnson', 3, null), ('Chris', 'James', 4, 2), ('Chris', 'Mann', 6, null), ('Johnny', 'Black', 2, 1), ('Leonard', 'White', 2, 1);